Skip to Content
0
Nov 22, 2011 at 11:05 PM

Transaction data load

30 Views

Hello Guys,

Need some suggestion in loading following data in BPC MS 7.5 . This data is exported from BO finance (cartesis) is the in the format of Product, Account, Currency, Entity, Category and data values are for 12 months of an year.

Normally In order to load data in BPC from a flat file, it should contain member of default dimension ie Account, category, Entity and Time but in this case there is no time dimension members. But it has data for 12 months.

eg:

CE0010746,A00100,US,STORE1,Actual,100002,183.850000000,345.5400000,685.30000000,

123.82000,423.44000,247.134400,435.347000,430.000000,335.3490000,590.950000,120.000000

Ie Product, Account, Currency, Entity, Category, data of Jan, data of Feb, data of Mar...... till data of Dec

Could you please suggest if it is possible to load this kind of data with Transaction and conversion files.

Thank you

Jack