All Questions
Tagged with webi business-objects
125 questions
0
votes
0
answers
25
views
SAP BusinessObjects BI Platform 4.3 formula to calculate the total number of re-admission patients within 14 days
I want an SAP Webi Universe formula to calculate the total number of re-admission patients with the same diagnosis within 14 days of discharge.
Note: I don't have specific diagnosis. I have Admit Date ...
- 1
0
votes
0
answers
19
views
Create a variable to bring multiple values from another table
I am trying to create a webi report from a universe
I have creates two queries.
The data in query 1 has the following data
ID
Name
1
Tom
2
Brad
3
George
4
Adam
The data in query 2 has the ...
- 853
0
votes
0
answers
25
views
Webi formula for extracting date from text field
I have got the following web intelligence formula (Business Objects) which works for most of my data to extract a date from a text field;
=If(Pos([Note]; “R”) > 0 And Length(Substr([Note]; Pos([...
- 75
0
votes
0
answers
23
views
Webi: Creating a calculated dimension?
I have a report with OrderIDs and related boolean dimensions for each order. I want to create a calculated dimension counting the boolean results for each dimension/object. Is this even possible in ...
- 1
0
votes
0
answers
26
views
SAP BO WEBI link two queries
I am relatively new to SAP BO and need support with the following requirement:
I have 2 queries:
The first query contains data with participant names for events. An event has many participants.
The ...
- 1
0
votes
0
answers
105
views
How do you construct count measures in a cross-table in Webi Business Objects?
I'm trying to create a series of tables based on various people data, so how many staff work in Team A, Team B and so on (team info at row level) and then split further by types of worker in ...
0
votes
1
answer
343
views
how to create in webi a text input control based on partial text or number for filtering a BO Report
I'm creating an input control in my webi report.
I would like to filter a specific column based on the text filled in the input control. This search shoul be partial and could contain number or chars.
...
- 743
0
votes
1
answer
24
views
Flag by Sales and Date
I'm having a problem with a flag on Webi, I have a universe with stores, product sold and date of sale, another one with store and date in which an specific enhancement was received on the store for ...
0
votes
0
answers
260
views
Previous Month and Current Month
I'm new in the WEBI report in SAP BusinessObjects and I need to create a variable in the Month(Int) and Year(int) that the output of the report shows the current month and previous month.
For example ...
- 1
0
votes
0
answers
62
views
How to use feature toggles in SAP Webi
As of 4.3 SP4 feature toggles can be defined in the CMC. I am not familiar with these toggles and documentation is scares.
Where can I find the available feature toggles and how do I use those in a ...
0
votes
0
answers
250
views
How to sum without the numbers from duplicate rows?
I have this set of table on my report:
Order Id
Denomination
Unit Amount
code
04214214421412
100
80000
1
04214214421412
50
50000
2
0215424214214214
100
90000
1
21421421421
50
6000
1
21421421421
...
- 1
0
votes
1
answer
67
views
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 ...
0
votes
1
answer
407
views
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 ...
- 83
0
votes
1
answer
193
views
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' (...
0
votes
1
answer
174
views
Webi 4.1 BO variable not aggregating
I have created a measure variable:
= If IsNull([OBJECT 1]) And IsNull([OBJECT 2]) Then 0 ElseIf
Not(IsNull([OBJECT 2])) Then
DaysBetween([DATE 1];[DATE 2])
Else
DaysBetween([DATE 1];[DATE 3])
...
- 1
0
votes
1
answer
558
views
WEBI: Trying to get a value based off of 2 other values being true
I have a formula that shows when an account has purchased an item :
placement=Sum(If(([Sale Qty]+0>0 And ([Sale Items Qty]+0>=1));1)ForEach([Customer Nbr]))
The issue I am having is that I need ...
2
votes
1
answer
50
views
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 ...
- 66
0
votes
1
answer
910
views
How do I get two rows of data when merging queries and the second contains multiple lines
I'm just started working with Webi (4.3) using the universe. I've created two queries using the drag and drop interface and filters and got it to display most of the data I am interested in by merging ...
- 853
0
votes
1
answer
240
views
Return only first of the month from column webi business objects
I have a column as below, what can I do to only return only the rows that are the beginning of the month when the query is called. In the case of the image shown it would return 01/04/2017. I dont ...
- 55
0
votes
0
answers
46
views
Web Intelligence - Countifs
I am trying to use an excel like 'Countifs' function in Business Objects, but it always outputs 1 which is incorrect. How do I replicate this to Business Objects?
=IF(COUNTIFS('TabOne'!A:A,[@[Account ...
- 31
0
votes
1
answer
740
views
SAP webi 4.3 get first and last date of a selected month & year
I have a report that’s connected to oracle database. This report takes 2 prompts
Month (in number)
Year
Is there a way that I can get the first date and last date of the selected month & year ?
...
- 11
0
votes
1
answer
451
views
How to export Structure from WeBI report
I want to get the technical name of the fields that are used in the WeBI report. Is there a way to export the structure of my report to retrieve the details.
Thanks
Niki
- 1,181
0
votes
2
answers
1k
views
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?
1
vote
1
answer
1k
views
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 ...
- 317
0
votes
1
answer
41
views
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 ...
- 19
-2
votes
1
answer
423
views
create folder and pubish sap webi report
i am new to this and this is my requirement.
i need to create a folder for my team and have reports available there instead of sharing them to my inbox.
we do have a BO admin team, so where should ...
- 19
0
votes
2
answers
956
views
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,...
- 33
0
votes
2
answers
926
views
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 ...
- 55
0
votes
1
answer
367
views
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
- 55
0
votes
0
answers
124
views
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 ...
- 55
0
votes
1
answer
584
views
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 ...
- 55
1
vote
1
answer
964
views
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 ...
- 43
1
vote
1
answer
935
views
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 &...
- 743
0
votes
0
answers
1k
views
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 ...
- 361
0
votes
1
answer
770
views
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 ...
0
votes
1
answer
2k
views
WEBI find duplicate rows (with exception of certain columns) and highlight
consider the following table:
+------+------+----------+----------------+
| Col1 | Col2 | Col3 | Numeric Column |
+------+------+----------+----------------+
| ValA | ABC | Value 3 | ...
- 695
0
votes
0
answers
823
views
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: =...
- 11
0
votes
1
answer
1k
views
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, ...
- 58
0
votes
1
answer
2k
views
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 ...
0
votes
1
answer
2k
views
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 ...
- 63
1
vote
1
answer
870
views
SAP Web Intelligence translation of formulas
How can I translate SAP Web Intelligence (WebI) formulas between English and another language?
For example, on the Italian version of WebI I have to write Somma([Profit]), instead of Sum([Profit]). Is ...
- 2,714
0
votes
1
answer
864
views
Getting destination of scheduled WEBI report using Rest API?
The thing I want to accomplish is to run a report instance from the SAP BO portal with the same parameters (Document type, destination, etc) as given during scheduling the report. This can be done on ...
1
vote
1
answer
1k
views
How can a SAP BO publication fail when it formerly worked fine, while the publication didn't change?
I have a WebI report that I sent via a scheduled publication, this is done for months already, and it used to work fine until last week.
Some of my dynamic recipients get only half the information, ...
0
votes
1
answer
1k
views
Business Object WEBI report splitting into multiple pages (not tabs)
I'm trying to create a WEBI report. The specs are a little tricky to figure out, hopefully one of ya'll help me get this resolved.
I have data that looks similar to this:
Name Port ...
- 896
0
votes
1
answer
160
views
Sorting of numbers gives a random order in cross table
I am having an issue with a cross table that I would like to sort. On the vertical axis I have some categories, and on the horizontal axis I have time. The table itself is filled with the value that ...
0
votes
1
answer
671
views
Match on 2 values?
I have person data
Employee ID || Length of Service || Age
and a Payment table
Length of Service || Age || Paid weeks
I want to return Paid weeks for each of the person data. How would i go about this?...
- 17
0
votes
0
answers
26
views
Blank cells in table are locked and I dont know why
Does anyone know why these cells have suddenly become un-clickable/locked?
Screenshot
- 17
1
vote
1
answer
2k
views
Value based on multiple MERGED DIMENSIONS
The VLOOKUP equivalent within business objects is to use a merged dimension then create a detail object using the merged dimension. Which works fine.
However, what if you want the value to be returned ...
- 17
0
votes
1
answer
1k
views
[DataDirect][ODBC lib] error when refreshing WEBI report
I am using the Web Intelligence Rich Client 4.2 SP3 Patch 3, I created a report and save it on WEBI. After I open the report in WEBI, when I click Refresh, it gives me the following error:
The ...
- 81
0
votes
2
answers
680
views
Get CUIDs of all the reports
How can I capture CUIDs of all reports available in CMC (Central management Console) or WEBI tool and paste it in Excel?
Manually I can check by viewing each report properties but if I want all the ...
- 13