Getting data from Cognos TM1 via REST API
<p>I'm working with IBM Cognos Tm1 REST API. 
I need subset of the data values contained in a cube (Cube1 for example).</p>

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

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

<p>However, I obtain much more cell values than I need. 
My questions are:</p>

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