Skip to Content

Master data not present in the reporting cube

Dear Experts,


There is a scenario in report design for me.
I have already created the Bex report and all the fields as mentioned are in the sales report.

Client now wants to include two more fields in the report.
One is the keyfig " Net value" which is present in the sales cube and i have already included in the report
and another field which is master data 0profit_center is not present in the cube.

Any ideas how can i include this 0profit center data so that i can display in the report?
As far as i understand, I need to include this master data in the sales Infocube which is being used for reporting.
But i am pondering upon the impact on the system because of this.

Now i have checked the BI system and the ECC table. In VBRP table of ECC, the profit center is present.
But when i see in BI the profit center is not being loaded from ECC but from flat file source system.
So i am confused how to go forward.

Can anyone suggest me what should be my approach?
Best Regards!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jul 24, 2014 at 06:31 AM

    Hi,

    Check your info objects(if have master data) which are part of cube, have attributes along with 0profit_ctr then you can use that as navigational and use at cube level and reporting level. You need to mark those(navigational) settings at info object level and cube level.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2014 at 06:45 AM

    Hi,

    0PROFIT_CTR is the main object under compounding attr controlling area and attr source system, source system id, person responsible.

    are you 0PROFIT_CTR object cube level if yes just check the cube level and MP assignment.

    it is some other object of attr convert to form display to navigational attr.

    check it cube and MP assignment.

    check the report.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2014 at 07:01 AM

    For reference of both Rama and Pani,
    below is the screenshot. Thanks!


    profit center.JPG (74.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • You didn't understand what we suggested.

      Rather than checking 0profit_ctr master data, you need to find the info objects(which are part of your cube) which have master data. in those 0profit_ctr can be a attribute. if yes then navigation settings will work.

      if not then you can add 0profit_ctr to info cube and user master data look up thru routine or option read from master data(bw 7.3).

      Other wise, directly add 0profit_ctr to your flat file data source(and cube) and maintain data thru flat file.

      To look up your cube and 0pfirt_ctr need to have relations with another info objects other wise not possible.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2014 at 07:36 AM

    Hi Aparajit,

    I would suggest go to RSD1, check for where used list for 0PROFIT_CTR. You will get list of object where profit center is used. Then you might get a clue of adding suitable infobject in the infocube/DSO. You can also check for Netvalue, in this list of DSO/Infocube where 0PROFIT_CTR is already present.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2014 at 09:22 AM

    Hi,

    <Now i have checked the BI system and the ECC table. In VBRP table of ECC, the profit center is present.> - This field you should first add to the extract structure , then the data source. Replicate the data source in bw and map it upwards till the cube.

    <But when i see in BI the profit center is not being loaded from ECC but from flat file source system. >

    -By this, if you mean that the profit center master data is being loaded from flat file and not ECC, it is ok that will not affect the data that will come from VRBP table.

    Regards,

    Rathy

    Add a comment
    10|10000 characters needed characters exceeded

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.