Show TOC

Procedure documentationCreating an Analytical Index Locate this document in the navigation structure

Procedure

  1. Specify an InfoArea to assign the analytic index to. The analytic index is not displayed under this InfoArea in Data Warehousing Workbench, but the assignment is required to open a query in Query Designer.

  2. Select a loading type. You can load the facts with or without keys. Without keys, new data records are always added. With keys, data records with new key combinations are added, while data records with existing key combinations are changed.

    Tab Page Dimensions:

  3. If you have selected Fact Index with Key, you can flag the dimension as part of the key. If this flag is set, the dimension is added to the physical fact index as part of the key. When loading a new record to the fact index, it overwrites any existing records that have exactly the same key parts.

  4. By choosing Attributes, you can assign attributes and flag them as navigation aattributes. Attributes can be used to display other properties for selection or query navigation.

  5. You can assign InfoObjects: This results in the metadata on the flat view of the data becoming a multidimensional view.

    The assignment supports you in the following two scenarios:

    • When loading data: The assigned characteristic makes it possible to assign fields automatically in Analysis Process Designer in order to connect the source structure with the target structure for the analytic index. You can also change the assignment by specifying the characteristic name instead of the dimension name when loading authorization data.

    • Im Reporting: If you have set the Reference InfoObject flag for the dimension, the properties of the characteristic will be used for the analysis, meaning that display attributes and hierarchies can be used. To do this, you need to make sure that all dimension data also exists in the characteristic master data.

  6. You can set the Reference InfoObject Metadata flag.

    Transient InfoObjects OLAP reporting are derived for from the dimensions and key figures of an analytical index. These InfoObjects therefore do not belong to the BW Repository. These transient InfoObjects can reference existing InfoObjects if you set this flag.

    If this flag is set for a dimension, the properties of the referenced characteristic are used. This ensures that all master data attributes, hierarchies and authorizations for the characteristc are available during the analysis. The display attributes of the analytic index are then replaced by the InfoObject attributes. The authorizations for the referenced characteristic support "flat" conditions, but do not support hierarchies. If this flag is set for a key figure, the properties of the referenced key figure are used (like display).

    Note Note

    If this flag is set when the query is executed, the facts are converted to the data type of the InfoObject. This can cause loss of data (rounding of key figures, cutting off dimensions(. You should try to make sure that these losses of data do not occur.

    End of the note.

  7. You can select the dimensions as authorization-relevant. If this flag is set, the system runs a check when executing a query on the TransientProvider and navigating in a query to ensure that the user is authorized for all dimension data flowing into the result set. The data for the TransientProvider is only displayed if this is the case.

    You then have to load the authorizations too.

    If you have defined that the dimension references an InfoObject, the InfoObject then decides about authorization-relevance. The analysis authorizations for the InfoObject are then analyzed when the query is executed.

  8. You can specify a data element that allows proposals when making the field assignment in Analysis Process Designer. This is only necessary if the data source also contains data elements, for example with database tables.

    Tab Page Key Figures:

  9. The options here are similar to on the Dimensions tab page, with the difference that the attributes in the Unit Dimension column can be entered.

    Tab Page Data:

  10. This provides you with an overview of the data loaded so far. Under Others, you see the memory space needed by the administration data needed to create SIDs.

  11. By choosing Where-Used List on the Data tab page, you can see which analysis process was used to load the data in each load run. By choosing Where-Used List in the toolbar in the analytic index, you can also view the analysis processes that read the data from the analytic index and the queries that display the data.

  12. By choosing Monitor on the Data tab page, you can call the monitor for individual load runs. By choosing Monitor in the toolbar in the analytic index, you can view the monitor for the entire analytic index.

  13. Check the analytic index and activate it. When the analytical index is activated, the TransientProvider is generated and the name of the derived characteristic is displayed in the Derived InfoObject column. Below this, this dimension is displayed in a query on the TransientProvider.

    The TransientProvider is given a generic name with the prefix @3.

    Caution Caution

    After an analytic index has been created in a structure, it cannot be changed. Note in particular that you cannot add any new dimensions or attributes.

    End of the caution.