Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by John SAP
Page 3 of 9
Exporting a Delivery unit in SAP HANA using HANA Studio
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 to ClientThis means that a Delivery unit can be exported to HANA Server location or to a Client location as shown in the below snapshot. It also shows you list of all packages that will exported with Delivery unit you have selected from drop down list.
Read MoreGetting an error while previewing swf file from XML data in SAP Dashboard Designer
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 search however I am not aware any relevant one.
Read MoreDifferent schema types in SAP HANA database
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 related functions. These are of following types −_SYS_BI_SYS_BIC_SYS_REPO_SYS_STATISTICS_SYS_XS-ENGINESLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.
Read MoreConsuming Attribute/Analytic view in a Calculation view in SAP HANA
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, you can simply drag it from the right side.
Read MoreHiding specific data in HANA Modeling View
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 have any relevant requirement for that data. This can be performed using Analytic Privileges in HANA.
Read MoreCount distinct entries in SAP BusinessObjects
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
Read MoreExporting delivery unit based on time filter in SAP HANA
While export a delivery unit, you can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.After selecting Delivery unit from drop down list, you have to select checkbox and then enter the Time interval- From and To date.In below snapshot you can see we have highlighted “Filter by Time” option and user can select this checkbox to use time filter during export.
Read MoreManaging cross database container access in SAP HANA
The cross database container access is managed in Global.ini file in Configuration under System Administration.To access global.ini file you need to navigate to Administration tab in HANA Studio → Configuration and there you can find Global.ini file.
Read MoreViewing table definition in SAP HANA
To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.
Read More