Question Re: Creating an Aggregation Layer in Technology Q&A

Creating an Aggregation Layer

Former Member — Thu, 27 Nov 2008 14:58:00 GMT

I am trying to create an aggregation layer which is to built off a multi provider which has a real time info cube. When I try and create the aggregation layer I get the message:

Aggregation Level <level name>: Infoprovider <Info provider name> cannot be used for definition

Why am I getting this message and how can I resolve it? Thanks

Re: Creating an Aggregation Layer

Former Member — Thu, 27 Nov 2008 16:04:22 GMT

Hi,

Are you creating this aggregation level in Planning Modeler?

Regards,

Deepti

Re: Creating an Aggregation Layer

Former Member — Thu, 27 Nov 2008 16:18:47 GMT

Hi Deepti,

Yes I am

Re: Creating an Aggregation Layer

Former Member — Thu, 27 Nov 2008 18:50:17 GMT

this problem has been discussed before... did you try searching this forum?

See for example:

Re: Creating an Aggregation Layer

Former Member — Thu, 27 Nov 2008 20:42:27 GMT

Hi Mayank,

Thanks for this. Had a look at the link but could not find an answer on the thread

Re: Creating an Aggregation Layer

Former Member — Fri, 28 Nov 2008 05:29:30 GMT

That was just one of the threads. Try searching for more.

Some of the reasons why an AL will not get created -

1) The underlying multiprov includes an aggregation level

2) Trying to include non-cumulative KF in the AL

... etc

Re: Creating an Aggregation Layer

Former Member — Mon, 01 Dec 2008 06:28:33 GMT

At least one key figure and one characteristic have to be included in the aggregation level.

● The key figures used have to have the database aggregations SUM, MIN or MAX. With MIN or MAX, key figure values can only be displayed. They cannot be changed using manual planning or planning functions.

● For key figures of type date or time, only the data type u2018DECu2019 is supported.

● Referencing key figures (and thus also non-cumulative key figures or elimination of internal business volume) are not supported in aggregation layers.

● If a characteristic is compounded and used in an aggregation level, the aggregation level must also contain all compounding "parent" characteristics.

● If a key figure is used in an aggregation level and does not have a fixed unit of measure or currency, the aggregation level must contain the associated characteristic for the unit.

● If a key figure with exception aggregation is used in an aggregation level, the aggregation level must also contain the characteristic for exception aggregation if it occurs in the underlying InfoProvider

● The aggregation level inherits a navigation attribute from the underlying InfoProvider if it includes the basic characteristic of the navigation attribute. Note that the navigation attribute for an aggregation level is not visible in the Planning Modeler. It is only visible in the Query Designer.

● An aggregation level cannot be created on MultiProviders if a characteristic of an InfoProvider contained in the MultiProvider supplies two different characteristics in the MultiProvider.

● If a characteristic on the InfoProvider that serves as the basis for an aggregation level is constant, this characteristic has to be included in the aggregation level.

Hope this helps.