How to Use the Analytic Manager in SAP BW/4HANA

SAP BW/4HANA is a next-generation data warehousing solution that enables you to optimize processes and enable innovation with one trusted source for all insights. One of the key components of SAP BW/4HANA is the Analytic Manager, which is a server component that provides extensive analytic functions and services. In this blog post, we will explain what the Analytic Manager is, how it works, and how you can use it in your system with some examples.

What is the Analytic Manager?

The Analytic Manager is a component of the SAP BW/4HANA server that lies between the user and the database. It makes the multidimensionally formatted data available to both the front end and, using special interfaces (Open Analysis Interfaces), to third-party administrator front ends. The Analytic Manager provides the following functions and services:

It executes queries on InfoProviders, which are the data stores in SAP BW/4HANA.
It applies transformations and calculations on the data retrieved from the database.
It formats and aggregates the data according to the query definition and user input.
It supports various analysis and navigation functions, such as drill-down, drill-through, filtering, sorting, ranking, etc.
It supports various query properties and settings, such as currency conversion, exception aggregation, authorization checks, etc.
It supports various query types, such as BEx queries, HANA views, CDS views, etc.
It supports various query output formats, such as MDX (Multidimensional Expressions), BICS (Business Intelligence Consumer Services), OData (Open Data Protocol), etc.

How does the Analytic Manager work?

The Analytic Manager works by processing queries from different BI clients and delivering results in different formats.

The query processing involves the following steps:

The BI client sends a query request to the Analytic Manager using one of the supported interfaces (MDX, BICS or OData).
The Analytic Manager parses the query request and validates it against the metadata of the InfoProvider.
The Analytic Manager generates a SQL statement that is sent to the SAP HANA database.
The SAP HANA database returns a result set that matches the query criteria.
The Analytic Manager applies any additional transformations and calculations defined in the query request or in the InfoProvider.
The Analytic Manager formats and aggregates the result set according to the query definition and user input.
The Analytic Manager sends the result set to the BI client using one of the supported formats (MDX, BICS or OData).

How to use the Analytic Manager with examples?

You can use the Analytic Manager with different BI clients and query types to access and analyze data from SAP BW/4HANA. Here are some examples of how you can use the Analytic Manager with different scenarios.

Example 1: Using Eclipse-based BW Query tool

The Eclipse-based BW Query tool is an integrated tool for creating and executing BEx queries on SAP BW/4HANA. You can use it to define and modify your queries using drag-and-drop operations. You can also preview and test your queries directly from the tool without switching to another application.

To use the Eclipse-based BW Query tool, follow these steps:

Connect to your SAP BW/4HANA project and select an InfoProvider as the basis for your query.
Right-click on the InfoProvider and select New -> Query.
Enter a technical name and a description for your query.
Go to the Sheet Definition tab and drag-and-drop characteristics and key figures from the InfoProvider structure to the Rows and Columns sections.
Go to other tabs and sections to access different aspects of your query, such as general properties, filters, variables and jump targets.
Save and activate your query.
Click on Execute Query icon to run your query and see the results.

Example 2: Using Web Intelligence

Web Intelligence is a web-based BI client that allows you to create interactive reports and dashboards on SAP BW/4HANA data. You can use it to access data from different types of queries, such as BEx queries, HANA views or CDS views.

To use Web Intelligence with SAP BW/4HANA data, follow these steps:

Create an OLAP connection based on BICS connector for your SAP BW/4HANA system.
Launch Web Intelligence from SAP BusinessObjects BI Launchpad or from a web browser.
Create a new document based on your OLAP connection.
Select a query type (BEx Query or HANA View) and a query object from your SAP BW/4HANA system.
Define your query filters and prompts if needed.
Run your query and see the results in a report or a dashboard.
Use various analysis and visualization functions to explore and present your data.

Example 3: Using SAP Analytics Cloud

SAP Analytics Cloud is a cloud-based BI platform that allows you to create stories and applications on SAP BW/4HANA data. You can use it to access data from different types of queries, such as BEx queries, HANA views or CDS views.

To use SAP Analytics Cloud with SAP BW/4HANA data, follow these steps:

Create a live data connection for your SAP BW/4HANA system.
Launch SAP Analytics Cloud from a web browser.
Create a new story or application based on your live data connection.
Select a query type (BEx Query or HANA View) and a query object from your SAP BW/4HANA system.
Define your query filters and variables if needed.
Run your query and see the results in a story or an application.
Use various analysis and visualization functions to explore and present your data.

Conclusion

The Analytic Manager is a component of the SAP BW/4HANA server that provides extensive analytic functions and services. It executes queries on InfoProviders, applies transformations and calculations on the data, formats and aggregates the data, supports various analysis and navigation functions, supports various query types and output formats. You can use the Analytic Manager with different BI clients and query types to access and analyze data from SAP BW/4HANA. You can also use the Open Analysis Interfaces to integrate third-party BI clients with the Analytic Manager.

We hope this blog post has helped you to understand what the Analytic Manager is, how it works, and how you can use it in your system with some examples. If you have any questions or feedback, please leave a comment below.

This content is generated by AI.