Skip to Content
0
Nov 13, 2009 at 05:05 AM

LOOKUP - TIME Dimension

22 Views

Dear Experts,

I am trying to retrive all months in below LOOPUP code.

*LOOKUP Test

*DIM HC:PC_ACCOUNT="HR_HC"

*DIM HC:PC_PLANNINGTYPE="CM_EST"

*DIM HC:PC_CATEGORY="BUDGET_2010"

*DIM HC:PC_DATATYPE="C_INPUT"

*DIM HC:PC_TIME=PC_TIME.REF

*DIM HC:MEASURES="PERIODIC"

*ENDLOOKUP

For PC_TIME.REF, showing warning in DM Package log saying that "all base members are retriveing"

In above LOOKUP, Can i send all 12 months ?Some thing like below..

*LOOKUP Test

*DIM HC:PC_ACCOUNT="HR_HC"

*DIM HC:PC_CATEGORY="BUDGET_2010"

*DIM HC:PC_TIME=2010.JAN,2010.FEB,2010.MAR.......

*DIM HC:MEASURES="PERIODIC"

*ENDLOOKUP

Please help me...

Edited by: S.KumarBPC on Nov 14, 2009 8:40 AM