Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script logic *DESTINATION_APP and Time Dimension remapping

I have two applications that don't share the time dimension. Source has a daily time structure and Destination has months as base level members.

I need to move data from one to another and in order to do the mapping I have a property on daily time dimension that maps each base level member (a day) to a base level member on monthly time dimension. Part of the logic is below:

*DESTINATION_APP=LEGAL

*RENAME_DIM DAILYTIME=TIME

*WHEN *

*IS *

*REC(DAILYTIME=DAILYTIME.MONTHID)

This kind of mapping always worked for me except it is the first time I need to remap a time dimension. Logic validates correctly but it doesn't run as it can't move beyond the SQL step that collects data from the destination area. It complains about time dimension invalid members.

To double check I don't have a installation issue I did the same kind of mapping with other pair of dimensions and hard coding the destination time dimension member:

*DESTINATION_APP=LEGAL

*SKIP_DIM=DAILYTIME

*ADD_DIM TIME=2010.MAY

*RENAME_DIMENSION SALESENTITY=ENTITY

*WHEN *

*IS *

*REC(SALESENTITY=SALESENTITY.ENTITY_MAP)

This works. I wonder if BPC is failing because at the DB level it deals with TIMEIDs in the fact table.

So question is: Has anybody else faced this kind of limitation with *DESTINATION_APP? If so how did you solve it?

Thanks

Paulo

Former Member
Not what you were looking for? View more on this topic or Ask a question