Show TOC

Procedure documentationOperational Analytics with Operational Data Provisioning

 

Operational Analytics allows you to perform reporting and analysis based on an application data model, without replicating the data in a data warehouse. Unlike strategic analysis, Operational Analytics mainly helps you to make decisions in operative business processes. Operational Analytics is characterized by a wide-ranging user layer in an enterprise, low latency, high granularity and high availability. If you use Operational Data Provisioning for Operational Analytics einsetzen, the data can be used by direct access by analytic queries. To enable faster data access, the data can be indexed in the SAP HANA database or in the SAP NetWeaver BWA.

Prerequisites

You have configured operational data provisioning in your application system.

More information: Configuring Operational Data Provisioning

Procedure

If you want to use Operational Analytics in your application system, proceed as follows:

  1. Prepare the search models and analysis models that you want to use:

    • If you want to use the search and analysis models delivered by SAP, activate the business function relevant for your application. Activate the relevant objects for your business function using the BI Content activation workbench.

      For more information, read the SAP Business Suite documentation.

    • If you want to use your own search models and analysis models, start by creating the models you need. You can also adapt the search models and analysis models provided to meet your requirements.

      More information: Creating or Adapting a Search and Analysis Model

  2. Optional: If the application you are using with the search and analysis models only provides a few authorization checks or none at all, you can specify authorization checks manually. This allows you to restrict access to the data of a TransientProvider derived from an operational data provider.

    More information: Modeling Authorizations

  3. Optional: TransientProviders derived from operational data providers can be used in MultiProviders.

    More information: Using MultiProviders Based on Operational Data Providers

  4. Optional: If you want to use SAP HANA or SAP NetWeaver BWA, perform the following tasks:

    1. To index the data of a search and analysis model in the SAP HANA database or BWA, you need to create a connector for the model.

      More information: Creating a Connector in Modeling

    2. Schedule the indexing.

      More information: Starting Connector Indexing.

      For indexing, you also have the following options:

    3. Monitor the status of the connectors and data indexing. The following tools are available here:

      • Connector status monitoring: Administration Cockpit

        More information: Administration Cockpit for Connectors

      • BWA monitoring: TREX Admin Tool (Standalone) or TREX Admin Tool in SAP system (transaction: TREXADMIN)

        For more details on this topic, read the information on TREX Admin Tools in the TREX 7.1 documentation.

      • Monitoring the SAP HANA database: administration console perspective of SAP HANA Studio

        For more information, go to http://help.sap.com/hanaInformation published on SAP site and read SAP HANA database - Administration Guide.

      • Delta queue monitoring. The queue is monitored for DataSources that replicate data for Operational Analytics to the BWA: Delta Queue Monitor

        More information: Monitoring Delta Queues

      • Monitoring Real-Time Indexing: Administration Cockpit and Delta Queue Monitor

        For further information about monitoring the indexing job, see Managing Real-Time Indexing

        For further information about real-time indexing for DataSource-based connectors, see Performing Real-Time Indexing for DataSource-Based Connectors

Result

The data is available for analysis and reporting with a query.

More information: Using Analytic Queries for Operational Data Providers