cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregation and MPOS

Former Member
0 Kudos

Hi All,

I've read the SAP help text but still don't have a lot of understanding of this topic.

Do you need to have an aggregate created at the MPOS to use the proportional factors with aggregation and dis-aggregation in demand planning?

Can someone explain the difference of the MPOS aggregate to the aggregation in DP.

Thanks

Paul

Accepted Solutions (1)

Accepted Solutions (1)

former_member209769
Active Contributor
0 Kudos

Hi Paul,

Are you looking for any more information than what DB49 and Rajesh already shared?

Aggregation: Is a process. Data is stored at the most detailed level in planning area (and additionally at aggregate level, if you maintain aggregates). Let's say you want to read data at higher level. System would do an aggregation of data from the detailed level (depending on your aggregation settings), and would show you the high level data that you want to see. Similarly if you maintain/update data at a higher level, system would do an disaggregation since it has to store data at the detailed level. Aggregation/disaggregation automatically comes into picture during loading/creating/changing of data as required (in the background).

Aggregate: Data would always be stored at the most detailed level in planning area. We could also store data separately at aggregate level or higher level by specifying aggregate in MPOS, if we need to access to aggregate level data very frequently. Result is that when we would access data at aggregate level, access would be fast since system doesn't need to do any aggregation of data from the detailed level. On the other hand, we need more memory since we are "additionally" storing data at aggregate level.

Maintaining aggregate in MPOS isn't linked in any way to the use of proportional factors.

Thanks - Pawan

Answers (2)

Answers (2)

rajkj
Active Contributor
0 Kudos

Hi Paul,

POS aggregates are nothing but InfoCube aggregates. They help to improve the performance (especialy in reporting) by storing frequently accessed information at aggregate level.

Whereas the aggregation and disaggregation in DP is a different concept that control the roll up/down of key figure values based on the 'calculation type' and 'time-based disaggregation type' settings that you maintain for each key figure in planning area maintenance (t.code /SAPAPO/MSDP_ADMIN). Please refer the following link for examples of different settings.

http://help.sap.com/saphelp_SCM700_ehp02/helpdata/en/47/d12b801fb26c68e10000000a42189b/frameset.htm

The default settings for proportional factors (Key Figure - APODPDANT) use equal proportions for disaggregation both structural and time-based (if detailed proportional factors are not generated).

Calculation Type - S

TB Disaggregation Type - P

Thanks,

Rajesh

Former Member
0 Kudos

Paul,

In the Planning Area, you can define how the key figures will disaggregate/aggregate.  This is independent of Aggregates, which are part of the MPOS.

When you are actually editing a planning book, most of the time the cell you are entering data into is actuall a total or a subtotal,  of many bits of detailed information.  So, when you enter data into a  PB cell, and the cell is in fact a subtotal, the planning book assumes that you know what you are doing, and therefore distributes the subtotal data down to the lowest level of detail in your planning area, transparently.  Upon saving, the data is stored at the detail level.  Normally it is NOT stored at the level where you entered the data.

In the MPOS, you can also define an aggregate, and assign key figures to it.  In this case, the data is stored in more than one place: At the detailed level (default) and also at the aggregate level which exists in the MPOS.  Among other things, use of aggregates can sometimes enhance performance when opening a book (the book does not have to calculate all the aggregate totals from the detail before displaying the aggregate totals, since the aggregate totals were saved last time you closed the book).

'Aggregation' and 'Aggregates' are two different topics, and are not directly related.  You do not have to define aggregates to use proportional aggregation.

Best Regards,

DB49