Stack Overflow
Stack Overflow

Questions tagged [webi]

Webi is the shorthand name for Web Intelligence, a reporting tool within the SAP BusinessObjects suite.

171 questions
0
votes
1 answer

Getting destination of scheduled WEBI report using Rest API?

The thing I want to accomplish is to run a report instance from the SAP BO portal with the same parameters (Document type, destination, etc) as given during scheduling the report. This can be done on the BI portal in the following way: (Right Click…
anonymousV
  • 1
  • 1
0
votes
1 answer

Finding solution to "Missing ';' or closing parenthesis in function 'If' at position 640. (IES 10063)" in Webi

I am trying to build a dimension in webi to look up someone's 65th birthday to attach the appropriate retirement fund label for our pension company. Replace did not work for more than 2 so I tried to use If. Having built it I am getting error of IES…
D Chandler
  • 1
0
votes
1 answer

Business Object WEBI report splitting into multiple pages (not tabs)

I'm trying to create a WEBI report. The specs are a little tricky to figure out, hopefully one of ya'll help me get this resolved. I have data that looks similar to this: Name Port Amount Apple APL 100 Google GOOG …
Koosh
  • 876
  • 13
  • 26
0
votes
1 answer

Sorting of numbers gives a random order in cross table

I am having an issue with a cross table that I would like to sort. On the vertical axis I have some categories, and on the horizontal axis I have time. The table itself is filled with the value that is related to the previous two. I created a rank,…
Emma van de Vreugde
  • 103
  • 1
  • 10
0
votes
1 answer

Match on 2 values?

I have person data Employee ID || Length of Service || Age and a Payment table Length of Service || Age || Paid weeks I want to return Paid weeks for each of the person data. How would i go about this? Thanks
Chris Wright
  • 17
  • 5
0
votes
0 answers

Blank cells in table are locked and I dont know why

Does anyone know why these cells have suddenly become un-clickable/locked? Screenshot
Chris Wright
  • 17
  • 5
0
votes
1 answer

[DataDirect][ODBC lib] error when refreshing WEBI report

I am using the Web Intelligence Rich Client 4.2 SP3 Patch 3, I created a report and save it on WEBI. After I open the report in WEBI, when I click Refresh, it gives me the following error: The following database error occurred: [DataDirect][ODBC…
user196736
  • 71
  • 7
0
votes
1 answer

Web Intelligence Sum every 5th row

I need to Sum every 5th row I can easily do it in excel but don't know how to create it in BI. I need to sum the Usage for the 6 mo Usage column. Below is the Excel formula as I found out it doesn't like offset.…
Booney440
  • 5
  • 7
0
votes
1 answer

Showing team's performance vs an individual's performance using sap webi

I need to show team's performance vs an individual performance using sap webi linear gauge. The team's performance is a dynamic data which changes over time; each team member should use an input control to select their name, then, they can see the…
nina_dev
  • 625
  • 2
  • 10
  • 19
0
votes
0 answers

How to import data from website into SAP WEBI

Do you guys know what is the best method to import data from any website to put in webi report? I just want to capture the value that displayed in the web, like web scraping/crawl. As example, getting the oil price from…
Shiro Gin
  • 19
  • 1
  • 6
0
votes
2 answers

Get CUIDs of all the reports

How can I capture CUIDs of all reports available in CMC (Central management Console) or WEBI tool and paste it in Excel? Manually I can check by viewing each report properties but if I want all the CUID to be captured through coding, is that…
anjune
  • 13
  • 3
0
votes
1 answer

Web Intelligence : input control calendar and empty var

I know how to create an empty text var in webi depending input control (using ="" formula). I tried to apply this for dates but I can't select calendar control. How can I create an empty date var linked to a calendar input control ? Update : First…
Skyshufeu
  • 62
  • 1
  • 10
0
votes
1 answer

Filter rows above X percent of group in WebI report

We are running BusinessObjects 4.1 SP06 Patch 4. I need to build a Web Intelligence report that will only show the fees categorized by Trans Code Desc that are above 5% of the Fee Schedule to which they belong. I can find the percentage easily…
Isaac
  • 3,240
  • 2
  • 24
  • 31
0
votes
1 answer

Concatenate two numbers in Webi (not adding numbers)

I need to compare the first, middle and last test in each program year. The measurements for doing so involve two variables (1) Level (a text) and (2) score (a number). There are 52 levels, which I have interpreted into a variable which translates…
Queue
  • 1
  • 2
0
votes
1 answer

Check Variable in Universe agains the Excel Data provider value list?

I have two data providers, universe and Excel, and would like to show all records from the universe based on what is provided in Excel. To illustrate, I have a list of name in Excel, only this one dimension, no identifier or related data attached to…
Owennn
  • 85
  • 5
1 2 3
…
11 12