I am using SAP Web Intelligence to pull data. This problem is harder than it looks. For context I want to link two queries (Query1 and Query 2) at the design level (not the report level) on a given ...

We’re seeing HTTP Status 500 - Internal error: setAttribute: Session […] has already been invalidated (Error: INF ) exactly after 60 minutes of WebI report execution. As a test, we increased ...

I have a report in SAP that contains customer purchase data by dates and products. My raw data looks like this: Then, I add an extra variable to this report called "Filters". The reason I ...

I am trying to generate an SQL query where i can have a pipe operator between two objects in the WHERE clause as follows: Table__56.STAFF_DESIGNATION ||' '|| Table__56.JOB_TYPE NOT IN( SELECT ...

I have a simple sum column and a simple if statement in sum 0 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 ...

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 ...

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 ...

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, ...

I have a table with 7 columns: SELECT [Policy_ID], [DateAdded], [DateUpdated], [PartyRecords], [AccountNumber], [UpdatedBy], [UpdatedOn] FROM [Policy_Stat] The PartyRecords ...

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/...

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, ...

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 ...

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([...

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 ...

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 ...