Populate constant value to PARENTH1 - BPC Dimension - Endroutine

[former_member485169]

Hi All,

Can you guys suggest how to achieve the below

I need to pass a constant value like "CONSTANT" to PARENTH1.

For example

Dimension = ACCOUNT

PARENTH1 = 'CONSTANT_VALUE'

When I try to do it in the transformation file it is not allowing me to populate the PARENTH1.

I have a BPC Endroutine( Call it in the transformation file) which passes this value to the ParentH1.

So when I trigger the data manager to load this dimension using package hierarchies load from BW info object - this end routine is not called. I think it will get triggered only when the BW info object has a hierarchy.

Do you guys suggest how to achieve this like just pass constant value to PARENTH1 for a dimension in BPC where there is no corresponding hierarchy exists in BW.

Is there anyway I can assign a constant value to PARENTH1 for a dimension in the transformation file or through Start/End routine BADI.

Thanks

[former_member186338]

I have already answered this question number of times!

After member import from BW without hierarchy:

1. Export members to the fixed name text file.

2. Import the same file with transformation:

*MAPPING

ID=ID

PARENTH1=*IF(ID=*STR(CONSTANT_PARENT) THEN *STR(); *STR(CONSTANT_PARENT))

All 3 DM packages can be arranged in a single package link.

[former_member186338]

P.S. end routine badi can be used for import of some dummy hierarchy in BW and in ABAP you can generate a table with values. But I don't see any benefits of using badi for this scenario.