Aggregates in Planning Area

[Former Member]

Hi,

In Planning Area of SNP...we find Aggregate like 9ALA, 9ALORE etc...

1) Can anyone elaborate whats the function of these Aggregates?

2) Also whenever we add some new keyfigure in Planning Area , are we supposed to assign it to these all aggregates or selective aggregates? and How to assign it?

Thanks

rgds

Nil

[Former Member · Accepted solution]

Hi Nil,

Purpose of Aggregates:

Data can be saved in aggregates as well as on the lowest level of detail. An aggregate contains a subset of the characteristics in the master planning object structure.

the purpose of aggregates in APO is : to speed up data access and therefore increase performance.

Below aggregate are provided by sap with standard SNP functionality as soon as you make your MPOS SNP possible it add below aggregate in your PA.

9ALA

9ALORE

9AMALA

9AMALARE

9AMALO

9AMALORE

9AMAPR

9AMARE

9ARE

9AREPR

you can also create your own aggregate in a master planning object structure of APO by clicking with the right mouse button on the master planning object structure in S&DP Administration and choosing Create aggregate.

And other inforamtion as Sujay and Prabhu mentioned above.

Manish

[Former Member]

Hi Nil,

Aggregates is nothing but storing the data at that particular aggregate level,say for example 9ALORE is aggregate at your location and resource level.

If some of keyfigures assigned to this aggregate then you can store the data at this combination.(example 1) your capacity value of resource at plant level).

If you add new keyfigure in planning area that keyfiure by default assigned to 9ABAS level ,then you need to assign this keyfigure to your particular aggregate level by using table /sapapo/tspaplob.

Hope this will help.

Regards,

Prabhu

[Former Member]

Hi Nil,

Aggregates are nothing but a combination of Characteristics & Key figure.

As if we can take example of 9ALORE,then it includes Resource Location Char. & key figure related to Reources are there e.g. Cpacity Consumption ect.

Even if we want to create Data Flow process for taking backup of planning Area,then while creting Data Source system will ask for these Aggregates,now it`s up to you that which Char. & Key fig. you want to see in Info cube.

IF you add any time series Key fig. in SNP planning Area then it will automatically assigned to all the Aggregates.If you want to add other key fig. in diff. aggregates,which already exist in Planning Area,then first you have deinitialise Planning Area,then go to Key fig. Assignment Tab,then drag key figure from right side & drop in to particular aggregates.But before you doing this,you should think about Char. & key fig. combination. E.g. You can not put capacity consumption in 9AMALO Aggregates,becz this aggregates is related to Prod. & location Char.

Regards

Sujay