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

SAP WEBI - Business Objects Get MIN value when comparing multiple dimensions

How can I get the max or min between 2 different dimensions since there is not an option for multiple values in BOE? My example has 2 dimensions, but I'll need to compare 3. I assume it'll be similar logic for both. Example: Syntax input_type…
W-hit
  • 353
  • 3
  • 14
0
votes
1 answer

Convert Date from Text to Date Time for WebI 4.2

I am trying to calculate the duration between StartTime and CurrentDate. However, the StartTime data comes in Text Form as below. I tried converting it using =ToDate([StartDate];"MMddyyyy") but got #ERROR instead. StartTime data
user17086102
  • 5
  • 2
0
votes
1 answer

How to summarize aging data into age grouping in SAP WebI

Using WebI 4.2, I am trying to summarize aging data for individual unit into Aging Group distribution for Material Number as shown below. I am getting either #MultiValue or weird numbers displayed. I'll need some help on how can I get the desired…
user17086102
  • 5
  • 2
0
votes
1 answer

numbers grouping in sap_bo

I'm having a problem in SAP BO-s that I'm trying to solve for a while now so I'm hoping to find a help here... So, I have a list of orders and a number of items on each... ... and a final result should be numbers grouping of numbers of items shown…
preachypreach
  • 1
  • 1
0
votes
1 answer

WEBI find duplicate rows (with exception of certain columns) and highlight

consider the following table: +------+------+----------+----------------+ | Col1 | Col2 | Col3 | Numeric Column | +------+------+----------+----------------+ | ValA | ABC | Value 3 | 101 | | ValF | DEF | Value 10 | 101…
tutu
  • 673
  • 2
  • 13
  • 31
0
votes
2 answers

Webi Report Formula InList Function

I am having issues trying to figure out the format of the InList function. Nothing I have seen online has helped. Currently I have the below formula working: =If [Cost Center] InList("9012009997"; "9012009998"; "9012009999") Then "8.01" ElseIf [Cost…
Jeffrey Thomas Ebert
  • 11
  • 6
0
votes
1 answer

How to I redefine a dimension?

I think my problem SAP WEBI - MultiValue may be based on the dimension/detail structure I have to work with. Is there a way that this can be "re-engineered" in the SAP WEBI environment, using variables? There are only 4 elements that I'm…
Maxcot
  • 1,513
  • 3
  • 23
  • 51
0
votes
0 answers

SAP BO - Time elapsed between first and last day of month (downtime)

I want to calculate the total downtime of the machines between the first and the last day of the month. My time measure is Stillstandzeit [h] I have identified the: First day of last month: =RelativeDate(LastDayOfMonth( RelativeDate([Last day of…
EkRo
  • 11
  • 2
0
votes
1 answer

Webi - hide a column in a Break when another column value is null

I have a report with several breaks on different columns: I would like to do a break on the column REPORT LEVEL 2 only for C, F and G because a REPORT LEVEL 3 is defined for these REPORT LEVEL 2 entities in order do the Sum. I do this break: It's…
coeurdange57
  • 715
  • 1
  • 8
  • 29
0
votes
1 answer

SAP Webi document to Excel, other values have no decimal place

I am working with SAP BOBI 4.1. My issue is when I export a Webi document to Excel, other values have no decimal place.Please advise regarding this. Thank you. Formula used: ToNumber(FormatNumber([obj];"#.0000") Output in the program: 1 Expected…
tim
  • 13
  • 5
0
votes
1 answer

Cell is formatted as text or preceded by an apostrophe, Excel file generated in SAP Webi

I am working with SAP BOBI 4.1. My issue is when I export a Webi document to Excel, number fields are formatted as text or preceded by an apostrophe, and dates are represented with only 2 digits for the year. Formula in SAP…
tim
  • 13
  • 5
0
votes
1 answer

Calculate grand total when table is filtered

I have a Web Intelligence cross tab report where I show time as columns, customer names as the rows and volume as the measure. I have applied a ranking to show only the top X along with a (sub-)total, however I want to add a row at the bottom to…
Diem
  • 58
  • 4
0
votes
1 answer

SAP BO 4.2 SP07 inList clause in webi

Can i use another column in InList clause? Example, i have created a variable and below is the formula. IF [query1.column1] inList ([query2.column2]) then SUM([query1.amountColumn]) Else 0 OR is it possible to put variable after inList in…
Parixitsinh Chauhan
  • 1
  • 1
0
votes
1 answer

How to display data in webi cross table?

I have the below data F1 F2 F3 1 V1 11 2 V1 21 2 V2 22 3 V1 31 3 V3 33 4 V2 42 4 V3 43 5 V1 51 5 V2 52 5 V3 53 And I would like to display it as below: V1 V2 V3 1 11 2 21 22 3 31 33 4 …
Test
  • 41
  • 4
0
votes
1 answer

Extract numbers from string Webi BO

I'm almost new to Webi BO. I need to extract numbers from string. The string looks like below: x Y Z where x is variable length text, Y is the required number to be extracted (also may vary in length 0, or 00 or 000 or 0.00, 00.00, or 000.0, ... and…
user72343
  • 53
  • 1
  • 7
1 2 3
…
11 12