TM1 Forum

Hi All,

i need to able to check if a consolidation contains zero or not with a TI process (or calc if need be)- what i have to do is check whether a value exists against every element of a dimension and set a flag if it does- so far its worked fine for N level elements but it is not working for C level elements- i can only imagine this is because Consolidations do not have values posted against them but derive them by summing it's children.

In effect i need to ask it whether the result of the consolidation is not zero but what the TI process seems to be doing is read the C Element as 0 whether its children total 0 or not.

not asking for any code or anything just want to know if its possible to read the resulting value of C level element because im thinking that TM1 is not set up to work this way and need to start thinking of an alternative solution to my problem.

cheers

Dubs,
Can you post how you are looking? This should be pretty straightforward.

If you are using a view as a data source and need to see C level values in it, make sure that you have not checked the Skip consolidations box in the view definition. If this is a the problem make sure you set all the other dimensions to level 0 or you might end up with a massive data set.

Cheers

Hi Sterve,

Yes i think this is it- unfortunately unchecking the box aseems to send the process into an infinite loop but logically this makes perfect sense, just need to fix the proc now- will let you know if i crack it.

cheers

Steve, this has worked!

thankyou thankyou thankyou!