Check if Consolidation is not zero

[dubs]

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

[Steve Rowe]

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

[dubs]

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

[dubs]

Steve, this has worked!

thankyou thankyou thankyou!