Hi guys,
i'm pretty new of PBCS and i'm wondering which could be the better way to upload data in a plantype of my PBCS instance that has the peroid dimension with 366 members (days). The application has this structure (level zero stored members):
Account 20
Period 366 (P1 to P366)
Entity 250-300
CustomDim 6
Scenario (actual is the only scenario that will be loaded)
Version (Working is the only Version that will be loaded)
Currency (only one currency will be loaded)
Year (only one year will be loaded)
This plantype will amange the sales planning process. Now, i'm wondering which upload tool i should use especially from a èperformance point of view. I think that the bettre way sholud be using FDMEE with multiperiod approach and try to build the file to upload always with the same structure on columns (for example with 31 days even if February for example has only 28 days). In this way i could do a monthly load.
I think that using the essbase load data file couldn't be the right solution because i have to build the file with one column only and put periods on the rows.
Do you have any advice?
Thank you so much for any help you could give me
Bye
Maurizio