Skip to Content
avatar image
Senthil Esakkiappan

Populate constant value to PARENTH1 - BPC Dimension - Endroutine

Sep 19, 2017 at 08:04 PM | 227 Views | Last edit Sep 20, 2017 at 05:43 AM 2 rev.

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

SAP Business Planning and Consolidation, version for SAP NetWeaver
sap bpc 10.1nw | sap bpc | sap bpc 10 nw
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Vadim Kalinin
    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

    • Vadim Kalinin
      Sep 20, 2017 at 06:04 AM

      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.