[Rules] Hold Value from Leaflevel on Consolidated Level?

[Roger_Lewin]

Good Morning everyone from Germany,

I'm trying to describe what i want to do...

What I've got:
* A Cube with 6 dimensions, two of them are 'Year' and 'Month'
* A Value on leaflevel depending only on Year and Month, the Measure is "Price"

What i want to do:
* I want to write a Rule, which causes that this Value is not changed if i navigate through some of the other 4 dimensions (drill up/down along the hierarchy), as the price is only dependent on year and month

How can i do this?

Regards
Roger

[David Usherwood]

This one seems a bit odd to me, but you haven't said what you need the price for at higher levels. Remember that TM1 does most of its work at N level - C level rules are quite problematic. ('blank' rules such as KPIs are fine though.)
Think this comes down to working which n level element where the price is stored relates to each of the c level elements further up.
Or....
If you hold your prices in a secondary cube with less dimensions, just pull them in with a DB() reference.