Found 594 Articles for SAP Basis

Consuming Attribute views in an Analytic view in SAP HANA

SAP ABAP Expert
Updated on 18-Jun-2020 09:28:51

127 Views

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.

Using Analytic View in SAP HANA

SAP Developer
Updated on 18-Jun-2020 09:21:55

210 Views

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

Activating an Attribute view in SAP HANA

Anil SAP Gupta
Updated on 12-Mar-2020 11:39:45

113 Views

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.

Performance Analysis of an Attribute view in SAP HANA

SAP Developer
Updated on 18-Jun-2020 08:59:49

281 Views

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.

Defining a primary key in an Attribute view in SAP HANA

Anil SAP Gupta
Updated on 12-Mar-2020 11:35:49

449 Views

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

Using Permanent license key in SAP HANA

SAP Developer
Updated on 30-Jul-2019 22:30:22

259 Views

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

Using Time subtype of an attribute view in SAP HANA

SAP Developer
Updated on 18-Jun-2020 08:45:52

188 Views

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

Difference between Copy and Derived view in SAP HANA

John SAP
Updated on 18-Jun-2020 08:48:42

187 Views

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

Different SAP HANA Administration tools

SAP Expert
Updated on 30-Jul-2019 22:30:22

171 Views

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

Extended application Service in SAP HANA

SAP ABAP Expert
Updated on 12-Mar-2020 11:08:13

212 Views

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.

Advertisements