Skip to Content

Loading Data from BW Info Object to BPC Dimension BPC 10.0

Hi Team,

We have a typical scenario

BW 7.0 where all the FI data is residing

BW 7.3 which is a fresh installation & has BPC 10.0

Going Fast forward

I created a Dimension call ZPLANT (Type U : User defined) in BPC Web Front end

I generated Export Datasource for 0Plant in BW 7.0

Replicated the export DS in BW 7.3 , so got 80ZPLANTM & 80ZPLANTM

In Tcode RSA1 in BW 7.3

I see the ZPLANT - /CPMB/X3D8KZO

Dimension in the test Environment Shell That I created

I created transformation from 80ZPLANTM to Attribute

Created Infopackage , executed , got 221 records

Created DTP for Attribute and Executed.

Got 221 records loaded

I see the records by going to Maintain Master data in BW 7.3 for the ZPLANT Dimension.

When I go in the BPC front end I am not able to see the data

Any reason where am I missing some thing

Also Can I proceed with this way of loading data from BW server to another BW server for BPC purposes

Lalan

BW BPC.jpg (62.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2012 at 05:16 AM

    Hi Lalan,

    Loading BPC master data using BW transformations is not a standard way. Please use the BPC DM package for loading master data.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2012 at 12:48 AM

    Hi,

    Try to activate the data which you loaded into ZPLANT .

    Hope it works...

    regards,

    Raju

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2012 at 02:01 AM

    Hi Lalan,

    Can you try to run thru run package from Data manager. maintaining transformations and run package.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2012 at 08:54 AM

    Hi,

    Please check this link, it might be helpful for you.

    http://scn.sap.com/message/9642623

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi All,

      Thanks for the quick reply.

      So it seems, I would not be able to load though the BW standard way.

      But during the recent Tech Ed, SAP demonstrated by loading data to Planning Cube from a Standard Cube data by the BW way. i.e. Transformation & DTP through RSA1

      Hence I was trying that approach.

      I will try investigating, and If I get that to work , I will update this message.

      Lalan

  • Posted on Dec 14, 2012 at 07:45 PM

    Hi All,

    So I have not still given up

    Found this link

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00380440-010b-2c10-70a1-e0b431255827?overridelayout=true

    I am woking on the scenario 2, Pg 33 onwards in the Document

    So I was doing it all right , till the system calls the program "ZUJA_UPDATE_BPC_DIM"

    Now we do not have any clue what the ABAP program is and what it does as we are on BPC 10.0 and the transport provided in the PDF is for BPC 7.0. We tried installing the transport and it failed

    Has anybody gone through this before

    Need to understand what the "ZUJA_UPDATE_BPC_DIM" program does, what tables it updates, etc.

    Lalan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Nilanjan,

      The Hierarchy package provided in 7.5 or 10 is overwriting the entire Hierarchy each time it is loaded instead of update. If the users are maintaining statistical accounts in BPC and adding those accounts to the Hierarchy loaded through the package, the next time I use the package it is overwriting the Hierarchy. Can I create a export datasource on the BPC infoobject and load the user modified hierarchy from BPC to BW infoobject and load it back into BPC or is their a better approach?

      Thanks

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.