Stack Overflow
Stack Overflow

Questions tagged [bi-publisher]

Business Intelligence Publisher - Oracle's reporting application.

First released in 2003 as part of Oracle's E-Business Suite it has now been integrated into many of the Oracle products and is also available as a standalone application. It is capable of generating XML data from SQL queries, XML files, web services, LDAP, MDX queries, Excel files and Oracle ADF View objects.

532 questions
2
votes
3 answers

SUM() different nodes of an XML

I have an XML like below in BI Publisher- 10.95 1.8 7.95 does not repeat. Now as I understand to do a SUM of a node I can use XPath…
Anjan Biswas
  • 7,746
  • 5
  • 47
  • 77
2
votes
3 answers

mandatory parameter in Oracle BI Publisher 10g

Can we define a parameter to be mandatory so that user needs to enter some value for it in Oracle BI Publisher 10g? If yes, how do we do that?
chemicalkt
  • 816
  • 5
  • 16
  • 33
2
votes
1 answer

Debug log for BI Publisher 11g

I am running BI Publisher on Weblogic. I am having issues, probably related to the SQL queries being issued to generate reports. Does anyone know how to turn on debugging so that I can see the SQL that the system is attempting to execute?
Daniel Williams
  • 8,912
  • 15
  • 68
  • 107
2
votes
3 answers

Accessing reports in OBIEE from a Java Program

I am developing an Java application using Netbeans which will fetch reports from the BI server on OBIEE 10G and display it to the client using the Java application. Can anyone suggest me appropriate steps to do this and also how to begin with it.
Faisal Memon
  • 774
  • 3
  • 12
  • 28
1
vote
0 answers

Include Subtotal Column Name On Each Of the Subtotal Rows in BI-Publisher using guided format

I have a simple data where I am making a matrix table and include subtotals for Acct, Div Bu and Dept as shown in the below sample. I am using the guided format to make the report. I want to include each of the Acct, Div Bu and Dept Name for the…
Nikhil Kumar Singh
  • 143
  • 1
  • 11
1
vote
0 answers

Do we need to configure any specific settings in OBIEE to access BI Publisher via SOAP or REST API's?

We are trying to access BI Publisher reports that are created in our OBIEE (Oracle Business Intelligence Enterprise Edition) via SOAP or REST API's. When we try to access a report directly via browser UI (https://xx.xx.xx.xxx:443/xmlpserver) we are…
Vasanth
  • 11
  • 1
1
vote
0 answers

Bottom-aligned paragraph in rtf template

I need to generate a report with a specific block of text at the bottom of one page from .rtf template using Oracle BI Publisher. I've tried many ways of positioning text in Word and other stuff, but OBIP ignores them all, besides, Oracle doesn't…
T1v1
  • 37
  • 7
1
vote
1 answer

Alpha numeric Sorting Issue with BIP-Siebel report - XML Publisher

The report contains a column called 'Site Name' which contains alpha-number values such as '111 street', '4th Cross', 'Road cross', 'North end street' etc. The sorting expected here is in the form: 111 street 412 Cross North end street Road cross I…
Arun Antony
  • 573
  • 4
  • 13
  • 26
1
vote
1 answer

How can I use Footnotes with Oracle BI Publisher

I am putting a footnote in an .rtf template, and before generating a report it seems ok, but when I load an XML sample and preview the document (.pdf or .doc etc.) the footnote content goes right into the body of my report (example is in the…
OutofBound
  • 39
  • 5
1
vote
1 answer

SQL query to get quarter and month/year from date

In a column I have dates - 01-02-2022, 01-03-2022 How can i get this in the below format ABS_DATE Quarter Month 01-02-2022 Q1 2022 02/2022 30-03-2021 Q1 2021 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
1
vote
0 answers

Unable to call OAC(Oracle Analytics Cloud) REST API services using cURL tool in Oracle Business Intelligence Publisher 12.2.1.2.0 server

I was following below document to Access the Oracle Analytics Service(OAC) REST resources. https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfra/UsecURL.html Steps I have done: downloaded and installed cURL s/w set the cURL environment…
Oracle ERP
  • 11
  • 1
1
vote
0 answers

How do I sort over multiple for-each groups in an xls template?

I have an xls template that has multiple for-each groups. I would like to do a sorting over the result of all groups, however, I can't find how to do this. Do you guys have any suggestions? If you require details, please let me know! edit: Here's a…
jorishaak
  • 13
  • 4
1
vote
0 answers

Display columns dynamically in a BI Publisher report based on the parameter value selected

The report has AR balance amount which is bucketed by days (0-30 days,30-60 days, etc) The requirement is to have a parameter for Bucket and the values should be 180+,210+,240+ When 180+ is selected for the parameter, the report should display…
user15188800
  • 11
  • 1
1
vote
1 answer

Oracle BI Publisher Excel Template Creation - Values of a Field All Appear in One Cell

I am having trouble getting to grips with the basics of creating Excel templates for Oracle BI Publisher. I am working in disconnected mode. I can load the sample XML data fine and select fields, but my output will have all values of the named field…
JamesS
  • 35
  • 1
  • 8
1
vote
1 answer

How to combine rows together where only one column is different between rows

I have a query which result in expense claims. Sometimes the receipt attached is attached to the header level rather than the line level so the output is that the rows runs twice per expense line as it cannot map the exact receipt attachment. How do…
J1212
  • 15
  • 3
1
2
3
…
35 36