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
Articles by Anil SAP Gupta
Page 7 of 10
Can I export CSV by using REST API in SAP Business Objects?
Yes, it is feasible and I have done something similar in one of my previous projects. But you need to be little clear on what you need to export. There are two options regarding the content of export:Raw Data ( it is basically the query)Formatted Data ( it is your report)I will provide you help for both. In case, if you are looking for just exporting the raw data then you can the following call and you should be able to fetch the raw data.http://:6405/biprws/raylight/v1/documents//dataproviders//flows/Also as will require the response in CSV, set the ACCEPT to ‘text/plain’ so that the ...
Read MoreConverting the data back to table using SAP FM RFC_READ_TABLE
This is very simple and you can write a code as below. This code works when you only have characters fields in table:DATA: lt_options TYPE TABLE OF rfc_db_opt, lt_fields TYPE TABLE OF rfc_db_fld, lt_entries TYPE TABLE OF dpr_pha_type. CALL FUNCTION 'RFC_READ_TABLE' DESTINATION 'Y58CLNT800' EXPORTING query_table = 'DPR_PHA_TYPE' TABLES options = lt_options fields = lt_fields data = lt_entries.
Read MoreUsing aggregated in SAP HANA
SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.With the use of column store, data is available vertically and hence operations on different columns can be easily performed.
Read MoreEnabling XS Engine service in SAP HANA Studio
To Configure DXC, you need to enable XS Engine (SAP HANA Extended Application Services). To enable XS Engine Change the Instance value to “1”. XS Engine Service in SAP HANA Studio is used to handle Control Flow Logic.
Read MoreChecking XS Engine service in SAP HANA system
You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.
Read MoreTable mapping while data replication from flat file in SAP HANA database
Table mapping is last step while uploading data using an Import option in HANA Studio. This shows the data that already exist in the table and also shows the information about the schema and table to which we are going to load the data.Click on Finish to load the data.
Read MoreUsing header rows during flat file upload in SAP HANA
This can be done using File import option. While importing first file, you have an option to “Add columns” in new table so you can create addition columns as per column names in other CSV’s. You can also define their datatypes, length, Primary key, not null and other column properties in same window.
Read MoreImporting limited number of rows from CSV in SAP HANA
Yes, this can be done using File Import option in HANA Studio. In Import data from local file wizard, un-check the option- Import all data and you can mention Start Line and End Line value.
Read MoreMoving objects from one package to another package in SAP HANA
In SAP HANA Modeler perspective, you have an option of “Mass Copy” using which you can copy mass objects from package to other package. You have to define source and target package mapping.To add new package mapping, you can use button and select Source and Target package from drop down list. In next window, you have to select models and click on Next.
Read MoreMaintaining vendor ID for Delivery unit in HANA using SAP HANA Studio
You can also maintain Vendor ID in Administration tab in SAP HANA Studio. Select HANA system and click on Administration and go to Configuration tab. In filter, enter Vendor and search:Click on Change and you will get an option to enter new Vendor Id value. Click on Save to save the changes.
Read More