Analytics Software

Hi,

I am new in FDM and have couple of question on data loading.. We are using FDM to load the data in Essbase. Please help me on these-

Question 1:

In source data file, suppose, we have around 300 account members and around 100 PO numbers. There are multiple 'PO numbers' records for each 'account member'.

As per our requirement, we need to sum up the all values for 'PO number' column for each account.


For example, suppose, we will get data file as below. Here, Important point is, I don't have dimension for 'PO number ' in Essbase. I will get the accounts data corresponding to 'PO number' but there is no dimension in Essbase to store data at 'PO number' level.


Account column PO number Actual Estimated

A001 P0123_10 10.00 15.00

A001 P0123_20 20.00 25.00

A002 P0123_30 30.00 35.00

A002 P0123_40 40.00 45.00

A002 P0123_50 50.00 55.00

A003 P0123_60 60.00 65.00

A003 P0123_70 70.00 75.00

A003 P0123_80 80.00 85.00


and so on

Now we want to sum up the data for each Account member i.e

Account column Actual Estimated

A001 30.00 40.00

A002 120.00 135.00

and so on ---


As per my understanding, While defining the *'Import format'* for this source data file , we will not consider the column for 'PO number' and will define the mapping with merge option. Hence, multiple record for each account will be accumulated.

Please suggest me on this.. Is my understanding correct or how will handle this type of scenario?

Question2:

Suppose, we have data for multiple scenarios ( i.e. Actual, Estimated etc) in one excel sheet, which will be used in FDM as a source file? As per admin guide, we have POV for Category and data will be loaded for that selected POV only. In this case, will FDM consider the data for each selected POV scenario or how FDM will function in this case... do we need to have separate files for each scenario...

Please help me to solve these problems...

Thanks & Regards,
Mohit Jain