Skip to Content
0
Jan 27, 2010 at 10:24 AM

Sign problem on the INC account type while loading actual data

42 Views

Hi All,

BPC sign logic is failing in my case when I am loading data for actuals using flat file. All my data for Sales Value and quantity get loaded into the cube as 'positive' values though they are defined as 'INC' account type. As per the sign logic BPC cubes should have them with minus sign in the cube. Please help in resolving this.

However when I send the budget data from input schedule, the data is correctly saved i.e. sales values are saved with minus sign.

Do I have to take care of anything in my transformation file while loading actuals? I beleive BPC handles this sign logic by itself looking at the 'ACC TYPE'. Please share your inputs.

Thanks,

Santosh