cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10.0 on Oracle - Master Data Update Automation - Hardcoding PARENTH1 Field at BPC Side?

Former Member
0 Kudos

Dear All,

I am performing master data update in BPC 10.0. The source is a standard BW InfoObject and the target is BPC Dimension(DIM).

My requirement is that, BPC DIM should be updated with BW InfoObject's data. Only, attributes/texts are to be updated and there is NO hierarchy to be updated from BW InfoObject. But, BPC DIM has it's own hierarchy, maintained at BPC'e end.

When updating BPC DIM data, I need to update BPC DIM's PARENTH1 field with a hard-coded value(Say, TOP_LEVEL). This is a TEXT node and parent node of the DIM's ID. How can I do that? Is this possible? Or, since hierarchy is not being downloaded from InfoObject, is this has to be maintained at BPC end? Since BPC hierarchy is a simple one(just one parent under which, all the children are there), I need to hardcode the TOP_LEVEL ID for PARENTH1 field. How can I achieve that?

Would appreciate your help on this.

Thank you,
Peri

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Peri,

few options for the automated way.

1. create a dummy hierarchy in BW, so that you can select something from the package. then use start/end routine in your transformation file for hierarchy load to populate all the parenth1.

2. create a datasource of itself (infoobject) then populate top_level using BW exit, then load that hierarchy into BPC.

either way you need an ABAPer.

or you can do the manual way as suggested above.

Andy

Former Member
0 Kudos

Thanks, Andy.

Regards,

Peri


Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Peri,

It is a two-step process, export the dimension to flat file and then import the flat file with TOP_LEVEL as hierarchy.


Step 1 :Export

Create a transformation file with all default options and two lines

ID=ID

PARENTH1=PARENTH1


Do not include any other columns as this will insure ParentH1 as Column # 2 in the export file. The file will have all the properties and description also.


Step 2: Import

Create the file as shown below

*MAPPING

ID=*COL(1)

PARENTH1=*IF(*COL(2)=*STR() then *STR(TOP_LEVEL); *COL(2))

Shrikant

Former Member
0 Kudos

Thanks, Shrikant.

Regards

Peri