Skip to Content
author's profile photo Former Member
Former Member

how to enhace business content extractor for cube in production

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2006 at 05:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.