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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |