Webi is the shorthand name for Web Intelligence, a reporting tool within the SAP BusinessObjects suite.
Questions tagged [webi]
171 questions
1
vote
0 answers
LISTAGG Partition for Webi
I would like to do something similar to oracle LISTAGG in Webi. Below are my Queries.
Query 1
Id M1 ; columns
1 10
2 20
3 30
4 40
5 50
Query 2
Id D1 ; column
1 A11
1 A12
1 A13
2 …
Test
- 41
- 4
1
vote
1 answer
SAP Web Intelligence translation of formulas
How can I translate SAP Web Intelligence (WebI) formulas between English and another language?
For example, on the Italian version of WebI I have to write Somma([Profit]), instead of Sum([Profit]). Is there a way to find the equivalence between the…
Nicolaesse
- 2,554
- 12
- 46
- 71
1
vote
1 answer
How can a SAP BO publication fail when it formerly worked fine, while the publication didn't change?
I have a WebI report that I sent via a scheduled publication, this is done for months already, and it used to work fine until last week.
Some of my dynamic recipients get only half the information, others dont get information at all. The publication…
Emma van de Vreugde
- 103
- 1
- 10
1
vote
1 answer
How to Generate a Burndown by Month
I have a dataset of action tracking records with due dates. I've been asked to generate a burndown curve, which I can do pretty simply in Excel, but I'm stumped on how to put this in a WebI report.
I created a variable to convert the due date for…
ABrown78
- 29
- 6
1
vote
1 answer
Value based on multiple MERGED DIMENSIONS
The VLOOKUP equivalent within business objects is to use a merged dimension then create a detail object using the merged dimension. Which works fine.
However, what if you want the value to be returned based on multiple merged dimensions? When…
Chris Wright
- 17
- 5
1
vote
0 answers
Retrieve Report details of SAP BO
Using PostMan we can find the data providers, report elements and many more but in this I have to put each Report ID every time to access the report elements, dataset, etc.
Is it possible that without entering report id every time it automatically…
anjune
- 13
- 3
1
vote
3 answers
Download scheduled Webi report from File Repository Server
Having launched a scheduled report in SAP BO, is it possible to somehow download from the file repository server?
I am working with the Web Intelligence RESTful API. While it is possible to export a report synchronously using the GET…
Dani
- 2,602
- 2
- 23
- 27
1
vote
1 answer
Manifold AVG aggregation in Webi 4.2
I am trying to produce a report in SAP BusinessObjects Webi 4.2 that has complex aggregation, however not having much luck.
I have data as follows:
I am trying to create a variable that returns the average count of skills for Colleagues in each…
D10N-CB3
- 43
- 8
1
vote
1 answer
How to fetch tables and columns from SAP BO universe Data Source?
I am able to get folders of a particular universe by using REST API of SAP BO Universe semantic layer.
Now I need to get the main tables from underneath data source of the universe. I've found out that COM SDK of SAP should be used for this, however…
Kranthi.Gogikar
- 31
- 5
1
vote
1 answer
Web Intelligence : RunningSum on interval
I'm working on WebI 4.2 Support Pack 4 Compilation : 14.2.4.2410. I have an array with the number of days to make an action. For example 967 times an action was make in 0 day.
I only want to display lines with 0,1,2,3,7 (one week),14 (two…
Skyshufeu
- 62
- 1
- 10
1
vote
1 answer
Web Intelligence : line chart method
I'm trying to make a line chart on WebI 4.2 Support Pack 4 Compilation : 14.2.4.2410.
I have an array with my number of order for each month.
+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+
| Jan | Feb | Mar | Apr | May…
Skyshufeu
- 62
- 1
- 10
1
vote
1 answer
Filter using sub report in BO SAP Web Intelligence
I need to report on employees who have not been absent during the last year. I can do this easily using the following simplified SQL
SELECT EMPLOYEE_NUMBER
FROM Employee
WHERE Employee.EMPLOYEE_NUMBER NOT IN (
SELECT …
NiMuSi
- 382
- 1
- 4
- 15
1
vote
1 answer
Export Webi reports to Excel as an Excel tables
I have a series of Business Objects (Webi 4.2) reports which are scheduled to be exported to Excel each day.
These reports form the basis of a Power BI dashboard.
Power BI is much happier looking at Excel Tables that it is simply worksheets so I…
MMS
- 23
- 3
1
vote
1 answer
Webi SAP BO Sum in block depending on two dimensions
I am trying to sum every line in a table summarizing it by two fields in Webi.
I have a table with the following columns:
Risk, Year, AssessedBy, Weight, Value.
I have filtered the table by Year = 2018 and Risk = "01". Thus, I only have the info for…
mikizas
- 331
- 5
- 16
1
vote
0 answers
Associated dimension of a detail disappears after reload / save
In BusinessObjects webi, I want to merge two variables, one from the universe, one from an excel file.
Query CC data (universe): Site
Query Site mapping table (excel file): Phenix Mapping Key (Entity Name)
If I merge the two dimensions in the…
rom
- 3,592
- 7
- 41
- 71