SAP Basis Articles - Page 29 of 60

When you create an Analytic View, you get an option of Data Foundation and Star Join. At Data Foundation level you can add objects- columnar tables and at Star join you can add other Attribute views.When you click on “+” sign, you get an option to search all Attribute views in the repository.

You are correct. In SAP HANA, Analytic Views are used to implement Star Schema queries wherein we join one Fact table to multiple Dimension tables. Analytic views use the real power of SAP HANA to performcomplex calculations and aggregate functions by joining tables in form of star schema and by executing Star schema queries.Following are key characteristics of SAP HANA Analytic View:Analytic Views are used to perform complex calculations and Aggregate functions like Sum, Count, Min, Max, Etc. Analytic Views are designed to run Start schema queries.Each Analytic View has one Fact table surrounded by multiple dimension tables. The fact table ... Read More

This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.

In SAP HANA Modeling, you have an option of switching to Performance Analysis mode. This is used to check if Joins in Attribute view are meeting with performance optimized joins and cardinality based on data in the table.You can see 2 options when you select Performance Analysis mode:Join Details:This defines Join type used and proposed cardinality based on data in the tableData Source Details:Defines table type, partition type and a number of rows in tables.

This can be done by selecting column name from the list of columns under Output pane.

Permanent License keys are valid only until the predefined expiration date. License keys specify the amount of memory licensed to target HANA installation.

Time subtype Attribute View is a special type of Attribute view that adds a Time Dimension to Data Foundation. To know more about the difference between Standard Attribute view and Time Attribute view, you can refer this SAP thread:https://archive.sap.com/discussions/thread/3253551

Following are the key points about using Derived view in SAP HANAThe derived attribute view will be similar in all the characteristics as the base view (except the name) It is not possible to edit any semantic/data foundation design in the derived attribute view. When there is any change in the base view, the changes will be reflected in the derived attribute view too. This helps reduce extra efforts of replicating the changes in the derived view.When you want to define an Attribute view on the top of an existing object as copy, you can use Copy From option. This can be ... Read More

There are various tools but most commonly includes HANA Studio and HANA Cockpit. Following are common HANA Administration Tools −SAP HANA CockpitThis is an administration tool to manage your SAP HANA system and is based on SAP Fiori Launchpad based navigation to access long range of HANA applications. SAP HANA cockpit can be accessed via a web browser.SAP HANA StudioUsing SAP HANA Studio, you can perform system administration and monitoring activities in a distributed environment. You can create users with different access privilege, backup and recovery, and data provisioning using HANA Studio.HANA Studio is an Eclipse-based tool and is available ... Read More

XS is a Web server responds to provide a development platform and provides end to end support for web-based applications.XS engine helps external Java and HTML based applications to access HANA system with help of XS client. As SAP HANA system contains a web server which can be used to host small JAVA/HTML based applications.