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
0
votes
1 answer

Oracle OBIEE BI-Publisher, to show count of records with .csv output (not excel or pdf)

Can you please share some inputs or pointers to achieve record count at end for BI-Publisher reports with .csv as output. It works with excel & PDF outputs but not with .csv To achieve it created a Template (.RTF) and want to run BIP report using…
Learn4556
  • 19
  • 1
  • 8
0
votes
1 answer

Oracle BI Publisher chart with multiple series

I am trying to create an Oracle BI Publisher chart with multiple series, but I'm not sure how to structure my xml in order to get the multiple series. My xml is: Self …
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
0
votes
2 answers

P6 reporting Activities Listing from Oracle database

I am new to P6 reporting and I am facing an issue with writing a query to fetch all the activities under the wbs. Consider the following wbs hierachy WBS LEVEL1 WBS LEVEL 2A ACTIVITY1 ACTIVITY2 WBSLEVEL 2B ACTIVITY3 ACTIVITY4 WBS LEVEL2…
Nishant
  • 1
  • 1
0
votes
1 answer

How to put comma separator for 1000 in $ amount in BI Publisher

I have created the report to show the amount in $ using data table in BI Publisher. It shows full amount as $ 265432. But I want to show $ 2,65,432. How to put comma separator in $ amount?
Siva Ponnusamy
  • 1
  • 3
0
votes
1 answer

BI Publisher 11g hide pivot table header

is there a way to hide the bi publisher RTF template pivot table header (in 11g)? Thanks
sacoffers
  • 1
  • 2
0
votes
1 answer

ODBC Connection to Oracle in Datazen BI tool

Does anyone have managed to connect to a Oracle database using a ODBC driver in Datazen BI tool? I just trying to connect to my Oracle test environment from Datazen server to create few dataviews for dashboards. The counfusion is what should I give…
CAD
  • 4,112
  • 6
  • 29
  • 47
0
votes
1 answer

Order by condition in BIP

I have a problem with my ORDER BY condition in data model. I want to pass a parameter to ORDER BY and sort data according to the value of parameter. This is the code: select * from ( select t1.header_id, t1.ebs_trx_number…
Stefan Dramlic
  • 69
  • 1
  • 1
  • 6
0
votes
2 answers

XSL: nested in RTF Template

I'm having trouble getting my RTF template to accept a nested choose in my first cell. I have: …
mark3569957
  • 32
  • 1
  • 2
  • 7
0
votes
1 answer

BI Publisher conditional sorting issue

I am having trouble getting BI Publisher to sort based on my parameter. The parameter name in the data model is SORTBY and has two options (NAME, BIRTH_DATE). The values come from a "list of values" in the data model that match field names in the…
mark3569957
  • 32
  • 1
  • 2
  • 7
0
votes
1 answer

Autofit row height in RTF Template

I am using MS Word 2007 on a Windows 7 system and created a RTF Template for XML Publisher Report. But the output of report (in Excel) has the "row height collaps" issue. Everytime, user has to do manully "Autofit row height". How could I set…
Abhishek
  • 1
  • 1
  • 1
0
votes
1 answer

BI Publisher Excel template Preview Error

Can anyone please guide me about the problem and how to resolve it.I am unable to understand the error which is mentioned below:- java.lang.NumberFormatException: multiple points at sun.misc.FloatingDecimal.readJavaFormatString(Unknown…
Nikhil
  • 151
  • 1
  • 3
  • 20
0
votes
1 answer

How do you call a SQL Server Stored Procedure in BI Publisher 11g?

I am trying to call a Microsoft SQL Server Stored Procedure that delivers data in table like format (rows / columns) in Oracle BI Publisher 11g (11.1.1.7). Selecting procedure call as a data source for the data model does not work because BIP…
Petteri Pertola
  • 281
  • 2
  • 6
  • 23
0
votes
0 answers

Checkbox on PDF template in Firefox

We have pdf templates that get data from a data source and write out a file with data in respective fields. It uses PeopleSoft delivered functionality to perform this action. What is interesting is, we open the PDF file in Chrome, Safari, IE and…
freshmaster
  • 333
  • 2
  • 5
  • 11
0
votes
1 answer

How to dynamically print the checkbox along with its value in BI publisher reports

Can any one please suggest me the procedure on how to dynamically print the checkbox along with its value in BI publisher reports(PDF format) Thanks in advance!!
mitha007
  • 1
  • 1
0
votes
1 answer

BI Publisher in Word buttons don't work

I've imported XML file and buttons in Word became available, but when I press neither works. Code isn't important here.
Milos Citakovic
  • 43
  • 9
1 2 3
…
35 36