SAP ABAP Expert has Published 141 Articles

Finding a database view in SAP HANA database

SAP ABAP Expert

SAP ABAP Expert

Updated on 22-Jun-2020 08:40:26

This is created under the Current schema in your SQL editor. You can check schema name at the top −In the above snapshot, you can see the current schema name where the view is created. You need to find this schema under the Catalog folder in HANA Studio.

Example of creating a database view in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 22-Jun-2020 08:39:43

Let us see the below table ARTICLE_LOOKUP, we will create a database view with first 4 columns and will hide Family_NAME and FAMILY_CODE.SQL statement- To create a view on the above table, write down the below SQL statementcreate view view_Articlelookup as select ARTICLE_ID, ARTICLE_LABEL, CATEGORY, SALE_PRICE from "AA_HANA11"."ARTICLE_LOOKUP";This will create ... Read More

Hiding a column in Data Preview in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 09:34:10

In Analytic View, to hide few of columns you have to click on Semantics in scenario pane. There you can select the checkbox in front of column name that you want to hide.

Consuming Attribute views in an Analytic view in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 09:28:51

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 ... Read More

Data Preview option in HANA Modeling view in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 09:05:24

Once HANA Modeling view is activated, you can use Data Preview option to analyze the data in HANA Modeling view. To see Data Preview, you can right-click on View name → Data PreviewYou can also click on the icon as shown in below snapshot:

Using Attribute view in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 08:37:28

In SAP HANA Modeling, Attribute View is developed on the top of Dimension tables. They are used to join Dimension tables or other Attribute Views. It is also possible to create a copy of an existing Attribute View from already existing Attribute Views inside other Packages but you can’t edit ... Read More

Checking all tables and schema in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 08:00:36

When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system.To see the list of all schema and tables, you need to navigate to Catalog tab.Other available tabs in HANA Studio includes:BackupCatalogProvisioningContentSecurityYou can check under ... Read More

Checking topology of SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 18-Jun-2020 07:42:40

The topology of SAP HANA system is maintained by Name Server. This is used to manage all the running components and data stored in each component.

Time taken by savepoint to perform backup in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 17-Jun-2020 09:21:16

M_SAVEPOINTS view stores Current and historical savepoint statistics. There is column DURATION which tells the total time taken by savepoint.You can extract the following information from the numbers in this view −CRITICAL_PHASE_DURATION shows the period of time during which the updaters were blocked in a savepoint. Normally, this should be ... Read More

Path for file based data backups in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 17-Jun-2020 09:20:42

All the information is available under global.ini file which stores global configuration properties for each service in the landscape.These are the global properties most frequently used for extended storage configuration −               Name                                                Section                                                  Value                  Defaultbasepath_databackup  persistence        File path($DIR_INSTANCE)/backup/data               

Advertisements