Logic help: 27 Member Time dimension to 12
I am trying to write logic that will move salary information from an application with a 27 member time dimension to an application with a 12 member time dimension. In other words, I am trying to move data from a biweekly HCM cube to a monthly FINANCE cube.
Dimensionality of the cubes is the same, except the HCM cube has JobCode and Employee dimensions that are not present in my FINANCE cube. In HCM the account dimensions is HRACCOUNT and the time dimensions is TIME_27Periods. In FINANCE the account dimension is ACCOUNT and the time dimensions is TIME.
Can I do this with script logic? To get started I am trying to move Period 1 to January. This is my logic:
*XDIM_MEMBERSET HRACCOUNT="SALARY" *XDIM_MEMBERSET TIME_27Periods=%SET% *CALCULATE_DIFFERENCE=0 *DESTINATION_APP=FINANCE *SKIPDIM=EMPLOYEE *SKIPDIM=JOBCODE *RENAME_DIM HRAccount=Account *RENAME_DIM TIME_27Periods=Time *WHEN TIME_27Periods *IS "Per1" *REC(EXPRESSION=%VALUE%,TIME_27Periods="2009.JAN",HRACCOUNT="410") *ENDWHEN *COMMIT
Can this work? Can I use time periods in *WHEN statements? My DebugLogic.log file says "No record to process", although I can find the records in tblFACTWBHCM. Nothing in tblFACWBFINANCE.
Thanks for your help...Marv