1,071 questions
0
votes
0
answers
20
views
if sum=0 in columnA then 1 else 0 not working on 1 specific row
I have a simple sum column and a simple if statement in sum 0 tjek that says "if sum antal=0 then 1 else 0"
But on the last row it returns 0 instead of 1.
I have tried to change the number ...
0
votes
0
answers
23
views
is there any possible way to edit a report after it has been sent by Email in BI Launch Pad?
I'm using Webi - BI Launch Pad. Is there any possible way to edit a report after it has been sent by Email in SAP? I'm not talking about resending the report again by Email, I'm talking about editing ...
0
votes
1
answer
31
views
NoSuchMethodError when Crystal Runtime coexists with other BO jars
I'm trying to integrate a crystal runtime call into the same app that also calls and runs reports on our BO enterprise server. There seems to be a version clash between them. Exception below.
Our ...
- 1,291
1
vote
0
answers
23
views
Crystal Runtime fails in localhost, succeeds on server
While most of our enterprise runs our BO reports through the server, we have needs from time to time to run them in java webapps using the BO runtime. The code pattern is we open the document, ...
- 1,291
0
votes
1
answer
19
views
Parsing out XML column to create new dimensions
I have a table with 7 columns:
SELECT
[Policy_ID],
[DateAdded], [DateUpdated],
[PartyRecords],
[AccountNumber],
[UpdatedBy], [UpdatedOn]
FROM
[Policy_Stat]
The PartyRecords ...
- 11
0
votes
0
answers
12
views
What does the number in the OpenDocument path of SAP BusinessObjects REST API represent?
I’m working with the SAP BusinessObjects RESTful Web Service SDK, specifically the OpenDocument service, and I encountered a URL like the following:
http://192.168.1.8:8080/BOE/OpenDocument/1809071819/...
0
votes
1
answer
76
views
Export Report Structure Only in HTML Format Using SAP BusinessObjects RESTful Web Service SDK
I am working with SAP BusinessObjects RESTful Web Service SDK, and my goal is to export a report without the associated data. I would like to extract only the structure of the report in HTML format, ...
0
votes
0
answers
9
views
When i start Web Intelligence in Business Objects 4.x, the returned panel is blank
I am using the Business Objects BI Launch pad and then selecting the Web Intelligence option. It is supposed to start a dialog that will allow me to select a Universe for reporting, but the panel ...
0
votes
0
answers
32
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
24
views
SAP WebI Function Equivalent to Excel COUNTIF
I need to do the equivalent of an excel COUNTIF where I count all the values of a particular column that equal the value of that column in that row.
Value
Count
One
2
One
2
Two
1
I found this similar ...
- 29
0
votes
0
answers
84
views
How do you merge dimension with full outer join in Webi 4.3?
By default, Webi uses an inner join for merged dimensions, which only shows matching records. How do I set the property of the merged dimension to force an outer join in Webi 4.3?
- 3,386
0
votes
0
answers
45
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 following ...
- 853
0
votes
0
answers
36
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([...
- 77
0
votes
1
answer
63
views
I am getting Missing ';' before argument in function 'Between' at position 1 ( Line 9 ).(IES 10062) error again and again in SAP BO
I am working with "SAP BusinessObjects" and have the following Problem.
When writing a formula, I receive the following error:
Missing ';' before argument in function 'Between' at position ...
0
votes
1
answer
29
views
Crystal reports sort group-by in natural order
A crystal report I am maintaining has a group by section by team. For various reasons, including teams not always being numeric in the past, this is a string:
Team 1
Team 2
...
Team 10
Currently ...
- 13