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
1
vote
2 answers

Display all dates even if there is no data

I am attempting to display all the dates within a range even if they do not have data for the particular date. Our employees do work 24/7 365 ( like everyone else) so there are dates within my time range that wont pop up. What I have tried is to add…
Nonstoplive
  • 39
  • 1
  • 5
1
vote
1 answer

How to add data from 2 queries into 1 table in webi

I have 2 queries. The first query is from the webi universe which has: Staff ID Arrival Date Leave Date The 2nd query is an Excel data query that has: Staff ID Test Date What I am want to do is to create a single table that has: Staff ID…
Momoosa
  • 31
  • 6
1
vote
3 answers

Javascript Browser zoom object

I am trying write a Javascript function which runs on a button click event in SAP WEBI, which makes the browser zoom to 80%. I am trying to use this code which works in case of a standard website (it does not use browser zoom but actually zooms in…
András Czeitner
  • 61
  • 6
1
vote
3 answers

Issue writing a query in sql and implementing it in Webi report

I am trying to execute a query in sql to get only the records of agents associated with multiple descriptions Example: Table name: AGENT AGENCY_ID PRODUCT_DESC AGENT number 100 ABC 2000 101 ABC 2001 101 …
Vindhya Giri
  • 15
  • 3
1
vote
1 answer

Sap Webi Count Function

I have a problem in count function. I have an online table which is auto generated from Database. I want to create a summary according to data in that table. I need a count of a value which are same in some columns. As example given below. This is…
Abuzar Shaheen
  • 43
  • 2
  • 8
1
vote
1 answer

Make NOT EXISTS clause in Webi

I have an Oracle query that I need to rewrite in WebI. I cannot figure out how to mimic the NOT EXISTS from Oracle. My query returns an object if it has a transaction date within a given time frame, but not if it has anything prior to that time…
user8168630
  • 11
  • 4
1
vote
0 answers

Passing parameters using SQL to Webi report

I am using Webi to create reports but instead of using universes I would like to use custom SQL queries since I already have stored procedures created. In the stored procedures I have parameters like @date and @id. Is there a way to use them in Webi…
michaelg
  • 243
  • 2
  • 8
  • 25
1
vote
0 answers

Pull another query in Webi

I am facing issue when using Result from another query in WebI. Version: 4.1 SP6 I need to use subquery which is not dependent on the outer query. When I use filter from the universe it was taking more time to execute. So, I created a dimension in…
H123
  • 11
  • 2
1
vote
2 answers

Webi Rich Client refresh is very slow contrary to Webi and SQL

I have a single Universe query that has 4-5 filters that takes almost 5 minutes to run using the Webi rich client. When I copy the SQL code and run it from SQL management studio (SSMS) it takes 10 seconds. I have created only the data query and…
kevro
  • 263
  • 5
  • 20
1
vote
3 answers

Exclude G/L with UserResponse in Webi report

I am using Business Objects WEBi to build a new report. In a cell I want to show the UserResponse to the G/Ls that have been excluded in a list, but when I use the formula =UserResponse["G/Ls to Exclude:"] I get a blank cell How do I get around…
Honeyloco
  • 11
  • 3
1
vote
1 answer

Sorting behavior incorrect with FormatDate

I am editing a Webi report using SAP BusinessObjects BI4. I have a report with a table in which I display a date formatted like this : =FormatDate([Sales Date];"dd-MMM-yyyy") Originally, Sales Date dimension has the format "mm/dd/yyyy". I want to…
salamey
  • 3,633
  • 10
  • 38
  • 71
1
vote
1 answer

MAX aggregation of rows in Webi

I can't figure out how to show only example results for a field in a WebI table. I have a data set in WebI with agents and agents' companies, among other things. The data set contains multiple companies for some agents, or with slight variations…
ELW
  • 380
  • 2
  • 19
1
vote
0 answers

BI4.1 WebI: #MULTIVALUE in dimension object

I get a #MULTIVALUE for an own variable of type dimension. Common behavior (?): According to my training and everything I have read, the typical behavior of a dimension object should be to display one distinct value per column (in tables with header…
Michael S.
  • 150
  • 1
  • 9
1
vote
1 answer

Can BO dashboard be created from WebI report?

I need to create a dashboard using my webi report. Can this be achievable? If so, how? Thanks in Advance Niki
Niki
  • 1,161
  • 1
  • 20
  • 37
1
vote
2 answers

Aggregating rows in Webi report

Is there a way to combine, sum and rename rows in a report using Business objects Webi without going to the universe? I'm really new to Webi reports. Consider…
Ramatu Victorious Kuyateh
  • 31
  • 4
1 2
3
…
11 12