First period in time consolidation

[Maxon]

Hi!
Cube consist of two dimensions: balance and time.
Time has hierarchy:Year 1->Q->Months...Year n->Q->Months
For the 1 item of balance for the all Quarterly values instead of Consolidation(summation) i'll take first months of quarter.
I have 10 years with quarter and months.
How i can calculate this values automatically with function?

[David Usherwood]

Create and populate an attribute to link the quarter back to the first month.
Depending on your naming convention you may be able to write a rule in the attribute cube to to the link automatically.

[Maxon]

Create and populate an attribute to link the quarter back to the first month.
Depending on your naming convention you may be able to write a rule in the attribute cube to to the link automatically.

Can you give me construction of this expression?

[David Usherwood]

If you post some examples of your dimension, yes.

[Michel Zijlema]

Hi!
Cube consist of two dimensions: balance and time.
Time has hierarchy:Year 1->Q->Months...Year n->Q->Months
For the 1 item of balance for the all Quarterly values instead of Consolidation(summation) i'll take first months of quarter.
I have 10 years with quarter and months.
How i can calculate this values automatically with function?

You could use a rule to override the standard hierarchy consolidation with the value of the first month of the quarter, f.i.:

['balance'] = C: IF(ElLev('period',!period) = 1, DB('Cube', ..., ElComp('period', !period, 1), ...), STET);

where ElLev determines the level of the element in the hierarchy and the quarters are assumed to be on level 1 and where ElComp determines the first child of the consolidated (quarter) element. If tha same logic applies to years (take first quarter) you could use ElLev('period',!period) > 0 instead of ElLev('period',!period) = 1.

Michel