Need help on reading tm1 cube through Java API

[naveenk]

Hi Geeks,

We have a requirement to read entire cube( all elements of all dimensions) and then flattened out cube data to a flat file using Java program. We have used Java based API to read cube. But, When we are reading cell values directly through a cube then its taking lot of time as cube is large and it has lot of null values( AS ZERO). So, performance is hitting over here.

We wanted to read only those elements which does contain some values, meaning suppressing zeros. So, only legitimate values require to read.

Since, there is no property for TM1Cube type which can enable use to fetch only those combinations where values exists and suppressing zeros. So, we thought of using Views to read it as it has suppress zero property. So, we created a TM1 View from cube having all dimension and all elements of each elements through java APIs. But, when we are trying to read. its giving error. Its returning error type of TM1 Val.

We were able to create view through JAVA API but unable to read it.

Could any one of you please help us on this? How can we read entire cube as View while suppressing zeros or read a view crated as all elements of all dimension and then read it while suppressing zeros.

Thanks,
-Naveen

[daniel.pinto]

Naveen,

Can u paste the sample code you have used to read the view?.