TM1 Forum

Hi Guys,
I have a Cube(CUBE A) with 4 Dim's which is holding some measures and this Period Dim is at Yearly Level(2010,2011..) And There is Other Cube B with 4 Dim but the Period here is at Monthy Level (01-2011,02-2011..)

For Calculating a measure Lots in CUBE B needs to be "Avg Lot-SIZE from Cube A at yearly level must be coming to Lots at Monthly Level in Cube B"

If Avg Lot Size in Cube A is 120 in 2011 then in CUBE B for all Months of 2011 in Cube B should populate with 120

Am bit confused writing this rule...can any one give a Hint???
Please refer to picture if u i messup something here..
Sorry if i confuse u..

Thanks

Something like

['Lots']=N: DB ('Cube A' , .... Attrs (''P_Period' , !P_Period, 'Year') , ........);

So set up a string attribute on P_Period that contains the Year you need to reference in zCP_Period

If you need to feed this you'll need to start in Cube A

['Avg Lot Size'] => DB ('Cube B ' , .....'Lots' , !zCP_Period , .....);

This will only work if the elements of zCP_Period are annual consolidations in Cube B, ie. in !P_Period there is a C level 2011 that is a sum of all elements that have their year attribute=2011.

Edit Corrected 2001->2011
HTH

Sir,
You made my Day....haha this so good..
Thank you... appreciate this