- 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 Attribute View – Create Attribute View in 9 Easy Steps
In previous topic we learn little and recall the significance of information modeling in SAP HANA. Information models or Views are logical frameworks or run-time objects which structures data from one-dimensional databases into multi-dimensional data structures for analytical purposes. The information views do not store data physically in SAP HANA. The logic of a view is stored in HANA and every time a reporting tool requests the view, the system fetches the data according to the blueprint of the view from the data source and presents it to the user.
What is SAP HANA Attribute View?
The Attribute View in SAP HANA is a set of dimensions or master data which can be joined with the fact table in an Analytic View. An Attribute View can be created by taking data from one or more data tables. The attribute shows relationships between different attributes. The attributes can be Customers, Region, Product, Period etc. In an Attribute View, joins can be made between two master data tables, a text table, and a master data table, etc.
Types of Attribute View
Standard Attribute Views:
These views create by table fields among different column store tables by using joins in SAP HANA.
Derived Attribute Views:
It is an Attribute View created using another existing Attribute View. It will open in read-only mode, we cannot edit the derived Attribute view. The only editable field in the created Attribute View is the description. It will act as a reference to the base Attribute view. Any modification to the base Attribute View will reflect in the created Attribute View.
Timed Attribute Views:
Timed Attribute View stores the time-dependent data. It is created against calendar tables – M_FISCAL_CALENDAR (or) time tables – M_TIME_DIMENSION, M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH and M_TIME_DIMENSION_WEEK. All these tables stores in _SYS_BI schema.
Types of Joins
Tables from data sources join in different ways to create an Attribute View in SAP HANA. The join types are:
- Inner Join
- Left Outer Join
- Right Outer Join
- Text Join
Along with defining the join type of the Attribute View, the cardinality of tables is also important to specify. The cardinality can be 1:1, 1: N or N:1.
Types of Hierarchies
Along with cardinality, and join type, dimensions in Attribute View arranges in hierarchies. There are two types of hierarchies in which attributes in a set gets arrange; Level hierarchy and Parent-Child hierarchy.
- The level hierarchy follows a rigid pattern of root and child nodes where successive attributes can be accessed only in the order they were created.
- A parent-child hierarchy is like a tree structure where there are multiple sub-nodes of a root node which can further extend to an undecided length. Thus, the tree-like structure has unbalanced root nodes.
Creating an Attribute View in SAP HANA
Before we learn how to create the Attribute View in SAP HANA Modeler, let us understand the process flow in order to create a complete and proper Attribute View.
Enter the technical name of the table and mention the table type.
Select tables from the database schemas. You can select tables from more than one schema. If you select multiple tables, joins can create between them in this step.
Define the key column and select the output column.
You can carry out transformation processes on columns like creating calculated columns, creating hierarchies, etc.
Active and data preview:
At last, you can activate the Attribute View after saving the selections made by you and go to Data Preview to preview the view created.
Attribute View Creation
Here are the steps to create an Attribute View in SAP HANA Modeler:
Open packages in the Content folder in the SAP HANA Modeler.
Then, select an existing package or create a new package from the Content node.
Right-click on the package name, go to New and select Attribute View option.
Enter the technical name of the view carefully, as it cannot be changed later. Also, you can enter a label name. From the Copy From option, you can select an existing Attribute View to act as a basis for the new one. Select a subtype and click on Finish.
Then, a view editor will open. The Semantics section shows all the details that relate to the columns from the tables. And, you can create the Attribute View in the Data foundation section of SAP HANA Modeler.
After that, you can select the table from the schema in two ways. Either by finding the table under the schema name in Catalogue node and dragging-dropping the table on the editing pane. You can add tables from more than one schema and create joins between them.
Or, by clicking on the green plus sign next to the Data foundation section and searching the table by name.
Now, its time to select columns from the table to add into the Attribute View in SAP HANA Modeler. You can add columns into the view in two ways; either by right-clicking on the column name and selecting Add to Output. The column name will show in the right-most Output column and also on the Data foundation at the left. Or, you can simply click on the dot present in-front of the column name and it will turn orange indicating that it is added.
If you wish to remove a column from the Output, right-click on the column name and click on Remove.
Next, you can go to the Semantics section from where you have to select at least one column as the key attribute. From the properties section in SAP HANA Modeler, you can see the properties of the Attribute View. Also, you can set the Cache Invalidation Period which sets the time of data loading from the RAM to the cache. The data tables stay into the cache for that defined period. And, create hierarchies from the Hierarchy section.
Upon completing all the processes of adding columns and tables to create the Attribute View, save and activate the view by clicking on the green tick icon and green arrow given on the panel on top. Then go to the Data preview icon.
The data preview window contains three tabs; Analysis, Distinct values, and Raw data. The raw data section shows the data in tabular form.
Lastly, you can do instant analysis using the data from the columns in the Analysis tab. Just drag-and-drop the columns in place of two axes and visualization create.
Apply now for Advanced SAP Course