John SAP has Published 117 Answers

Using temporary license in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 15:25:29
Temporary License keys are automatically installed when you install the HANA database. These keys are valid only for 90 days and you should request permanent license keys from SAP market place before expiry of this 90 days period after installation.In below snapshot, you can see validity of Temp license key ... Read More

Different schema types in SAP HANA database

John SAP
John SAP
Published on 23-Apr-2018 14:56:44
In SAP HANA database, there are 3 types of schema −User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.System Defined Schema: These are generated as result of using HANA ... Read More

Getting error while using schema in SAP HANA Modeling

John SAP
John SAP
Published on 23-Apr-2018 14:46:55
When you use object of a schema to build HANA modeling views then it’s necessary to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema. You need to execute the following:GRANT SELECT ON SCHEMA "<SCHEMA_NAME>" TO _SYS_REPO WITH GRANT OPTIONTo use tables from one Schema to create views we ... Read More

Using Operators in Analytic Privilege in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 12:45:49
You have the following Operators that can be used to define restrictions

Consuming Attribute/Analytic view in a Calculation view in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 12:35:08
You can use Calculation View without Star Join to consume Attribute and Analytic view in SAP HANA. To use these views, you can add Projection node and add the views to the projections.In this, you can see how to create a Calculation view without Star Join. To add Project node, ... Read More

Hiding specific data in HANA Modeling View

John SAP
John SAP
Published on 23-Apr-2018 12:30:56
Analytic Privileges are used to limit access to HANA Information views. You can assign different types of right to different users on a different component of a View in Analytic Privileges.When it is required that data in the same view should not be accessible to other users who do not ... Read More

Using parallel processing in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 12:18:50
With the use of column based storage in HANA, data is available vertically and hence operations on different columns can be easily performed. When there is a requirement to process to process more than one column, it is processed by the different processor.

Increasing memory of traditional database as compared to SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 12:10:54
SAP HANA is not only a database but it is software and hardware innovation. You may get better result w.r.t Performance but HANA is not just a db with more memory.

Different options in Data Preview in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 11:58:08
When you click on Data Preview, you can see these optionsAnalysisDistinct ValueRaw DataWhen you use an Analytic view, under Analysis tab you can see both Attributes and Measures under Available objects and it can be dragged to Label and Value axis.Similar way you can “Distinct value” tab to see the ... Read More

Checking column properties in an Attribute view in SAP HANA

John SAP
John SAP
Published on 23-Apr-2018 11:44:07
This can be easily checked in Details pane. You need to select column name for which you want to check Properties of a column → right click → Properties
1 2 3 4 5 6 7 ... 12 Next
Advertisements