Show TOC

Creating Aggregation LevelsLocate this document in the navigation structure

To plan data manually or to change it using planning functions, you need a planning-specific InfoProvider known as the aggregation level. You use the aggregation level to set the granularity of planning by only adding characteristics and key figures of the underlying InfoProvider for planning.

Prerequisites

You are using an SAP HANA database. You have installed and configured the BW Modeling tools.

You have selected an InfoProvider that is suitable for planning as the basis of the aggregation level.

Context

You can create more than one aggregation level for an InfoProvider, thereby modeling various levels of planning and hierarchical structures for example. Note that aggregation levels cannot be nested.

Procedure

  1. Create the aggregation level. In the Project Explorer view, you can create an aggregation level either for a BW project or for an InfoArea. You can also create an aggregation level as a copy of an existing aggregation level.
    1. To do this, open the context menu for a BW project or an InfoArea and choose Start of the navigation path New Next navigation step Aggregation Level End of the navigation path, or open the context menu for the aggregation level you want to use as a template and choose Start of the navigation path Copy End of the navigation path. The New Aggregation Level dialog box appears. Depending on your point of entry, the system will have already preselected certain objects.
    2. The system preselects the current BW project at the very least. By choosing Browse, you have the option of selecting a different BW project.
    3. If you have created an aggregation level for a BW project, you also have to select the required InfoArea. Enter its technical name or a corresponding search term. The system helps you when searching for the technical name, and returns a list of results under Matching items.
    4. If you have created an aggregation level for an InfoArea, the system preselects this InfoArea. By choosing Browse, you have the option of selecting a different InfoArea.
    5. To add your aggregation level to your local favourites, choose Add to Favorites.
    6. Enter a unique technical name and a description for the aggregation level.
    7. Specify the required InfoProvider, which is suitable for planning. By choosing Browse, you can select from the list of suitable providers.
    8. If you have created an aggregation level as a copy of an existing aggregation level, the system preselects this aggregation level together with the underlying InfoProvider. By choosing Browse, you have the option of selecting a different aggregation level as the template.
    9. Choose Finish.
    The system opens the new aggregation level in the Eclipse Editor. The General tab opens, together with all aggregation level settings that you have made so far.

  1. Go to the Output tab. The system displays the definition of the aggregation level.

    If you are creating a new aggregation level, Provider Fields is empty.

    If you have created an aggregation level as a copy of an existing aggregation level, the selected fields of the underlying aggregation level are displayed under Provider Fields.

  2. Define which characteristics and key figures you want to be available in the aggregation level.
    1. Switch from the Project Explorer view to the InfoProvider View. The system displays the InfoProvider underlying the aggregation level.
    2. From the InfoProvider view, choose the required characteristics and key figures, and drag these to the definition of the aggregation level.

      If you click on the provider field, the sysem displays the properties of the object on the right side of the screen.

      If you click on the associated object, the system opens the object display in a new window.

      Note

      The key figures contained in the aggregation level are aggregated using the characteristics not contained in the aggregation level.

    3. If you want to remove an InfoObject, open the context menu and choose Remove...
  3. Save the the definition of the aggregation level.
    • If you choose Save, the system saves the current definition of the aggregation level as an M version.
    • If you choose Activate, the system checks the current definition of the aggregation level and, if possible, saves it as an A version. The check result appears in the Problems View.

    Once it has been activated, the aggregation level is ready for use.