Hi - new to TM1 and I am attempting to create a cube calculation unfortunately the attempt has failed.
I have added a text member to my Price_and_Cost_Measures dimension to indicate if a product type is unprofitable. This seems fine, however the cube calculation I have created has failed, as I have tested it with figures that are unprofitable, however "Unprofitable" does not appear in my Product Status text member as I would like it to.
Please refer to the screenshot and thank you in advance for your help.
Cube calculation not working
-
compilersaysyes
- Posts: 9
- Joined: Fri Oct 24, 2014 11:08 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 15.0.4659.1001
Cube calculation not working
- Attachments
-
- result (failed cube calculation)
- result.png (316.73 KiB) Viewed 2410 times
-
- code for cube calculation
- cube_calc.png (344.95 KiB) Viewed 2411 times
-
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: Cube calculation not working
I may be missing something but your rule requires "Unit Cost" and "Unit Sale Price" to BOTH not be zero in order to show "unprofitable" (in addition to a negative profit) but in the screenshot every "Unit Sale Price" is zero... therefore I wouldn't expect any cell to show "unprofitable".
Declan Rodger
-
compilersaysyes
- Posts: 9
- Joined: Fri Oct 24, 2014 11:08 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 15.0.4659.1001
Re: Cube calculation not working
ah...so sorry I see this now. Thank you so much for your help!
best
best