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

What's the difference between creating a report in BI publisher and creating a report using a BI administrator repository?

I've been trying to build a repository using the BI administrator tool in OBIEE. The repository is then loaded using the enterprise manager without any issues. But a new analysis could not be performed because of the following error whenever I try…
user3824032
  • 13
  • 5
1
vote
2 answers

Call BI Publisher web service with ReportRawData

Target: Supply XML data for BI Publisher report within SOAP request to it's RunReport() method. Environment: Oracle BI Publisher 11.1.1.7.0 (build:20130303.1415) Client - SoapUI 5.0.0.0 or custom PL/SQL code (Oracle Database 11g Enterprise Edition…
ThinkJet
  • 6,725
  • 24
  • 33
1
vote
1 answer

BI Publisher Web Service Token expire time

I'm working on BI Publisher web service. first, I call the login() with user name and password to get the TOKEN; then, I call other insession methods with the TOKEN My question is: By default, how long the TOKEN will expire? This is a configuration…
Eric
  • 1,031
  • 4
  • 14
  • 29
1
vote
1 answer

Sql Decode in BI-Publisher

I have this query: select nm_strgp brand from co_strgp where id_strgp_lv='2'; One value in this column is HOLLAND & BARRETT but i want to display it as HOLLAND & BARRETT in BI publisher. How can I achieve this?
saniya
  • 15
  • 5
1
vote
1 answer

Request Sets, request groups, concurrent programs... what is the relationship between all these?

Hi Oracle XML Publisher, I'm looking for a high-level picture of how things work. It's not clicking for some reason. so I start out with the sample XML file, and this is my data template. And the final goal is to get a nice PDF output. But…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
1
vote
0 answers

Clarification regarding this line in the Oracle BI Publisher report designer guide?

I'm reading this line in the Oracle BI Publisher guide It is strongly recommended that you use a WHERE clause instead of a group filter to exclude records from your extract. This is a bit confusing to me.. what is the significance of using WHERE…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
1
vote
2 answers

BI Publisher how to use in an IF condition

In a BI report I need to display or hide a certain field based on the page number. For example, if page number = 1 then the field must be hidden. Can you please tell me how to use the tag as part of an IF condition ?
user2275479
  • 73
  • 1
  • 4
  • 8
1
vote
3 answers

BI Publisher prints '?' instead of Euro symbol

I have registered a concurrent program that uses RDF as the data source and a BI RTF template for layout. It works fine except that the output does not display the Euro symbol correctly (it displays a '?' instead).Some forums suggested changing the…
user2275479
  • 73
  • 1
  • 4
  • 8
1
vote
2 answers

Oracle BI Publisher - How to format numbers as text so that leading zeroes don't dissappear

When creating an Oracle BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to format numbers as text so that leading zeroes don't dissappear? I would like to print out telephone numbers and they have…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
1
vote
1 answer

Not able to pass multi values from prompts to Bi Publisher 11g

I am using a choice list in dashboard prompt with default value:"All Column values" and set to a presentation variable:"presvar In BIP 11G data model,in where clause i am writing it as: where(tablename.colname in (:presvar)) This is working only…
iswarya
  • 11
  • 1
  • 2
1
vote
7 answers

Oracle BI Publisher auto width of excel columns

When creating a BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to specify that a table should use auto width for the columns in the Excel output. By default, when you use the BI Publisher Desktop…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
1
vote
0 answers

Enable debug log for standalone BI Publisher 10g deployed on weblogic

How can I enable debug log for standalone BI Publisher 10g deployed on weblogic? I have tried creating xdodebug.cfg file with necessary statements, and placed it under JDK/jre/lib folder. I have set the log level to debug in bi publisher. Yet I…
hohenhiem
  • 75
  • 1
  • 1
  • 10
1
vote
1 answer

How to enclose Oracle BI Publisher into iframe of some other app?

How to enclose Oracle BI Publisher into iframe of some other app? I have installed Oracle BI Publisher 11g (Trial version) and would like to enclose it into iframe of some other app. It works with other websites/apps but does not work with the…
user1749546
  • 107
  • 1
  • 5
1
vote
3 answers

How can I change Oracle BI Publisher report file name?

I am generating reports with Oracle BI Publisher 11.1.1.6. All generated report's file names (excel, word, pdf) are "xdo" (eg. xdo.doc). How can I change report file name to other value? (I mean Report, not Report job). In simpler words, I click to…
Adomas
  • 466
  • 1
  • 8
  • 21
0
votes
1 answer

how to stop a running report in BI Publisher

I have a report scheduled in BIP server; it's running now but it would take very long time to complete. I just want to stop it and modify the query. but I can't find where can I stop it; can anybody help me out? How to terminate the running report…
Gary
  • 4,495
  • 13
  • 36
  • 49
1 2 3
…
35 36