Using Data Analyzer to Preview Your Live Data Structure

Objective

After completing this lesson, you will be able to access data for your model with the data analyzer.

Data Structures for Data Analyzer

You can access the data from a live connection without creating a model by using Data Analyzer. Data Analyzer is a predefined ready-to-run service for SAP Business Warehouse (SAP BW) queries, SAP HANA Live views, SAP Datasphere models, and SAP Analytics Cloud models for ad-hoc analysis.

All SAP BW queries, SAP HANA Live views and models can be accessed directly in the Select Data Source. You can use Data Analyzer to preview your live data before creating a live data model.

Data Analyzer contains a table/chart area, a filter area, and a builder panel with navigation capabilities to add and remove dimensions and measures from the table/chart. In addition, you find a menu bar with a Refresh option and an Edit Prompts dialog.

The data analyzer

AI-Assisted Features in SAP Analytics Cloud

Once enabled by your administrator, SAP Analytics Cloud, AI-assisted calculations can be used when working in data analyzer. You can utilize natural language queries to generate calculation formulas in the calculation dialog.

With the Generate functionality, your query is translated into a formula. The Explain functionality translates existing formulas into natural language explanations, helping users understand complex formulas by translating them into simpler language.

SAP Analytics Cloud, AI-assisted calculations in Data Analyzer.

For more information on AI-assisted calculations, go to the SAP Help Portal Using AI-Assisted Calculations.

Create a Data Analyzer Insight and Add Conditional Formatting and Calculated Measures

Business Scenario: You have been asked by your team to create an insight accessing data from SAP HANA without performing a data import.

Task Flow: In this practice exercise, you will:

  • Create a new insight from an SAP HANA data source.
  • Add conditional formatting to the insight.
  • Add a calculated measure to the insight.