After the success of master attr/text load, we can continue with hierarchy load. Below is the transfer file.
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
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
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…