TM1 Forum

Would CELLGETS function work on thoese cells to get values? In my example, I can see this funtion skips all these kind cells. Can someone help to explain?

CellGetS is a TI function to return values from a cube cell that has been configured to hold string values. If the cell in question is empty then the function will return a null value. If the cell is not configured to hold strings then the function will return a null value, regardless of what is in the cell. FWIW, the CellGetS and CellGetN functions do not "skip" anything.

tomok wrote:CellGetS is a TI function to return values from a cube cell that has been configured to hold string values. If the cell in question is empty then the function will return a null value. If the cell is not configured to hold strings then the function will return a null value, regardless of what is in the cell. FWIW, the CellGetS and CellGetN functions do not "skip" anything.

Thanks, Man. I have figured out where the problem is. In the Data soure view which I have created, the default "Skip" option selects "Skip Consolidated Values" and "Skip Zero/Blank Values". If I unchecked "Skip Zero/Blank Values", the function can find all these empty measures and it would not skip them anymore.


Cheers