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
3
votes
1 answer

Download Webi report from Excel

With newly released Webi there's no way to manipulate reports with VBA like it was in DESKI era. I'd like to know if there's a way for me to click a button with parameters in Excel sheet and get a report from the server? I've been thinking of using…
Sebastien FERRAND
  • 2,110
  • 2
  • 30
  • 62
3
votes
1 answer

How to read union and combined Webi reports with Java BO SDK?

I need to read Webi reports metadata information which has tables and columns. I can able to read few Webi reports metadata info, but for combined and union Webi reports I am not able to read any metadata data information, I am getting query null…
Navyah
  • 1,660
  • 10
  • 33
  • 58
2
votes
1 answer

How to count value with changing margin in WEBI?

​Hi Guys, it sounds easy but it doesn't... Customer got several invoices in specific periods (months). We want to calculate the final amount (total+margin). The problem is that margin is changing during the periods. ​I want to get 7142,76 in one…
bekart
  • 66
  • 3
2
votes
1 answer

Report shows date instead of datetime on Webi export?

I am using Web Intelligence for reporting however, the SQL script i use runs fine within Oracle where it displays the date and time of a column. But when i run this report through web intelligence and then export, it only displays the date. I am…
ConfusedJJ
  • 15
  • 2
2
votes
1 answer

Accurately calculating business hours between two time stamps in Web Intelligence

I am trying to calculate the number of working / business hours between two timestamps at the report level in Web Intelligence. So far, I have been able to calculate the total number of hours between the two dates, the total # of business days…
BI Dito
  • 21
  • 1
  • 4
2
votes
1 answer

Export original value to Excel keeping format only in Webi

I am creating a report in Business Objects Web Intelligence, and there is a requirement to format a number in millions. For example, $4,879,987.23 would be formatted as $4.9M. I tried both a custom number format and a conditional format, and I can…
RVD5Star
  • 47
  • 6
2
votes
2 answers

How does one handle exceptions in date casting in SAP's HANA?

QUESTION SUMMARY: What is the proper way within HANA SQL or HANA Studio in a view (Calculation, attribute or Analytic) to handle invalid data when attempting to cast to a date so a user can filter the data? In SAP's table KONM the field KSTBM is a…
xQbert
  • 34,733
  • 2
  • 41
  • 62
2
votes
1 answer

Webi Rich Client Null pointer exception error

I'm trying to create a new Webi document based on a duplicate old one that we have been migrated from BOXI 3.1. I make my changes (filters, expressions) without any problem. When I save it (in different folders) and try to reopen it, I get the…
Adraa06
  • 25
  • 3
2
votes
3 answers

Concatenate multiple rows data in single cell in a WEBI report

Need advice for a webi report in BO 4.1 Sorry about the alignment. I have a report as follow: Country Agent Customer Products UK Mo Sara Bag UK Adam Jill Bag UK Tim Kim Shoes UK Tim Kim Bag US John Sam Belt US John Sam Bag The…
Aaron
  • 29
  • 1
  • 2
  • 10
1
vote
1 answer

Exporting Webi to Excel throws java.lang.NoClassFoundException :com.crystaldecisions.celib.trace.h

I have to export the Webi report in the excel format and show it to the user .Environment present is BOXI R3 . ReportQuery: Select * from CI_INFOOBJECTS where SI_NAME ='xxxx' and si_kind ='Webi' and SI_PARENTID=xxxx IInfoObjects webiDocs =…
user403386
  • 43
  • 1
  • 5
1
vote
1 answer

Connecting SAP BO to Snowflake to import data

I have a requirement to import data to Snowflake from SAP BO (WEBI) system. I know the other way round can be done that is getting Snowflake data to SAP BO. But how do I connect the SAP BO system to Snowflake to get data into Snowflake. Thank You!
Purva Shankar
  • 31
  • 1
  • 2
1
vote
1 answer

Rows aggregation by string concatenation?

I am working on a SAP Webi 4 report where I have a table that looks like student discipline exam session josé geo june session josé geo september session josé math june session from which I would like to obtain another table that…
mazu
  • 147
  • 6
1
vote
1 answer

WEBi Date Variable

I have a column with various dates and I need to only show data 3 days from current date - I've been able to show the date from 3 days ago but not able to link it to the column date. Any ideas how I can get around this.
Caroline Waterhouse
  • 11
  • 1
1
vote
1 answer

How to create a variable based on two opposing Booleans - business objects web intelligence

I have a cross table in business objects web intelligence which has customer IDs in the rows, items in the columns and quantity in the body. I am trying to create a variable (dimension?) that will flag whether a customer has bought one particular…
splitznook
  • 53
  • 6
1
vote
1 answer

SAP Universe design tool - how to create a dimension with fixed value in each class of a universe

I have several class in my universe containing objects (dimensions, measures) pointing on fields of a database table. For instance the objects of the class "Grant" pointing on the table "Grant_T" and the objects of the class "Procurement" pointing…
coeurdange57
  • 715
  • 1
  • 8
  • 29
1
2 3
…
11 12