John SAP has Published 117 Articles

Adapters supported under Smart Data Access in SAP HANA

John SAP

John SAP

Updated on 17-Jun-2020 11:07:25

199 Views

Below is the list of Adapters which are supported under Smart Data Access in SAP HANA −This comes while creating a new Remote Data Source.

Limitations of using SAP HANA Smart Data Access

John SAP

John SAP

Updated on 17-Jun-2020 11:04:38

243 Views

Following are few limitations of using SAP HANA Smart Data Access −Virtual Tables cannot be used in multi node HANA cluster. However, it is possible to access virtual table from one HANA server to other.In SAP HANA, few of Analytical view does not support virtual tables so SDA is not ... Read More

Exporting a Delivery unit in SAP HANA using HANA Studio

John SAP

John SAP

Updated on 16-Jun-2020 13:02:17

259 Views

In SAP HANA system, you have to assign packages to Delivery unit. Once packages are assigned to export DU, you can see the list of DU’s by using Export option −Go to File → Export → Delivery Unit → Select the Delivery UnitYou can also select export location:Export to ServerExport ... Read More

Getting an error while previewing swf file from XML data in SAP Dashboard Designer

John SAP

John SAP

Updated on 15-Jun-2020 12:06:33

104 Views

There could be multiple reasons that this error comes up. Try below steps:Adobe Global Security Settings changesMade entries in windows host file andAdded SAP server as trusted site in IEThis purely seems to be a security setting issue in Adobe Flash Player. There are various SAP notes that you can ... Read More

Using temporary license in SAP HANA

John SAP

John SAP

Updated on 12-Mar-2020 11:14:20

443 Views

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

Updated on 12-Mar-2020 10:57:29

1K+ Views

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

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

John SAP

John SAP

Updated on 12-Mar-2020 08:14:26

179 Views

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

Updated on 12-Mar-2020 08:11:52

98 Views

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

Count distinct entries in SAP BusinessObjects

John SAP

John SAP

Updated on 06-Mar-2020 05:22:37

449 Views

Your requirement is not clear but I think you should use AND operator and count on this in the third column. Your formula should be like this=([First_Seen] = 1) and ([Authorized] = 1)Consuming Graphical calculation view via SDA

Advertisements