- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
SAP HANA Analytic View
After learning about the Attribute View, let’s move on to understanding the Analytic View.
What is SAP HANA Analytic View?
The Analytic Views in SAP HANA are one step ahead in terms of complexity as compared to the Attribute View. The Analytic Views are multi-dimensional views involving attributes and measures arranged in a star schema fashion.
In the center lies the fact table, which is a table containing measure columns from the transactional SAP HANA database.
Surrounding this fact table is a different set of attribute tables/views. The attributes or dimensions attached to the fact table making an analytic view provides relevance to the measures in the fact table. Thus, a user can examine data (transactional data) from different perspectives.
For instance, you can have a fact table named Sales linked to four attribute views or dimensions such as Region, Period, Customer, and Product. That is, sales can be analyzed with respect to the regions, customers, years, or products.
The multi-dimensional view created in the analytic view is also representative of OLAP cubes.
Features of SAP HANA Analytic View
Some important features of the analytic view in SAP HANA are:
- Analytic views run start schema queries.
- The measures used in the fact table can be calculated measures or restricted measure.
- You can perform complex calculations and apply aggregation functions (sum, min, max, count etc.) on the data used in the Analytic View.
Steps to Create an Analytic View in SAP HANA
Here are the steps to create an Analytic View in SAP HANA Modeler:
Open SAP HANA Modeler perspective in the SAP HANA Studio.
Your pre-existing attribute views will be present within a package in the Content node.
Right-click on the package for which you need to create an Analytic View in SAP HANA which also contains the attribute views. Click on New and select Analytic view from the drop-down list.
Enter the technical name of the view and add a description. You can set other properties as well, like view type, subtype etc. Click on Finish.
The design view for the analytic view in SAP HANA Modeler opens.
From the semantics section, you can access the columns, view properties, hierarchies and variables or parameters.
Now its time to add tables into the Data foundation. You can add the data tables from the left panel either by dragging and dropping or by searching the table’s name, Add Objects icon.
If you have more than one table selected, then you need to define a join condition and cardinality. Here, in the image shown below, we have selected join type as inner join and set cardinality as 1: N in the join created two tables ORDERS and ORDERDETAILS.
Next, we have to select columns for output from both tables by clicking on the grey dots given in front of each column of the table which will turn orange as a sign of being added into the output.
Now we will go to the “start join” section to link all the attributes views with the data foundation (fact table). As you can see in the image below, we have selected three attribute views in the Star Join section; AT_CUSTOMER, AT_PRODUCTS and AT_TIME.
Three separate tables for the three attribute views will get add in the editor pane.
We will join the fact table with the attribute view table with common columns, as shown in the image below. We have joined the two tables (fact table and attribute view) with the column CUSTOMERNUMBER.
Also, we have defined the join type as an outer join.
We will join the two other attribute tables with the fact table in the same way. This will form a star schema like structure of tables.
Next, we’ll define measures and dimensions for the table from the Semantics section. You can tag the measure fields as measures from clicking on the columns and then on the yellow icon on the bar (indicated by the blue arrow). And similarly, tag the dimensions by selecting the attribute icon shown by the red arrow.
After assigning the measures and dimensions, save the Analytic View in SAP HANA Modeler by clicking on the green tick and execute the view by clicking on the green arrow (shown in the red box).
After validating and executing it, open the data preview section. There, the raw data from all the tables of the Analytic View in SAP HANA Modeler will get load.
From the Analysis section, you can quickly analyze the data by selecting attributes and measures to create different charts and graphs like a bar graph, Mekko chart, pie chart, scatter chart etc.