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

[RamanKorrapati]

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