Found 18 Articles for SAP Webi

Data Compression in SAP HANA system

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:21
SAP HANA system combines OLAP and OLTP processing into a single in-memory database and it removes the disk bottlenecks and offering groundbreaking performance. This ACID-compliant, in-memory columnar database stores provides data compression up to 11 times as compared to other conventional database, parallel processing across multiprocessor cores, and supports single instruction multiple data (SIMD) commands.

Different options in Data Preview in SAP HANA

John SAP
Updated on 18-Jun-2020 09:25:59
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 distinct values and “Raw data” to check all raw data available in HANA view.

Different License types in SAP HANA

Updated on 12-Mar-2020 11:13:31
HANA Support two types of license −Temporary License KeyPermanent License KeyTo check your system license, you have to select HANA system in Studio → right click → PropertiesThis will open Properties of your HANA system. Navigate to License option and there you can check license type in use −

Checking information about basic I/O operations on I/O subsystems in SAP HANA

Updated on 12-Mar-2020 10:31:31
You can make use of M_VOLUME_IO_TOTAL_STATISTICS System View which shows information about basic I/O operations on I/O subsystems (paths).

Different perspectives in SAP HANA Studio

Updated on 06-Mar-2020 05:35:21
SAP HANA studio is an Eclipse-based tool and provides a central development environment and an administration tool for HANA database. These are the features of HANA Studio client −HANA Studio is a client tool, which can be used to access local or remote HANA system. You can use HANA Studio for performing HANA Administration, HANA Information Modeling and Data Provisioning.You can use SAP HANA Studio on Microsoft Windows 32 and 64-bit versions of Windows XP, Windows Vista, Windows 7 platforms.SAP HANA Studio provides perspectives to work on the following HANA features. You can choose Perspective in HANA Studio from the following ... Read More

Migrating to SAP HANA system

SAP Developer
Updated on 06-Mar-2020 05:31:54
SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. Following are key features of SAP HANA −SAP HANA is a combination of software and hardware innovation to process a huge amount of real-time data. Based on multi-core architecture in the distributed system environment. Based on column type of data-storage in the database and hence facilitates data compression, and on the fly aggregation.Storing Data in Columnar based table has following benefits −Data CompressionFaster read and write access to tables as compared to conventional Row based storageFlexibility & parallel processingPerform Aggregations and Calculations at ... Read More

Using SAP BusinessObjects dynamic recipient

Anil SAP Gupta
Updated on 06-Mar-2020 05:28:32
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 More

Getting error while running SAP oData service “HTTP Open failed: PLUGIN_NOT_ACTIVE”

Updated on 06-Mar-2020 05:21:52
To fix this, you need to run T-Code: SMICM and this will open ICM Monitor Service Display. You need to maintain port number 80000 for HTTP in SMICM.

Can I export CSV by using REST API in SAP Business Objects?

Anil SAP Gupta
Updated on 13-Dec-2019 06:17:44
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 More

Passing multiple parameters in SAP BO Webi report

Johar Ali
Updated on 26-Feb-2020 06:11:12
An open document URL is constructed as follow −http://:/OpenDocument/opendoc/?&&...&With use of SAP Business Objects API, you can query each prompt- single value or multiple value. When you build URL, you may have to include parameter types.You can join parameters with the ampersand (&) and you shouldn’t use space with & ampersand. Example − sType=wid&sDocName=Sales2003https://URL_path/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sType=wid&sRefresh=Y&iDocID=AUcrjvCCPOVHtSvXJV9Qs0k&lsMYBO_BU=B;B&lsSYBO_CALYEAR=201710&lsSYBO_CRNCY=USDIn this URL, you can see single value variable YBO_CALYEAR and value is passed in YYYYMM format&lsSYBO_CRNCY=USD, you can see single value variable and I am passing value “USD”When you run the report, you can define a report level variable or use report-level function to capture multiple ... Read More