Skip to Content

Data comparison between BPC and BW in BEx Query

Hi,

Will it possible to create a query on a Multi Provider which have BPC Model (/CPMB/) and BW. If yes, how to assign the Account and Time as the Technical Names are different (in my case, members also changed while loading to BPC by using Transformation / Conversion files). And will it be possible to create a report like 'BPC Variance report'. If yes, pls share your inputs and Documents if any.

Thanks

Sekhar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 14, 2017 at 12:57 PM

    "as the Technical Names are different" ??? what do you mean? You can restrict changes of technical names.

    "members also changed"?? changed? may be added?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 17, 2017 at 08:09 AM

    Hi Vadim,

    Thank you for replying.

    1. For eg., we are loading Master data from 0Account and technical name of it in BPC will start with /CPMB/. It is not possible to assign 0Account to our BPC Account ie., /CPMB/XXXXXX in a MultiProvider.

    2. While loading to BPC, the members are also changed. For Eg., BW Account members are like '0000123456' but in BPC it is 123456. And Time in BW 0012018 but in BPC it is 1718.JAN.

    So, we are getting the variance report as expected. I felt that creating BEx Report is easier than a EPM Report.

    Request you to suggest the better way which will be helpful to complete this requirement.

    Thanks

    Sekhar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2017 at 04:55 AM

    Sekhar,

    One solution would be to maintain navigational attributes on each native infoobject in BW to match those of BPC's

    e.g. 0GL_ACCOUNT to maintain ACCOUNT (technical name /CPMB/*) attibute.

    As for time dimension, you will need to add TIME (technical name /CPMB/*) in the infocube and put some transformation logic.

    You can then compare the data in BPC master data format.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sekhar SR

      Sekhar,

      When add them, it is only showing Key Figure for # which is the total for all Profit Centres but each Profit Centres

      Can you list all your BPC dimension? You have to transform all infoobject from BW to match with those of a BPC

      And moreover our BW guys are not accepting this way (Adding our BPC Objects) as Navigational Attribute

      If they don't want to add it as Navigational Attribute, then add it as a separate infoobject to the cube. Although I'm interested in knowing why they don't accept this

      And we facing inconsistency when add BPC time to 0FISCPER

      You have to make a separate infoobject TIME in your BW infocube. The same kind that is comparable to BPC. Otherwise it can never match 0FISCPER with TIME

      The goal here is simple: you must have a comparable dimensions in both BPC and BW. Either BW has to add the dimension from BPC, or you have to transform data from BPC cube to BW native infoobject. I suggest the first because it would save you data loading

  • Dec 20, 2017 at 09:50 AM

    Hi Hendry,

    Thanks for your time.

    When add them, it is only showing Key Figure for # which is the total for all Profit Centres but each Profit Centres. And moreover our BW guys are not accepting this way (Adding our BPC Objects) as Navigational Attribute. And we facing inconsistency when add BPC time to 0FISCPER.

    BW guys suggesting that they will create a local query and the users has to compare them manually.bpc-bw-comparison.jpg which is not correct.

    Request you to suggest someother way to achieve this.

    Thanks

    Sekhar

    Add comment
    10|10000 characters needed characters exceeded