Skip to Content
avatar image
Former Member

Populate constant value to PARENTH1 - BPC Dimension - Endroutine

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 20, 2017 at 05:54 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.