Hi All,
Is there anyway with which we can group the cells calculated based on different rules?
Example:
Cells are having data in cube are based on two different rule statements.
I want to get the cells which are calculated based on rule1 separately and cells calculated based on rule2 separately.
Regards,
Deepak Jain
Cells derived from which rules
-
deepakjain2020
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Cells derived from which rules
Subsets or consolidations.
You could even use an attribute to state which type of calc is occuring. Reference the attribute in the rule to decide which method is used.
Then your subsets can be mdx driven based on the attribute. Or your consolidations can be TI created based on the attribute.
You could even use an attribute to state which type of calc is occuring. Reference the attribute in the rule to decide which method is used.
Then your subsets can be mdx driven based on the attribute. Or your consolidations can be TI created based on the attribute.
Declan Rodger