1. SAP Glossary
  2. SAP HANA
  3. attribute view


What is 'attribute view' in SAP HAN - SAP HANA?


attribute view - Overview

  • Component: HAN

  • Component Name: SAP HANA

  • Description: SAP A SAP A information view that is used to define joins between tables and select a subset or all of their columns. The selected rows can be restricted by filters. Another application of attribute views is in the role of a dimension in a star schema defined by an analytic view. In this case, the attribute view adds more columns and also hierarchies as further analysis criteria to the analytic view. In the star schema of the analytic view, the attribute view is shown as a single dimension table that can be joined to a fact table. For example, attribute views can be used to join employees to organizational units and then the result can be joined to a sales fact table in the analytic view.


attribute view - Details


  • Key Concepts: An attribute view is a type of information view in SAP HANA that allows users to access and analyze data from multiple tables. It is used to create a virtual layer of data that can be used for reporting and analysis. The attribute view is based on the star schema, which is a type of database model that organizes data into facts and dimensions.
    How to use it: Attribute views are created in the SAP HANA Modeler. The user must first define the tables and columns that will be used in the view. Then, the user must define the relationships between the tables and columns. Finally, the user must define the measures and calculations that will be used in the view. Once the view is created, it can be used for reporting and analysis.
    Tips & Tricks: When creating an attribute view, it is important to ensure that all of the tables and columns are properly linked together. This will ensure that all of the data is properly organized and can be easily accessed for reporting and analysis. Additionally, it is important to ensure that all of the measures and calculations are properly defined so that they can be accurately used for reporting and analysis.
    Related Information: Attribute views are just one type of information view available in SAP HANA. Other types of

    Already have an account? Login here!





attribute view - Related SAP Terms

Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant