Skip to Content
0

Dimension member property values as hierarachy

Jun 22, 2017 at 12:08 PM

55

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Jun 26, 2017 at 01:32 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 27, 2017 at 08:31 AM
0

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%20End%20Routine

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

Thank you.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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!

0
Vadim Kalinin Jun 27, 2017 at 09:18 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 29, 2017 at 08:03 AM
0

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,

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0