TM1 DataSource Value

[dharav]

Hello All,

I have a Source Cube:
[img]

Source.JPG (39.91 KiB) Viewed 2906 times

[/img]

I need Following View from Source Cube:
[img]

SourceView.JPG (41.37 KiB) Viewed 2906 times

[/img]

I utilized: ViewRowSuppressZeroesSet and i got the view i needed.

Now, I assigned this sourceview as datasource in TI process to write data in to a text file (for debug process).
Data received in the file did not include zero value at highlighted (yellow) data intersection.
IF i write in Prolog
ViewExtractSkipZeroesSet (pCube, vView, 0) to bring 0 value data than it will bring all 0 value data including which was suppress zero.

E.g.: It will bring data at yellow intersection ((Apr, Total Expense,NJ1,Forecast)=0) & also
(Jan, Total Interest,NJ1,Forecast)=0) & (Feb, Total Interest,NJ1,Forecast)=0) & (Mar, Total Interest,NJ1,Forecast)=0) & (Apr, Total Interest,NJ1,Forecast)=0) & (May, Total Interest,NJ1,Forecast)=0) & (Jun, Total Interest,NJ1,Forecast)=0) & (Jul, Total Interest,NJ1,Forecast)=0)). I just need (Apr, Total Expense,NJ1,Forecast)=0) in the output text file.

Please feel free if you require further information.

Thank You

Dharav

[tomok]

ViewRowSuppressZeroesSet is meaningless in a TI because there is no concept of rows OR columns in a TI process that is sourced from a cube view. It is only valid in a cube view while in the user interface (Perspectives, Architect, TM1Web). A TI view is always treated as a flat source, meaning you get one record for every intersection. If you have zeros suppressed via ViewExtractSkipZeroesSet then any intersection that is zero WILL NOT BE PROCESSED BY YOUR TI. There is no way to get what you want natively in a TI. The only way to get what you want is to create the view from a rollup of the year and then inside the TI do 12 individual CellGetN's to get the value for each month.

[mattgoff]

ViewRowSuppressZeroesSet is meaningless in a TI because there is no concept of rows OR columns in a TI process that is sourced from a cube view. It is only valid in a cube view while in the user interface (Perspectives, Architect, TM1Web). A TI view is always treated as a flat source, meaning you get one record for every intersection. If you have zeros suppressed via ViewExtractSkipZeroesSet then any intersection that is zero WILL NOT BE PROCESSED BY YOUR TI. There is no way to get what you want natively in a TI. The only way to get what you want is to create the view from a rollup of the year and then inside the TI do 12 individual CellGetN's to get the value for each month.

Anyone else notice that views saved from the cube viewer have unpredictable column order when used by TI? That is to say, the order is always the same but it does not necessarily match the dimension order. Conversely, views created by Export As Text Data always show in dim order in TI. I keep meaning to raise this to IBM to see if it's intentional or a bug.

Matt

[dharav]

Thank You @tomok and @ mattgoff

@tomok: I had placed 12 cellgetn function to retrieve the value of each month for other specific variable and utilize as a filter.
It has been working well for me.


Thanks

Dharav