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
0 answers

Webi: On opening, filter data by current user name which can be in or not in a given list (no prompt)

(SAP BusinessObjects BI Platform 4.3 Support Pack 1 Patch 11 Version : 14.3.1.4142.11) Disclosure: I'm not born english speaking, but if I have understood correctly, we should now use "they", instead of he/she, etc. That is what I did here. Just to…
selsay
  • 3
  • 4
0
votes
2 answers

Webi Business Objects formula for last day of current year

How do I write a formula for the last day of the current year (i.e. 12/31/2022) in Web Intelligence Business Objects?
Kaleb Simmons
  • 1
  • 1
0
votes
1 answer

Report parameter showing in two reports

I have two reports in one doc, the source is relational SQL. I am using the prompt for the first report, but for the second one, I am not using it. When I run the second report, it still asks for the prompt, although the query is different in both…
coool_sweet
  • 21
  • 5
0
votes
1 answer

Prompt date in report with default today's date?

I am using relation SQL as a source for my query as below select * from table where date = ? what I need is when the user runs the report, it should prompt to date parameter. the default date should be the current date and there should be a…
coool_sweet
  • 21
  • 5
0
votes
1 answer

Fetch min value excluding zero in column in SAP BO WEBI?

I have a column in SAP BO WEBI. For example, I have the following values in my column. MONTH 0 0 2 4 3 When I try the Min() function in WEBI like this Min([MONTH]), it returns 0 for me. But I want the value 2 to come. So I want…
Ygz Nb
  • 1
  • 1
0
votes
1 answer

Webi: How to let user scale numbers in a table (thousands, millions, ...) (not in charts)

(SAP BusinessObjects BI Platform 4.3 Support Pack 1 Patch 11 Version : 14.3.1.4142.11) Hello everyone, Let's say I have this table with On the left, an identifier representing a product On the right, the amount of money gained from selling this…
selsay
  • 3
  • 4
0
votes
1 answer

Duplicate query in webi

How to duplicate a query in webi, in query panel if the query is not duplicated then what is the reason and how to resolve this issue suggestions please Thanks in advance Shoaib
shoaib ahamad
  • 1
0
votes
1 answer

HyperLink in Webi Report not responding

We can't click or right click the link on the WebI report that usually downloads an Excel sheet, However we can click it when we export the report to PDF format or opening through an Internet Explorer, however Chrome and Edge is not recognizing the…
Ajil T.P
  • 33
  • 2
0
votes
2 answers

Data exists within database but doesnt show up on webi report

Hi I am building a v simple report as below; when I include the customer reference number and filter for another column (resolved time) being NULL then the number of incidents are reduced. (I know they exist within the database with the same…
shazma
  • 55
  • 6
0
votes
1 answer

Datedim function not returning yesterdays date webi

My Datedim function is not returning yesterdays date in webi, any ideas on how to show 13/04/2022, even if it has null values? Thanks
shazma
  • 55
  • 6
0
votes
0 answers

Why is my output report showing errors although it shows up normally when refreshing data in webi?

Why is my output report showing errors although it shows up normally when refreshing data in webi? My excel file output is the first screenshot, the report view in webi is the second. I am able to export the data and the output is fine, when I run…
shazma
  • 55
  • 6
0
votes
1 answer

SAP - Web intelligence Cell Reference

I have created 7 cell references in WEBI with the purpose of averaging seven cells (for a week), the referenced cells contains a percentage value eg 99.25%. However, when I calculate an average on the referenced cell I always return a 1, so it seems…
shazma
  • 55
  • 6
0
votes
0 answers

Error in Webi when the language parameters change

enter image description hereI got this error message whenever I switch the report langage from french to english in WEBI. enter image description here Can you please help me solve this problem ? thank you in advance.
DevSAPBO
  • 1
  • 1
0
votes
1 answer

Webi: How to use double slider input control with dates?

My boss asked me to add a double slider input control for the date information on a report on Webi. We have several columns and two of them display a date (start and end date of procedure). So I need to have two double slider, one for each…
selsay
  • 3
  • 4
0
votes
1 answer

Rows Are Duplicated in WEBI Report

WEBI Report is created with a structure, so I cannot modify the cells one by one but I need that. I use [Things] where ([Things]="Thing") etc. in cells. However it looks like this, the rows are duplicated for a reason: but i want this: any help is…
opia
  • 65
  • 1
  • 7
1 2 3
…
11 12