Financial Management Blogs by Members
Dive into a treasure trove of SAP financial management wisdom shared by a vibrant community of bloggers. Submit a blog post of your own to share knowledge.
cancel
Showing results for 
Search instead for 
Did you mean: 
RamanKorrapati
Active Contributor

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

20 Comments
Top kudoed authors