Aggregation level doesnt support non-cumulative kf

[Former Member]

hello

IP planer generates an error "Infoobject 0AMOUNT (version A) is not compunded" when I include non-cumulative kf into aggregation level of infoprovider.

KF ZAMOUNT is non-cumulative and depends on 0AMOUNT. Both kf are active.

I need non-cumulative kf just for informative purposes, i dont want to plan with this kf.

Does anyone know is it possible to use non-cumulative kf in aggregation level of multicube?

[Former Member · Accepted solution]

Hi,

I dont think this will be possible, since an aggregation level needs to perform aggregation - disaggregation of the KFs depending on which characteristics have been included.

If you need to just display it, how about creating a separate (non-planning) query for that KF and displaying it alongside the input query in a web template / workbook?

[gregor_dieckmann · Accepted solution]

Hi,

no non-kumulative key figures are not supported in aggregation levels.

But one can use a MultiProvider on the cube with the non-cumulative key figure. Create an aggregation level for the objects you want to plan and use this aggregation level also in the MultiProvider. Then you can integrate the 'plan objects' and the non-cumulative key figure in a query defined on the MultiProvider.

Regards,

Gregor