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
11,439

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...

12 Comments