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

.xdo and .xdm files missing in OBIEE 12c

I created a report in OBIEE12c. But I dint find and .xdo, .xdm, xdo.cfg .... file in any of the folders. In OBIEE 11g they use to be there in some repository directory. Where and how OBIEE 12c stores catalog objects/repositories.
Chandu
  • 1,837
  • 7
  • 30
  • 51
-1
votes
1 answer

How to parameterise variable length of Strings?

I am writing a query where 'batch_name' is the parameter, some times I get only one batch name and sometime I get 2 or more batch names. How can I handle this in Oracle BI Publisher query, Here is my query, Select * from pay_batch_headers pbh Where…
Raghu
  • 1,324
  • 7
  • 24
  • 47
-1
votes
1 answer

Line Spacing in BI Publisher

I need to give 1.5 Spacing between two lines in a Paragraph. But I can't see any options like that. I tried to copy the contents from MS Word with 1.5 line spacing, but once the report is saved, it looks like No spacing.
Arun Nadaraj
  • 153
  • 1
  • 3
  • 14
-1
votes
1 answer

How to Restructure XML using XSLT when the Child Node is actually the Parent

I have a very poorly structured XML source coming out of our ERP system, and the Parent/Child relationship for Header to Detail is reversed because at the runtime, the parent (key) isn't known until the first detail record is process. This is due…
J. Ellis
  • 13
  • 4
-2
votes
1 answer

BI Publisher - SQL LIKE statement with parameters in BI Publisher

I have a SQL select statement like below with some parameters; Actually, I want to concatenate some strings with some parameters: N.B : It works correctly in Oracle sql developer, but when I want to execute it in BI Publisher! an error ORA-00933:…
Yassine
  • 67
  • 2
  • 9
-2
votes
2 answers

How can I add a checkbox in BI Publisher?

I am trying to add a checkbox in my report. This checkbox should be checked or unchecked depending on database values. How do I add a checkbox in Oracle BI Publisher?
-2
votes
1 answer

Wants to install BI Publisher standalone

My question is about to install BI Publisher on my machine. I want BI Publisher as standalone . I do not want it as plugin in Microsoft word. Thanks Vivek shokeen
1 2 3
35
36