TM1 Forum

Sorry for really dummy questions.
1. What is Populated cell? Is it non-zero cell? (failed to make a valid request to searchers)
2. Is in TM1 function like ISFED that checks if cell is fed or not? (failed again)

ioscat wrote:Sorry for really dummy questions.
1. What is Populated cell? Is it non-zero cell? (failed to make a valid request to searchers)
2. Is in TM1 function like ISFED that checks if cell is fed or not? (failed again)

1 - Yes, a populated cell is a cell which has something in it (be it a value or string.)

2 - No.
But you can create an identical dummy cube with 1 rule that says if the cell has a value in the original cube the "dummy" cube should be 1 otherwise 0.
And feed that from the orginal cube, suppress zeroes. Only values that are fed in the original cube are able to feed the "dummy" cube.

There may be a much easier way to check if cells are fed however, of course "check feeders" works to some extent but I tend to just check by putting values through and seeing if the summarys look as they should do.

If the cube has ever been saved with UNDEFVALS; in the rule then a populated cell can have a zero in it. In this case unpopulated cells will appear in the grid as blank. Once you put a number of any sort in a cell it will then continue to be populated. There is no UI gesture to delete the value and "unpopulate" it. UNDEFVALS; is the default for cubes created in Insight and Performance Modeller.

See http://publib.boulder.ibm.com/infocente ... fvals.html.