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
SAP Basis Articles
Page 35 of 50
Using SAP BusinessObjects dynamic recipient
In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.Let us understand this with an example, let us say you have 4 specific regions in the report and you want the report to be delivered to individual Regional Manager for their respective region. You can use dynamic recipient option to make it possible.To implement this, you need to create a dynamic recipient report by developing a webi report which contains ...
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 MoreSQL statement to create a Restricted user in SAP HANA
It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER [] [ ] [ ] [ ] [ ] [ ] []In above SQL query, you have to pass following parameters −Specifies a database user in another tenant database as the remote identity of the database user being created.Specifies the user password of the user being created.Defines an external identification mechanism.Defines an external identity that is used to authenticate the user.
Read MoreChecking create time for all users in SAP HANA
This can be found using following SQL command −SELECT * from USERS;
Read MoreUnderstanding a database view in SAP HANA database
Consider the following example −Example Id Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1 Emp1Emp1Pwd 9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd 15/09/20164Employee 4Emp4 Emp4Pwd3/07/20145Employee 5 Emp5 Emp5Pwd 10/09/20126 Employee 6Emp6 Emp6Pwd 1/10/2013 Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.
Read MoreIn SAP system, how can I find details of Change Request with modification?
You can view Transport request that contains detail about your changes by going to T-Code SE37. You have to enter the name of Function Module and click on Utilities → Versions → Version ManagementAlso note that when you don’t put the changes in $TMP package, the system will ask you to provide a Transport Request to save or activate your changes.You can also check the package by navigating to Goto → Object Directory Entry in Transaction code: SE37 as below:
Read MoreHANA Modeling objects and Content folder in SAP HANA Studio
In SAP HANA Studio, Content folder contains all the design time repository objects. In this folder, all objects created in HANA system are managed under packages. To create a new object, you have to first select a Package.In a package you have different HANA Modeling Views- Attribute Views, Analytic Views, Calculation Views and Analytic Privileges. Each of the object type is managed in different folder in a package.
Read MoreDifferent objects inside a package in SAP HANA
Following objects are available in a Package under Content tab in HANA system −Attribute ViewsAnalytic ViewsCalculation ViewsAnalytic PrivilegeStored ProceduresSub-PackagesDecision Tables
Read More