Skip to Content
avatar image
Former Member

How to load master data by reading transaction data in SAP BPC 10.1 NW

Dear Experts,

We have a situation where transaction data will be coming from a third party system. One of the fields in this data (Instrument ID) will be randomly generated at run time just before it will be pulled in the BW staging layer for BPC 10.1.

To load the transaction data in BPC the dimension Instrument ID must have valid members. Since it is randomly generated we cannot define and load the members IDs beforehand. So the transaction has to be looked up in the staging layer and Instrument IDs need to be extracted and loaded in the BPC dimension before loading the transaction data

May I request you to suggest possible ways in which this can be achieved. We are on SAP BPC10.1 NW.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 23, 2017 at 05:49 PM

    Explanation is not clear. Please provide some sample with some values...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 10:33 AM

    Hi Vadim,

    Below is the snapshot of the transaction data that will come in the staging layer.

    All the dimensions dimensions except Instrument ID are standard and the members of those are readily available.

    But Instrument ID is a randomly generated alpha numeric key of 32 characters which the external system will randomly generate before sending the data to BW. Now BPC has no way of per-defining and maintaining the members of this Instrument ID dimension.

    So we are looking at ways to read the above transaction data in the BW layer, extract the Instrument ID and load them into the Instrument ID dimension before loading the transaction data into BPC. Getting this Instrument ID from the external system is not possible.

    Any pointers on the best possible way to do this.

    Add comment
    10|10000 characters needed characters exceeded

    • "The external system will use this randomly generated ID for data processing on their side" - ups, how??? Unable to understand the business scenario...

      Please explain how you load data from external system to BW?

      Using text file or???