Found 7 Articles for SAP BO

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

Finding CUID in a SAP BO Webi report in Formula Editor

Rahul Sharma
Updated on 30-Jul-2019 22:30:20
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.

Apply sorting on Date in SAP BO Webi report

Srinivas Gorla
Updated on 30-Jul-2019 22:30:20
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 More

Handline #Multivalue Error in SAP BO Webi report

Updated on 13-Jun-2020 14:35:13
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: More

Displaying distinct values in a column filtered on other column in SAP BO report

Updated on 10-Dec-2019 09:05:26
There are multiple ways to do this. First is by creating a variable like this:Terms Count =Count([Terms Code]) in ([Sales #])You have to add this variable to your report. It will display 1 for all Sales # 1000 and 2 for all Sales # 1001. You can apply a filter on Count > 1.You can also do this using PREVIOUS() function as below:Previous([Payment Terms Code]; ([Sales #];[Line #]))

Use existing authentication along with SAP BO

Updated on 30-Jul-2019 22:30:20
It is one of the most common extension points in an existing ecosystem. With the latest release of BO, you can use active directory based logins mapped under windows server.

Read a date filter as input in WEBI report in SAP BO

Updated on 14-Feb-2020 08:03:12
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.