TM1 Forum

I have two dimensions, Region and year.
Region
----Region1
----Region2
----Region3

Year
----2009
----2010
----2011

I have value100 for the combination of {Region1, 2009}, {Region2, 2010}, {Region3, 2011}. I have given the view as data source. Now I want to write a TI process that all the cells updated with a value 1. I have written a TI CELLPUTN function to achieve this. CELLPUTN(1, 'Cube Name', vRegion, vYear); But it updates 1 wherever there is a value already i.e., {Region1, 2009}, {Region2, 2010}, {Region3, 2011} combination have the updated values. How to do this using TI?

Thanks in advance.
kkmk.

Hello

By default, the zero values are skipped in the view.

The ViewExtractSkipZeroesSet can do this.

Thank you. It works!!

kkmk.