The Embedded Analytical tools may be divided based on usage. CDS Views are the foundation for all analytical applications. Programmers create a virtual data model using CDS views. In comparison, the key user uses CDS views to create dashboards. "Custom Analytical Queries" will be used to develop customer queries. Finance and Logistics end users. Use reports and dashboards created by the key user. Functional users will use SAP Smart Business Cockpits with predefined content for different multidimensional reports across all business lines.

Some multidimensional reports provide to end-users through SAP Fiori. They have flexible slice-and-dice navigation features. "Query Browser" will help end-users for analytic queries that allow them with flexible slice and dice reporting. "View Browser" is another tool to check the delivered CDS Views and Queries. These tools help the Functional team ( Finance, Logistics, ………… users) to get reports with no latency, no data duplication, excellent performance for all types of reports, Integration scenarios with SAP BW, and also Support for SAP ERP authorizations.

1. Report Design Modeler — Apps

*See picture 1 labeled below

The Report Design Modeler apps are a set of SAP Fiori apps that customers can use to create and manage Financial or Logistics or any other reports. When created an evaluation, we choose a tile to visualize the reports in the Publish Report app.

*See picture 2 labeled below

You define this using the Configure Report Drill-Down app.

*See picture 3 labeled below

Business knowledge helps to configure the drill-down views. Configure Report Drill-Down app is used by power users who can see data in Graphs IT administrative knowledge is needed to authorize users to get access to these reports

You may use this capability for all most all Finance reports like:

Analyze Actual Cash Flow, Liquidity Forecast, Budget Alerts, Contract Expiry, Aging Analysis,

Analyze Change Impact, Analyze Collections Success, Analyze Collections Volume, Analyze Credit Exposure, Analyze Open Credits, Analyze Overdue Items / Overdue Item Analysis, Analyze Payment Locks, Analyze Payment Run Exceptions, Cash Discount Utilization, Cash Discount Forecast, Cash Collection Tracker - Accounts Receivable, Cash Position, Analyze Returns, Operational Supplier Evaluation / Supplier Evaluation, Payment Statistics, Credit Limit Utilization, Days Payable Outstanding Analysis,

Days Sales Outstanding, Detect MRP Situations, Future Receivables, Future Payables……….Etc.

2. Overview of View Browser and Query Browser

The View Browser

View browser allows Power users from all business lines to explore thousands of VDM views without any technical skills. So, it helps Business Users to draw meaningful reports for their business requirements. You can find suitable views based on your need and display its content for analytical queries in Design Studio. Using View Browser, we can explore standard Core Data Service views (Composite and Consumption) and create developers.

+

*See picture 4 labeled below

The Query Browser

The Query Browser is a default Design Studio app that is available in the standard SAP Fiori Library.

The Query Browser is not part of the SAP Fiori launchpad's default view and is added to the My Home group. The Query Browser will show consumption views that were annotated as Analytical Query and therefore act as a source for KPIs. Users can select an Analytical Query and perform on-demand reporting on it.

The Query Browser is a default Design Studio app available in the standard SAP Fiori Library. No additional installation is required.

In the Query Browser, you can see many analytical queries.

*See picture 5 labeled below

Business catalog SAP_CA_BC_VDM is to assigned to the user.

3. Custom Analytical Queries app

For creating Financial or Logistics or a report that is needed from any business line, from scratch, SAP provides the built-in, easy-to-use, Custom Analytical Queries app. It is aimed at key users, rather than end-users. An advantage of it is that you don't have to understand the query language to build a query.

*See picture 6 labeled below

Required Business Role: SAP_BR_ANALYTICS_SPECIALIST

Required Technical Catalog: SAP_BASIS_TCR_T

Activated ICF node: ANA_QDESIGN_MAN (ICF path /sap/bc/ui5_ui5/sap/ana_qdesign_man)

Example: Power-user wants a report from Cost Center Module.

Customers can create a Custom Analytical Query to report in Cost Center Module on Actual Vs. Plan data. We can also have a drill-down facility

*See picture 7 labeled below

4. The Report Designer Modeling apps

The Report Designer Modeling apps are a set of SAP Fiori apps that a key user uses to define or manage reports.

*See picture 8 labeled below

These Reports are based on the Analytical List Page Smart Template.

Customers can Create Reports using create report app based on measures of the related Analytical Query.

Just enter the relevant data source details such as the Core Data Services (CDS) view, the OData service path, and the entity set that corresponds to the CDS view.

*See picture 9 labeled below

Choose Activate and Add Evaluation.

5. The KPI designer - Smart Business Framework

SAP Fiori Smart Business helps customers create their analytical apps based on Key Performance Indicators (KPIs).

*See picture 10 labeled below

Smart Business Cockpits can be personalized. They bring analytics into the business process when the user needs it. Customers can develop an Analytical Query to analyze business data using the KPI Designer tool.

You can create a KPI, in the following order:

· Create KPI

· Create Evaluation

· Create Tile

· Configure Drill-Down

· Manage KPI Associations (optional)

6. SAP Analytics UIs

SAP Analysis for Microsoft Office is a Microsoft Office Add-In that allows multidimensional Analysis When you install Analysis for Microsoft Office on your local machine; you can connect directly to the following:

SAP Business Warehouse (BW) system

SAP Business Objects Business Intelligence (BI) Platform

SAP HANA

Using Analysis for Office, you can also access Core Data Services view based queries and view the report.

7. SAP delivers several standard reports.

You can find these reports at various locations under the Information System in the SAP Easy Access menu.

*See picture 11 labeled below

Almost every application in the system has an Information System menu option, which contains the reports predefined by SAP. You can also display thru SE43.

*See picture 12 labeled below

You can search standard reports in SE38, by the letters they contain. For example,

Vendor related reports can are found by RFK*

Customer-related Reports can be searched by letter RFD*

General ledger RFS*

Document Reports: RFB*