TM1 Forum

Morning

In an ccount dimension, I would like to do a KPI which sum others account depending on the attribute.

By exemple
Dimension Account
Acc1 Attr1 Value : 10
Acc2 Attr2 Value : 30
Acc3 Attr1 Value : 40
Acc4 Attr1 Value 50

KPI based on Attr1 : 100

I have the following idea :
Solution 1 Use TM1 Rules with an IF and the function consolidatechildren but I think I will an issue with the performance
Solution 2 : Declare in performance modeler all the account in the dimension and have KPI : Acc1+Acc2+Acc4
Solution 3 : Do a subset with MDX and have a rollup
Solution 4 : Use a TI Process to do so

My client wants to have something dynamic which mean each time I change the attribute of the account dimension the calculation is redone automaticly

Any other solution in mind

thanks you

Depends on how the "client" is changing the attribute but my preference would be for an alternative dimension hierarchy.

Like each client say it is "not often" but we all know what it means

yes the parallel hiearchy based on the attributs

Not an immediate solution, but I think the new Attribute Hierarchies might resolve this for you without rules.

I'm sure I'll be quickly corrected but I think that will be in FP4 that is due this month...

Hello,

Go for the classic solution in this area:
- allow the client to change the attributes (for instance, create an active form)
- add a process with an Action button that recreates the hierarchy based on the attribute values.
DimensionElementComponentDelete and DimensionElementComponentAdd will do the majority of the work in TI.
- the client clicks on the button and can review the new results

Wim