steps to to enhance the existing cube and get the data from r/3

[Mirna]

Hi all,

I am at entry level.

If i want to enhance an existing cube and pull data from R/3 into the cube what are the main steps i do?

In my scenario - this is SD module. The infocude is custom cube(CONTRACT cube) . I have to enhance this existing custom cube with new info objects. The person who had created this cube years ago has used generic data source .

Please explain me the main stepd i need to do in R/3 till i get it to BI.

Thanks in advance.

Mirna

[Portal]

Hi Mirna,

* check if you can enhance the existing generic data source to bring data for new info objects or if those fileds are aleady existing in the data source - if existing, you will have to make changes only in BW side, if not, you will have to first modify the generic data source

* if you have modified the data source, relicate data source at BW side
* create new info objects and add those to cube > activate info cube
* map the info objects with fields in data source > activate tranformation
* test it by loading the data

now you will have to move these changes to produciton;
* move the data source changes to R/3 production system (if applicable)
* replicate data source in BW production system
* move the BW transports to production system
* you will have communicate to the uses that data will not avialable for some time or you need to reload data in cube in off business hours or on a weekend
* delete data from info cube
* initialize delta without data transer
* do a full repair to the cube
* now you can run delta on a daily basis

I hope it helps.

Regards,
Portal

[Mirna]

Thanks Portal,

One more question: do we need full repair?

Tell me if i am wrong. Here in this context, full repair takes care of full load. I think full load is not active at this point so we do full repair which gets all the records and after this delta will take care of next records coz of init set up.

Please correct me.

Regards,
Mirna