aggregation level on single level basis or multiprovider

[Former Member]

Hello,

we use IP 7.0 and have a planning cube for CO-PA data, as well as a multiprovider combining the actual cube and the planning cube for COPA data. We need to implement a planning tool in which planning simple planning functions are needed on the single basis (copy, revaluation, multiply,manual planning ...) as well as on the multi-provider (top-down with reference data).

-> on which level(s) should we define the aggregation level? Do we need to define it on the multiprovider (in order to do the top-down) or can we split it up (single level and multi-provider) and define a workbook with a manual planning function on the single level AND including the top-down based on the multiprovider?

thanks

Dries

[gregor_dieckmann · Accepted solution]

Hello Dries,

in your case (plan and actual cubes contained in a multiprovider) it seems to most natural that you created you aggregation level on the multiprovider. This also allows you e.g. to copy data from the actuals cube to the plan cube.

Regards,

Gregor

[Former Member · Accepted solution]

Hi,

I've read in some general documentation that when defining a FOX formula, try to do it on the single level basis if possible. So that is why is asked this question, if I need to create the same aggregation level on the single level AND on the multi-provider or not ...

Dries

[Former Member]

I agree with Gregor,

I think it is more logical to configure your Aggregation Level on top of your Multi-Provider, especially since you already have a need to view ref data from Actuals to perform calculations on your Planned. You can always restrict your 'simple' functions to the appropriate InfoProvider.

As for the FOx question, you can always restrict to each InfoProvider when writing your FOx (either inside the FOx code or using the FOx conditions).

Regards,

Zane