Show TOC

Procedure documentationAnalytic Index Locate this document in the navigation structure

 

In data target Write Data to Analytic Index, you can save calculation results from an analysis process in an analytic index. An analytic index is a data container whose data is stored in the BW Accelerator and is used to generate a TransientProvider. A TransientProvider is an InfoProvider that a BEx query can be executed on without the need for the InfoProvider to be modeled in the Data Warehousing Workbench or the data to be replicated. The modeling is derived from an application, from the analytic index in this case.

Analytic indexes can be created and filled with (transformed) data quickly. They are therefore suited for quick ad hoc analyses.

Note Note

Note that a backup and restore process is not implemented on the system for analytic indexes. To store the data on a long-term basis, you should select a different InfoProvider type.

End of the note.

The analytic index stores its data in a star schema. The characteristics of an analytic index are stored in the dimensions. These dimensions can carry attributes. Last Name is a possible attribute of User for example. The analyzed key figures such as Sales or Sales Quantities are stored in the fact table and are called facts.

As well as the fact and dimension data, an analytic index can also contain authorization data. Like with analysis authorizations, this authorization data ensures that users can only display data in the query if they are authorized. When data in an analytic index is created, changed, loaded or deleted, this is logged in the application log under Analytic Index (AIND). The authorizations for these actions are assigned using authorization object S_RS_AI.

Prerequisites

You are using a SAP NetWeaver BW Accelerator (BWA) or a SAP HANA database.

Procedure

  1. Enter a description for your analytic index.

  2. Enter the name of an existing analytic index or create a new one.

    Enter an index ID as the technical name for your analytic index as well and choose Create.

    The technical name is always converted into lowercase letters, as this is how TREX processes them.

    If the data target in your analysis process is already connected with the previous node, a proposal for the analytic index (for the dimensions and key figures) is created from the input structure of the data target.

    More information: Creating an Analytic Index

  3. Under Data View, define whether the analysis process will post facts, dimension data or authorization data. Create an analysis process for each data mart:

    • Facts: The analytic index expects the data in the structure of dimensions and key figures. In the analysis process, assign the fields to the result structure of this entry structure for the analytic index. Two write modes are supported: Replace Existing Facts and Add Data.

    • Dimensions: Specify a dimension whose attributes you want to load. Each data record in the analysis process result contains a characteristic of the dimension and the associated attribute values. You have the option of only loading certain attributes of a dimension.

    • Authorizations: For authorization-relevant dimensions that do not reference characteristics, load the authorizations filling a structure in the same way as for analaysis authorizations with the following fields: Attribute Name (ATTR_NAME), User (USERNM), Authorization (Technical Name) (AUTH), InfoObject (IOBJNM), Sign (SIGN), Selection Operator (OPTION), Selection Value (Lower Limit) (LOW) and Selection Value (Upper Limit) (HIGH). You do not need to specify the InfoObject if you always fill the attribute name (dimension). This also means that you can leave the attribute name blank if it can be determined from the InfoObject.

    You can either extract the authorization data from an InfoProvider or extract an assignment of users and values from an xls file. To extract analysis authorizations from an InfoProvider, you can use data source Analyssis Authorizations.

  4. Choose OK. Data target Analytic Index will be created.