1 / 6

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.<br><br>https://www.ducatindia.com/Best-sap-erp-training/

ducathub
Download Presentation

SAP HANA Attribute View

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Language | Industrial Training | Digital Marketing | Web Technology | Testing+ | Database |  Networking | Mobile Application | ERP | Graphic | Big Data | Cloud Computing WELCOME TO DUCAT INDIA SAP HANA Attribute View 7070905090 info@ducatindia.com

  2. In previous topic we learn little and recall the significance of information modelling 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. SAP HANA Attribute View – Create Attribute View in 9 Easy Steps

  3. 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: Types of Attribute View 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.

  4. Tables from data sources join in different ways to create an Attribute View in SAP HANA. The join types are: Referential Join • 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 Joins

  5. 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. Types of Hierarchies

  6. SAP HANA Attribute View 7070905090 info@ducatindia.com THANK YOU

More Related