Found 18 Articles for SAP Webi

Using activity in SAP for number range intervals and number range objects

karthikeya Boyini
Updated on 30-Jul-2019 22:30:22

71 Views

As the name indicates, activity 02 is for intervals while activity 17 is for objects. There can be a different number range interval for a given SAP number range interval.

Error Message: Unsupported xstream found: (“HTTP Code 200:OK”)” while consuming SAP Web Service

Amit Sharma
Updated on 30-Jul-2019 22:30:20

625 Views

I think this is related to incorrect HTTP destination configuration. You can check Web Service using T-Code: SOAMANAGER to verify if HTTP destination is configured properly.

Finding CUID in a SAP BO Webi report in Formula Editor

Rahul Sharma
Updated on 30-Jul-2019 22:30:20

442 Views

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

457 Views

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

Calling SAP Web Service to get data in Flash dashboard

Abhinaya
Updated on 10-Dec-2019 10:23:22

76 Views

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

Handline #Multivalue Error in SAP BO Webi report

varun
Updated on 13-Jun-2020 14:35:13

2K+ Views

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/1919325Read More

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

Prabhas
Updated on 14-Feb-2020 08:03:12

326 Views

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.

Limit number of rows in Webi report in SAP BusinessObjects

Ayyan
Updated on 05-Dec-2019 10:37:03

1K+ Views

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.

Advertisements