Using TI - Cells Updated with Number

[kkmk]

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.

[Wim Gielis]

Hello

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

The ViewExtractSkipZeroesSet can do this.

[kkmk]

Thank you. It works!!

kkmk.