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
SAP Webi Articles
Found 14 articles
Handline #Multivalue Error in SAP BO Webi report
This error occurs when your formula returns more than one value and Webi report doesn’t know how to aggregate those values. This error occurs in below ways:#multivalue in aggregation #multivalue in breaks header or footer #multivalue in section level.Example:Let us say an account number which is associated to more than one order numbers. Your solution will not work and hence you are seeing #MULTIVALUE “Multiple Order Numbers for the same account number”.You can handle this by using an aggregated function as per your requirement like Max(), sum() or avg(). You can also check more details using this link:https://archive.sap.com/discussions/thread/1919325
Read MoreDifferent License types in SAP HANA
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 −
Read MoreChecking information about basic I/O operations on I/O subsystems in SAP HANA
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).
Read MoreUsing 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 MoreGetting error while running SAP oData service “HTTP Open failed: PLUGIN_NOT_ACTIVE”
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.
Read MorePassing multiple parameters in SAP BO Webi report
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 MoreRead a date filter as input in WEBI report in SAP BO
Your requirement is one of its kinds but can be achieved. What you can try out is first create a brand new object in the context. Let's say you provided the date as first input and 5 as a weekly slice in the second input. [Date+5]=DATEADD(@prompt('Slice','X'{'Day','Month','Year'},mono,constrained,persistent),5,@prompt('Date','date',mono,free,persistent))Here X refers to your slice and date refers to the date input.Then you can just add another filter to the report using this.
Read MoreCan 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 MoreCalling SAP Web Service to get data in Flash dashboard
You can also try hosting your Flash application on SAP box. Following approaches can be used:Using Transaction: SICF, you can change the default host’s default service to point to BSP application and then add crossdomain.xml file as MIME.You can also configure ICM to manage this and it sits between the outside world making HTTP, HTTPS, SMTP requests and the SAP System.Method 1:First, you need to create a BSP application -> Create -> MIME Object and import crossdomain.xml file and activate the application. Next is to execute transaction SIC with default settings -> Double click the default_host, go to the Default ...
Read MoreLimit number of rows in Webi report in SAP BusinessObjects
If you using Universe as the source, In UDT this can be defined at Universe level. You can limit the size of result set in Universe Parameters -> ControlsIn Query panel, you have an option to set the limit on rows retrieved for each individual query. This setting is called the Max rows retrieved.This option is linked to each individual query, not with Webi document as a whole. When your document has multiple queries, you need to set the Max rows retrieved for each of them.
Read More