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. The #MULTIVALUE error can appear in several scenarios − #multivalue in aggregation − When a formula returns multiple values without proper aggregation #multivalue in breaks header or footer − When break sections contain non-aggregated multi-value data #multivalue in section level − When section calculations encounter multiple values Understanding the #MULTIVALUE Error The error occurs because WebI cannot determine which value to display when multiple values ...
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. Example Here's how you can create a date filter formula using DATEADD function with prompts − [Date+5]=DATEADD(@prompt('Slice', 'X'{'Day', 'Month', 'Year'}, mono, constrained, persistent), 5, @prompt('Date', 'date', mono, free, persistent)) In this formula: X refers to your slice type (Day, Month, or Year) ...
Read MoreLimit number of rows in Webi report in SAP BusinessObjects
When working with SAP BusinessObjects Web Intelligence (WebI) reports, you may need to limit the number of rows returned to improve performance and manage data volume effectively. There are several methods to control row limits depending on your data source and requirements. Universe-Level Row Limits If you are using a Universe as the data source, you can define row limits at the Universe level using the Universe Design Tool (UDT). Navigate to Universe Parameters → Controls to set the maximum size of the result set. This approach provides centralized ...
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 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 More