Dimension member property values as hierarachy

[BalakrishnaGoud]

Hi Experts,

Is there any possibilities to obtain hierarchy from dimension member property and update as H2 hierarchy in the same dimension?, if yes then how.

Version: BPC 10.1 NW SP10.

Thanks in advance

[BalakrishnaGoud]

Hi Vadim,

Thank you, it works fine.

We are concatenating two properties then update as H2 hierarchy which is working fine but we want to insert "_" between two properties then update as H2.

Example

Property 1: ABC

Property 2: XYZ

Now H2 = ABC_XYZ

Mapping in transformation file > PARENTTH2=Property 1+*Str(_)+Property 2

But we are getting below error

Member ABC_XYZ of dimension TEST has an invalid hierarchy parent '_'

I have maintained a member a ABC_XYZ to recognize H2 as a member

Regards,

[former_member186338]

It means thar some member has both properties empty. You can check for empty in transforation file and replace empty with some value. Then in conversion file you can skip this records.

[former_member186338]

Sample - you have property H2PARENT containing parent members for PARENTH2 hierarchy.

You export to text file ID and H2PARENT

Then you import the same file with transformation:

PARENTH2=H2PARENT

[BalakrishnaGoud]

Hi Vadim,

Thanks for the reply, we want to automate (daily) the process.

I have found below link on Start routine and End routine, I will check with our technical team and update.

https://archive.sap.com/kmuuid2/50c39fa1-6f95-2d10-2a95-b594de8e1bb7/How%20To...%20Use%20Start%20and...

Meanwhile, please let me know, if you have any other option.

Thank you.

[former_member186338]

Export to text file and import from the same text file can be done automatically inside package link. And it can be scheduled daily. No reason to use start/end routine.

Please provide the property sample and the desired result!

[former_member186338]

Export to text file and import this file with correct transformation file.