Skip to Content
0
Aug 02, 2016 at 09:55 AM

How to design the flow

19 Views

Hi,

I have a flat file data source which has 2 KPI's loading till now. Now the Business wants to load next 3 months data from those 2 kpi's which means the flat file will have 3*2 times since they want to see the data in separate columns at the report.

For example,

Currently at DS :

Prod FP kpi1 kpi2

P11 01/2016 50 100

P2 02/2016 30 200

Proposed changes at DS :

Prod FP KPI1 KPI2 KPI11 KPI 22 KPI113 KPI23

P1 01/2016 50 100

P2 02/2016 30 40

P3 03/2106 50 200

How to cope up with this scenario when data is loaded into the cube based upon the fiscal period.

Regards,

Mukesh