Questions tagged [webi]

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

171 questions
1
vote
1 answer

How to access web page source code including CSS and JavaScript like chrome inspect element option does?

I'm trying to automate few simple clicks on SAP WebI Reports. My intention is very simple: I'll go to http://dbie.rbi.org.in/DBIE/dbie.rbi?site=home and wait for page to be loaded. [This is required for logging in as a guest to DBIE(Database On…
Indranil Gayen
  • 702
  • 1
  • 4
  • 17
1
vote
1 answer

Return SQL query BOXI R3 Webi using Rebean API

Has anyone figured out how to return the SQL for an object that is in Webi using the Rebean API? I have got the ReportExpression of the column but, from there I am having a difficult time retrieving the SQL of the object. Thanks
XanderLynn
  • 883
  • 3
  • 16
  • 29
1
vote
2 answers

Define number format in Webi Report 4.1

Is there any option to define a format for the number in Webi Reports? Thanks Niki
Niki
  • 1,161
  • 1
  • 20
  • 37
1
vote
1 answer

How to sort prompt values in a Webi report?

I have prompt for Fiscal Month in my Webi Report. I want to custom sort it so that the month starts with April, May, June , etc. How is this possible? Thanks Niki
Niki
  • 1,161
  • 1
  • 20
  • 37
1
vote
1 answer

Conditional display of rows in Webi report

I've created a WebI report to display all Transactions Done for a day for a certain product. The report works fine, but I've a new requirement wherein the report needs to display No Records Available message in case no records match the query and…
VJAI
  • 111
  • 1
  • 14
1
vote
0 answers

Data output syntax in Webi XI3.1

I am trying to duplicate a detail object from Desktop to its Webi equivalent. I am familiar with the syntax differences, i.e. using semicolons instead of commas and using [] rather than <> to enclose references to other dimensions/measures/detail…
Amanda A
  • 23
  • 5
1
vote
1 answer

Schedule weekly Webi report using SDK

I am trying to schedule a Webi report using SDK, I can schedule Once, Monthly and other types. Could anyone tell me how to schedule a Webi report weekly? I can set the schedule type to WEEKLY and start and end date, but there is no API available for…
user1544460
  • 173
  • 7
  • 18
1
vote
1 answer

Giving only-Webi permissions to user

I wanna restrict user right only to webi, when viewing report in a Webi he will just play with the sliders and export that report as an Excel file locally. But he shouldn't be able to save the file in any way just view it. Thanks and regards, gaurav
Oracle rookie
  • 95
  • 1
  • 2
  • 10
1
vote
1 answer

Date as an input parameter to Webi report

I am trying to create a WebI report with just a single input date, from a prompt, and then get n time slices, weeks or months, after it(max of 12). For example param_input = 1/1/12 and also there is an input of 'n'. I thought I would try a query…
Jared
  • 1,154
  • 2
  • 17
  • 32
0
votes
1 answer

How to handle two parallel fn / procedure calls which rely on the same temporary table

I have a Business Objects Excel report which has 2 worksheets each with multiple columns. For each worksheet BO will do a SELECT from a different pipelined table function in Oracle DB (and each of these functions will call a Stored Procedure.) The…
0
votes
1 answer

Aggregating in SAP Business Objects Webi

I think the issue is fairly simple but I can't manage to get to the result. I would like to aggregate the result for each store, but keeping in the report all the rows, including the Client and Purchase…
DatAlessia
  • 73
  • 1
  • 1
  • 7
0
votes
0 answers

Count repeated values of a dimension without having it in the table

I need to count the number of people who repeat an option, but without having the "Name" dimension in the table that I am going to display, only the "Option" dimension and an added counter for each option, this is an example of the starting data: I…
Cris_91
  • 39
  • 5
0
votes
1 answer

BusinessObjects - export cells as 'general'

I created a variable in BusinessObjects that's just an Excel formula. That's all fine, but when I export my report to Excel, it formats the cells as 'Text' but I want it to format them as 'General' (and ideally automatically apply my formula). Any…
0
votes
0 answers

Convert Excel Table Layout to WEBI Table

I've been provided with a large complex table in excel and need to add two additional columns to the end in WEBI. For the purpose of automation I've been tasked to re-create the table in WEBI before adding on the calculated fields from the data…
Nixxus
  • 99
  • 1
  • 1
  • 7
0
votes
1 answer

Webi schedule export csv to outlook

I am new to business objects. I created a report in Webi and then created a daily job to send the report as a csv data file attachment to my outlook inbox. My question is... Will Webi automatically refresh with latest data before it send each day?
Cookie
  • 53
  • 8