Getting data from Cognos TM1 via REST API

I'm working with IBM Cognos Tm1 REST API. I need subset of the data values contained in a cube (Cube1 for example).

So, I'm executing a view (View1 for example) and obtain a cellset.

http://server:port/api/v1/Cubes('Cube1')/Views('View1')/tm1.execute?$expand=Cells($select=Ordinal,FormattedValue,Consolidated) 

However, I obtain much more cell values than I need. My questions are:

• Can I create my own view via REST API only? (And how?)
• Can I ask API to return only not consolidated values?
• Can I obtain cell value in some other way, without views?

You create dynamic views using TM1 Java APIs. You can find detailed documentation in \tm1_64\TM1JavaApiDocs\

or by default its

C:\Program Files\ibm\cognos\tm1_64\TM1JavaApiDocs

and sample codes are located in C:\Program Files\ibm\cognos\tm1_64\tm1api\samplecode\java

Hope this helps you.