Skip to Content
avatar image
Former Member

Dimension member property values as hierarachy

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 26, 2017 at 01:32 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 27, 2017 at 08:31 AM

    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.

    Add comment
    10|10000 characters needed 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!

  • Jun 27, 2017 at 09:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2017 at 08:03 AM

    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,

    Add comment
    10|10000 characters needed 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.