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