Plan Data for actualized(historical)Months

[Former Member]

Hi,

We get Actual data to BPC from source system.Once loading this data to ACTUAL category,copying the same data to PLAN category as well.

(Eg: January 2016 to April 2016 data of ACTUAL category data is copied to PLAN category as well.i.e,historical months or actualized months data).

As this is data is very huge and consumes lot of space.The issue becomes more prominent as we pass to end of the year.

Is there any way to get the ACTUAL data in PLAN data report retrievals without copying the ACTUAL data to PLAN category?

When users refresh/create a report for 2016 year for PLAN category,Jan-April data should come from ACTUAL category and May-Dec data should come from PLAN category.

NB:Users create their own reports,so we can't do with excel native functionalities.

Best Regards,

Manohar

[former_member186338]

"Is there any way to get the ACTUAL data in PLAN data report" - you are doing the correct thing copying data from actual to plan. Alternative is to create report with category in column axis but in this case the total will not be calculated!

The data is huge? May be you have incorrect server sizing or...

Vadim

[Former Member]

Hi Vadim,

If I understand correctly,report should have ACTUAL and PLAN categories in column axis.

But user will create report by selecting only one category(i.e.,PLAN).Data should come from ACTUAL category for historical months.

Best Regards,

Manohar

[former_member186338]

Then - copy data, no other way for standard BPC model.

[Former Member]

Hi Vadim,

Thank you very much.

Best Regards,

Manohar

[former_member186338]

Then close the discussion!