Webi is the shorthand name for Web Intelligence, a reporting tool within the SAP BusinessObjects suite.
Questions tagged [webi]
171 questions
0
votes
1 answer
Countifs across BO Webi merge like correlated subquery
I'd like to do a countifs across a merge in BusinessObjects webi. I have two different data sets, which are merged on dimension SID. One data source which would be the source for the outer query, known as "Contacts", has the following columns:
SID…
Joel Underwood
- 35
- 11
0
votes
1 answer
How to pass parameter/prompt & schedule the webi report using SAP BO 4.0 SDK in C#
I am able to schedule a webi report using C#. But can't able to pass prompt/parameter into the report. Please help
public string GetReport(int _reportId)
{
EnterpriseSession ceSession = EntSession;
EnterpriseService…
Mahir
- 23
- 8
0
votes
2 answers
Distribute same WebI Report to different audiences with different filters
I just started using SAP Web Intelligence and I have a couple of reports ready to deploy for end users. The report includes a "Region" field, and I want each user to be able to only see data in their respective "Region".
I know I can make several…
Alex
- 193
- 1
- 2
- 12
0
votes
1 answer
Webi Query panel does not show full list of objects
I am facing an issue whereby Webi doesn't display all the available objects and I can't scroll down in the Result Query Panel as per attached screenshot. Please help on this, thanks!
user2256904
- 9
- 6
0
votes
1 answer
Calculate weekly average of column in Webi
I have a table with 3 columns in SAP Webi as shown in the picture.
In column "weekly average" I want to dynamically calculate the weekly average (from Monday to Sunday) of column "count".
Is it possible to do it with a variable? If not, any…
Toli
- 109
- 1
- 4
- 13
0
votes
1 answer
Sum rows in SAP Webi 4.1 report
I have a report in Webi which is similar to below example (Upper table).
What I want to build is the lower table, i.e. to sum up the values of "A" and "B" and show it in one row.
How to achieve this in BO Webi?
Toli
- 109
- 1
- 4
- 13
0
votes
2 answers
Merge two dimensions in Webi 4.0 report
I have a report query that returns two objects, one is a String and one is a Number, I would like to merge these dimensions but Webi does not allow me to do so and I guess it's because they have different types.
Is is possible to merge them?
salamey
- 3,633
- 10
- 38
- 71
0
votes
2 answers
How to open a Webi report from Design Studio?
We have recently installed Design Studio 1.5 and trying to call existing Webi reports through Design Studio.
Can anyone please let me know the steps involved to attain this?
banu.niz
- 1
- 2
0
votes
2 answers
Dependent filters in Webi report
I've created a webi report which displays a graph of Total revenue per day, Date is on X axis and Rev is on Y axis.
I've a requirement where the client wants to see it category and sub category wise in the same graph. I've used Filter Bar option and…
VJAI
- 111
- 1
- 14
0
votes
1 answer
How to get "Generated By" field in Webi?
In my WebI Report I would like to print the Author or the Last modified User name.
How can I obtain it?
Niki
- 1,161
- 1
- 20
- 37
0
votes
1 answer
If syntax in Webi
I am trying to write a if condition in webi but unable to accomplish.
Below is the code:
if ([Summary Column] inlist("a","b");"a")
Error I am getting
Unrecognized input
Siva
- 9,043
- 12
- 40
- 63
0
votes
1 answer
Cascading prompt in BO Webi without using universe?
Is it possible to create a cascading prompt in Business object webi without using universe? How?
par181
- 401
- 1
- 11
- 29
-1
votes
1 answer
Nested if statements with conditional operators in SAP WebI
I want to check different conditions and based on each condition a specific action should be triggered.
In the following example, I want to check the request type if it is new OR amendment AND Build Date Completion is not null then I need the days…
nina_dev
- 625
- 2
- 10
- 19
-1
votes
1 answer
Select data for a date range
I have a report in Webi report in BO 4.1. Is there a way to run a webi report to select data from a range of dates without prompt? What I mean is: if I want to see sales for past 5 days from today, can I modify a report so that every time I run the…
Aaron
- 29
- 1
- 2
- 10
-1
votes
1 answer
Max group value in Webi report
I have a report in Webi 4.0 with Store name and sales revenue per store. I have created a text box and I want to display the Store name with the highest sales revenue. I can get the max value to appear with:
=Max([Sales revenue]) IN ([Store…
user3552829
- 103
- 1
- 4
- 13