Load DSO into BPC Hierarchy direct

[Former Member]

Dear All,

I've got a question

1. I have a DSO or table with two fields (KEY)

- ID_PRODUCT

- ID_PARENTH

2. I have a Product Dimension in BPC

- ID

- HIER (Hierarchy)

I have in the system my Product Members ID_PRODUCT

but, I want to load:

-ID=ID (ID_PRODUCT)

-HIER=ID_PARENTH

It is possible to do that?

THanks.

Regards,

PS. if you understood, the Hierarchy is not in the BW Hierarachy format, else that would be easier.

[Former Member]

Hi can you show some sample data of the DSO? I mean how the hierarchy relation is saved in DSO?

Regards,

JP

[Former Member]

I dont think standard data manger package will be helpfull in your case!....Load the data using flat file....then use the STD data manger package of Import Master!. You can automate this process on BW side in form of process chain...DSO-----Load into flat file------>BPC data manger package( use UJD_TEST_PACKAGE program to run BPC package from BW).

Hope this helps...

Regards,

JP

[Former Member]

Like this!

Thanks

[Former Member]

In line with my above suggestion refer this document......

Regards,

JP

[Former Member]

Hi Thanks.

But, I did not understand.

How can I map the HIER = ID_PARENTH?

[Former Member]

It would be a simple mapping if loading through flat file like

ID=*COL(1)

PARENTH1=*COL(2)

if your flat file has ID in first column and hierarchy in second! Instead of *COL() function you can also give the headers of the columns....

P.S If you first load the data from DSO to a flat file.....and then load from flat file to BPC!

Hope this helps...

JP

[former_member186338]

"How can I map the HIER = ID_PARENTH?" - you can't! Please read the JP explanation of the required steps...