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