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 BO Articles
Found 7 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 MoreDisplaying distinct values in a column filtered on other column in SAP BO report
There are multiple ways to display distinct values in a column filtered on other columns in SAP BO reports. The two most common approaches are using count variables and the PREVIOUS() function. Method 1: Using Count Variable The first method involves creating a variable that counts distinct occurrences based on a grouping column − Terms Count = Count([Terms Code]) in ([Sales #]) Add this variable to your report structure. The variable will display 1 for all records with Sales # 1000 and 2 for all records with Sales # 1001, effectively counting distinct terms ...
Read MoreUse existing authentication along with SAP BO
It is one of the most common extension points in an existing ecosystem. With the latest release of SAP BusinessObjects (BO), you can use Active Directory based logins mapped under Windows Server. Authentication Integration Options SAP BusinessObjects provides several authentication methods that can integrate with your existing infrastructure − Windows Active Directory (AD) − Seamless integration with domain credentials LDAP Authentication − Connect to existing LDAP directories Single Sign-On (SSO) − Use existing SSO solutions like SAML or Kerberos Database Authentication − Leverage existing ...
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 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 MoreApply sorting on Date in SAP BO Webi report
As you had already mentioned that you are using FormatDate function to format the date, So the sorting is applied to the output of the function which is STRING. So it applies sorting on the string and sorts only the initial alphabets which are a day in your case.You can get your task done in few ways:Easiest option will add another column with the same field and then apply sorting on this and then hide the column. This will sort your data on the date field.Other but better option will be using a custom date format to format the date ...
Read MoreFinding CUID in a SAP BO Webi report in Formula Editor
In Business Object, a CUID is a key to identify Universe or report in the same cluster when you publish an object first time in the repository. CUID is part of metadata stored in repository and data actually exists in the report.I don’t think you can find CUID from a webi report while you are editing in modify mode. This could be possible with the use of SDK.You can find CUID by opening object properties in CMC.
Read More