DTP: Master Data Attribues to Cube

[Former Member]

Dear Experts,

I have a scheduled data transfer process to load master data attribues of a characteristic in an infocube but this infocube does not have the entire historical data. This may mean I have "more" master data than is required to store data in the cube at a given point in time with complete non blank valuee of records. I now need to create CVC's based on this infocube but I get a message "no planning object is created", precisely because not all transaction data exists in the cube (but master data and its attributes does... blank values)

To help visualize, I have product in the infocube. An infopackage loads the same with the corresponding key figure data. I now load an attribute of product called product group to the product char (direct update). I now schedule a DTP to load the infocube that has product group in the product dimension.

Questions:

-Am I doing something wrong.. non standard ?

-How can I create CVC's only for those records that are non blank in infocube ? (seletions not equal to blank in MPOS). I need this attribute in CVC.

The end objective is creation of CVC's from this infocube and that too valid ones at any given point in time.

Thanks

Guru

[Former Member · Accepted solution]

Hi Guru,

Kindly check whether the MPOS of ur corresponding CVCs is in active state or it has to be still activated as this might be the reason for the error message.

Thanks

Ankit

[Former Member · Accepted solution]

Thanks Ankit,

The root problem I realized I didnt activate master data for the Infoobject, having loaded the same. I also realized I dont need a DTP to load attributes of master data to the infocube that contains my historical sales data. The SID to DIM ID link takes care of this. (This is how system teaches the clueless users like me the real meaning of star schema :-).

What is needed is just the activated master data. IF the master data (attributes) exist in the infoobject the same can then be seen in corr. dimension char of the infocube. If there is limited master data (attributes) than is required for the existing data in the infocube, CVC's cannot be created with reference to this infocube... which is understandable. If there is more, no problem.

Thanks

Guru