Skip to Content
Author's profile photo Raman Korrapati

BPC 10 NW Master data attributes/text and hierarchy loading process Part1

BPC 10 NW how to load master attributes/text and hierarchy load.

MY BPC have Dimension name = ACCOUNT,

BW Info object = 0GL_ACCOUNT, my gl account have compounding info object 0CHRT_ACCTS.

MY BPC dimension ACCOUNT have properties – ACCTYPE, PARENTH1 and other mandatory fields, we maintained hierarchy for gl account in bw side and bpc also.master data attributes/text and hierarchy load from BW info object

First we need to master attribute/text load. below is the transformation file.

For account type we are passing constant value as EXP if we get blank from BW.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=0

ROUNDAMOUNT=

*MAPPING

ID=0CHRT_ACCTS+ID

ACCTYPE=*IF(ZACC_TYPE = *STR() THEN *STR(EXP); ZACC_TYPE)

*CONVERSION

go to Excel, Data maanger, choose transformation file–> Validate and process T/fer file

As below

while validating transformation file, need to give below options.

Data type as Master attributes/text from NW info obj from bw., select the bw info obj and bpc dimension name.

go to SET selection tab, you can enter chart of accounts(am giving as ABCD) in attribute, provide bw gl account hierarchy name and choose set filter by attribute or not. Below screen is entering attribute value for chart of account.

below am provided hierarchy name(BW hier name)

Normally default one selected is set filters by attr and hier. but when we have hierarchy to our dim, then we need to choose OR option which shown below.

after setting above options, save , after the success of validation,

Run DM package for master data attributes.

Click on run package on import master data attr/text infobj

with selection of info object and dim.after the successful of attr/text load need to run hierarchy load.

See the part1

Thank you all

Assigned tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo HP pampana
      HP pampana

      Nice doc....Thanks for sharing......

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank You Hari.

      Author's profile photo Srinu S
      Srinu S

      Helpful document. thanks for sharing. 🙂

      Author's profile photo Former Member
      Former Member

      Hi Raman

      Every step is clearly explained...  🙂 Thank you so.. much for putting wonderful effort and sharing..it for us.

      Thanks

      Venkat

      Author's profile photo Former Member
      Former Member

      Thanks for short & sweet doc 🙂

      Author's profile photo Former Member
      Former Member

      Nice doc....Thanks for sharing....


      Thanks

      Naresh

      Author's profile photo amine lamkaissi
      amine lamkaissi

      Nice doc Raman, I'm waiting dor the others parts 🙂

      Amine

      Author's profile photo Mohd Fasiur Rahman
      Mohd Fasiur Rahman

      Thanks!

      Author's profile photo Mohd Fasiur Rahman
      Mohd Fasiur Rahman

      Thanks!

      Author's profile photo Former Member
      Former Member

      In you transformation file, you load the ACCTYPE as "EXP", while in reality, there are 4 type of account type for the balance sheet hierarchy, is this mean that you have to manully modofied those account in BPC for each node?

      Author's profile photo George Serfiotis
      George Serfiotis

      I, also, have the same question: how to populate the acctype property for ACCOUNT-related dimensions? If a flat value like "EXP" is used in the transformation file, it will overwrite manually adjusted entries (i.e., AST, LEQ, INC) during the next master data load.

      Author's profile photo Former Member
      Former Member

      I dont have such package-

      Run DM package for master data attributes.

      Click on run package on import master data attr/text infobj

      How to add it in the model? (in each standard model there is different list of packages)

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      first time we need to add packages  , please go thru below link.

      Data Manager - SAP Documentation

      Author's profile photo Former Member
      Former Member

      Thanks, I see the list of packagesmust be organized by default it is empty, do U have same tutorial but fro import data from flat file?

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      As of now i don't have. if you need any clarity on it, you can post your issue at this BPC forum. You will get answers.

      Author's profile photo Former Member
      Former Member

      Hi All,

      My Current EPM Addin is SP19 and The NW is CPMBPC 800 SP14.We tried loading the master data with Hierarchies.I have 2 issues:

      1. While loading the master data (IMPORT_IOBJ_MASTER) , If I want to Load the Hierarchy Ids along with , its working only if I Provide the Filter in Set Selection.Else It fails With

      Error:Error in Admin Module or Component Used by Admin module.

      Dimension member ? in an invalid member ID.

      2. If I provide the Filter , step 1 is succeed ,, but While loading the Hierarchy , I am facing the below Error:

      Time version of Dimension "BW_PLANT" does not exist.

      My BW hierarchy is Time Independent , Can Anybody please explain why The Above error is coming and How can we resolve it.

      Rashmi.

      Author's profile photo Former Member
      Former Member

      Can anyone tell me the significance of the Key Date when setting selections?

      Author's profile photo Ravindra Kumar
      Ravindra Kumar

      well explained.

      Author's profile photo Former Member
      Former Member

      Nice Document RK. Thanks for Sharing.

      Author's profile photo Former Member
      Former Member

      Hi CH Raman,

      Thanks for the nice doc. I think the process above loads just members (attributes) not hierarchy. I heard that each node of the hierarchy must be loaded as members. How do you do that? do you choose levels in the hierarchy ?