Page 1 of 1
First period in time consolidation
Posted: Tue Jun 15, 2010 10:58 am
by 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?
Re: First period in time consolidation
Posted: Tue Jun 15, 2010 11:13 am
by 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.
Re: First period in time consolidation
Posted: Tue Jun 15, 2010 11:24 am
by Maxon
David Usherwood wrote: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?
Re: First period in time consolidation
Posted: Tue Jun 15, 2010 12:35 pm
by David Usherwood
If you post some examples of your dimension, yes.
Re: First period in time consolidation
Posted: Thu Jun 17, 2010 12:37 pm
by Michel Zijlema
Maxon wrote: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