Distinguish Between Consolidations and Calcs at C: Level

Post Reply
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Distinguish Between Consolidations and Calcs at C: Level

Post by John Hammond »

Hi Folks

Does anyone out there know if there is a way to distinguish programatically between Consolidations and Calcs done at C: level ?

Its easy enough to do at N level you simply use ISCELLUPDATEABLE but I don't have a way of doing this at the C: level.

As ususal all suggestions gratefully received.

John
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Distinguish Between Consolidations and Calcs at C: Level

Post by lotsaram »

With the API you can determine if a rule is attached to a cell but not in TI.

Is this a theoretical question or have you come up against this and have an actual need to do this in a process, what are you trying to do?
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Distinguish Between Consolidations and Calcs at C: Level

Post by John Hammond »

Thanks Lots-a-Ram

We are simplifying rules in a production system and to confirm we do not alter the results we dump the calcs and do a before and after compare.

This is easy enough for N level calcs.

I think I have found a way round the problem for C level calcs in that we should only dump the slice that contains the C level calcs - this means that the number of consolidations can be greatly reduced and an output of manageable size generated. However it means a different slice for each calc whereas the N level calcs can be handled by a dump and compare of all N level calcs.

It would be handy if IBM would give us all the API functionality in TIs tho.

Regards

John
Post Reply