cancel
Showing results for 
Search instead for 
Did you mean: 

how to enhace business content extractor for cube in production

Former Member
0 Kudos

Hi All,

I want to run report based on 0MATERIAL on two cubes 0PCA_C01 and ZCOPC_C08. I dont have 0MATERIAL in cube 0PCA_C01.

Both of the cubes are in production. I am trying to enhance the data source 0EC_PCA_1 (for cube 0PCA_C01) to bring in 0MATERIAL.

> Is this the right way to do it?

If it is then, do i need to write the code in funciton module after appending the 0MATERIAL fields to the

data source. does any body have the code or plz help me step by step to write the code in CMOD....which tables should i go to get the 0MATERIAL.

> Most importantly, does enhancing the datasource 0EC_PCA_1 with omaterial affect the omaterial in the datasource for my second cube (can the same infoobject be in two data sources..bcoz master data is common for all cubes)....

I want to do this right....as both the cubes are in production.....plz help me..

Plz address any issues like data loss bcoz of enhancing datasource in production or something like that

thanks in advance,

> useful inputs will be rewarded

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Aravind,

Enhancing the data source to have the material and then including 0material is the correct way. One point you should think of is you might need to drop and load the data. One more point I can think of is the material data itself. Though MARA is the material master data table, you might want this material to come as a transactional data into the cube. So, you need to pick it up from the table from where the extractor is getting the data or with some other table which has a foreign key relationship with the material number. Hope this makes sense.

Thanks and Regards

Subray Hegde

Former Member
0 Kudos

Hi Subray,

thanks for your reply....

> How do i bring in material as transactional data into the cube ? can you explain it futher?

> is it possible without dropping the cube data?

> If i need to drop the data in the cube..i might aswell go ahead and enhance the datasource and do a full load...which is the best way? I have nearly 6 million records..

> is it possibe to create a Zmaterial and then feed it with 0material as data source...is delta load possible in such case?

thanks in advance

Former Member
0 Kudos

Hi Aravind,

You need to have a foreign key relationship with the base data to material to bring material no as a transaction data. There has to be a link from where you can extract the data. FIrst you see if this link is available in any other ods in BW itself. For example, if you have the vendor details in your cube, see if you can get the material from the AP ods. this depends on your implementation.

If you do not drop the cube load, how will this value be updated to the old data. Assuming you are doing deltas, the new records coming in will have this data filled but the data that already sxisted will not have this data. So, I think you will need to drop the load.

I know the amount of data could be huge but if you have to get the data from R/3 (this is if the data/link i mentioned above is not available in BW), you have to enhance the data source. In this case, you can not avoid datasource enhancement.

You can create a Zmaterial and load it from 0material. This will not help you. By doing this, you will be creating another master data. Even if you include this master data zmaterial in your cube, since you can not map it in the update rules, it will not help you. See if you can lookup this value from some other ODS.

Hope this helps.

Thanks and Regards

Subray Hegde

Answers (0)