Hello TM1 Gurus,
I am trying to build a cube in TM1 where the consolidated numbers of certain measures are calculated using Max() function.
This is an easy problem to solve using Cognos Transformer / PowerPlay, however I am having troubles implementing it using TM1.
I have reviewed previous posts on this forum and have not found a post that would address this specific issue.
By default, TM1 only supports sum (Total) based consolidation. There is a suggestion that the new version of TM1 (9.5.2) includes new functions that might help, but I am stuck with TM1 9.5 (CX 9.5).
I understand that the TM1 does not store consolidated numbers, only the bottom level numbers. Based on that, I am assuming that the Max() based consolidation would need to be implemented using rules (not by TI process).
I am interested in finding out a generic approach that could be used to solve this type of requirement. However, here is a specific business problem:
The relational database includes a list of records where each record represents a medical surgery.
One of the fields in the database is surgery wait time.
I am trying to build a reporting cube that would allow to report a maximum wait time for various cube views (different subsets from different dimensions).
The cube structure would look like this:
Dimensions:
Surgery Date (Date --> Month --> Quarter --> Year)
Surgery Location (Hospital --> City --> Region --> State)
Surgery Type (Medical Condition --> Procedure --> Type of Surgery)
Patient Age (Age -->Age range)
Measures
Cost (Total-based consolidation)
Avg. Wait Time
Max. Wait Time
Any thoughts regarding possible approach of solving this issue in TM1 would be much appreciated.
Thank you,
mpal
Paid Advertisement:
