Sum in TM1 Rules based on Attribute

[ARNOJ]

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

[AmbPin]

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

[ARNOJ]

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

yes the parallel hiearchy based on the attributs

[RJ!]

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...

[Wim Gielis]

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