Skip to Content

After the success of master attr/text load, we can continue with hierarchy load. Below is the transfer file.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=master_conversionfiles\account_hier_conv.XLS

Below is conv file:

My conversion file was saved in custom folder, so that’s y i  mentioned : my folder name\file name.

if your conv file is default folder you can mention like below

HIER_NAME=account_hier_con.xls

start validating the transformation file.

1. Data type

2. info object of bw, set selection, pass BW hierarchy name as show be low pic

3. BPC dim name

save and validate it.After the success of transformation, run the Package  for hierarchy from bw object.

run, provide bw object name and bpc dim .finally see the status of your DM package.

Thank you all…

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. HP pampana

    Raman… Thanks for the doc…. Do you have any step by step document to create models, Applications…. where we create transformation file.can you please share the links. 

    (0) 
    1. Raman Korrapati Post author

      Thanks for your comments.

      No hari. Creating model or applications very simple. you can just loginto BPC Admin portal and play it there. easily you may do. if i find i will share.

      Thanks

      (0) 
  2. Gaurav Tipnis
    Hi Rk,
    Document is really very useful.
    However, I got the following error
    I got success in transformation file but while running Run package I got the below error

    Task name HIERARCHY DATA SOURCE:
    Info: Hierarchy node includes text node or external characteristics
    Record count:                                               737
    Task name CONVERT:
    No 1 Round:
    Reject count: 0
    Record count: 737
    Skip count: 0
    Accept count: 737
    Task name HIERARCHY DATA TARGET:
    Time version of dimension ACCOUNT does not exist
    model: Consolidation. Package status: ERROR
    Regards,
    Gaurav

    (0) 
      1. Gaurav Tipnis

        Thanks RK,

        I checked the OSS Note and did the post implementation activity

        But now I am getting the below error 😕

        Task name CONVERT:

        No 1 Round:

        Reject count: 0

        Record count: 737

        Skip count: 0

        Accept count: 737

        Task name HIERARCHY DATA TARGET:

        Error in Admin module or a component used by Admin module

        Detected duplicate member ID ‘ATG 0000100000’

        Detected duplicate member ID ‘ATG 0000100005’

        Detected duplicate member ID ‘ATG 0000100020’

        Detected duplicate member ID ‘ATG 0000100006’

        Detected duplicate member ID ‘ATG 0000100030’

        Detected duplicate member ID ‘ATG 0000100081’

        Regards,

        Gaurav

        (0) 
        1. Raman Korrapati Post author

          that means your hierarchy structure may have duplciate ids, pls recheck your bw hierarchy structure nodes.

          ATG 0000100000

          ATG 0000100005

          ATG 0000100020

          All mentioned member ids may be already loaded to bpc side or at bw side its may added more than once at bw hier str. pls recheck them. Tx – RSH1.

          please post your issue as thread, it will be useful for other also.

          Hope you can understand.

          Thanks

          (0) 
  3. Lucas Mena

    Hi Raman!.

    Thanks for your usefull document! it is very clear!

    However, I have a question.

    If I need to add a new hierarchy to the account, I only have to add a record in the conversion file like:

    EXTERNAL                                      INTERNAL

    ZEVA_CE_GL_ALL                           PARENTH1

    ZNAME_HIERARCHY                      PARENTH2

    Thanks in advance.

    LUCAS

    (0) 
  4. PABLO FERRIN

    Hi Raman,

    I have a question.

    I need to load hierarchy standard BAUS of 0GL_ACCOUNT infoobject in ACCOUNT dimension.

    When load with run package the package status is Failed.

    the log detail is:

    Log_001.jpg

    Those BAUS* are level of hierarchies.

    I have this problem with all hierarchies what want to load

    Please, tell me. How can I resolve this problem??

    Thanks.

    (0) 
  5. John Betterman

    HI CH Raman,

    Thanks so much for your document. However , I followed your steps, but my members are not linked to the hierarchy. How do I link them. Also , I read that all BW hierarchy text node must be loaded as members in the BPC. I could not see in your both document where you did that. While loading master data (att and text) you just selected hierarchy name, you did not add levels. How did you load text nodes as members?

    Thanks

    (0) 

Leave a Reply