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

convert gregorian to hijri date in RTF Template

I have a requirement to get arabic hijri date in a BI publisher report. So after building the RTF template I need to convert gregorian to hijri date in RTF Template using xdo or xslt Regards, Rachit
0
votes
2 answers

How to sum from 2 fields in XML?

Here's my XML 07.00 17.00 17.00 I want to sum the total sale prices, in this case it will be $14.00 because the…
Andy
  • 195
  • 2
  • 5
  • 13
0
votes
1 answer

How to limit menu parameter selection count in Oracle BI Publisher?

My datamodel has menu parameter which allows multiple value selection. Menu consists of more than 3000 items. I want to allow user to select only 100 or less parameters. Is that possible and if it is - how to do that? Thank you.
Adomas
  • 466
  • 1
  • 8
  • 21
0
votes
1 answer

Oracle BI Publisher rtf template with output to Excel and injecting a VBA macro

When creating an Oracle BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to inject an Excel VBA macro in the Excel output file?
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
0
votes
1 answer

How to get attribute value of an element in rtf template using BI publisher

I have xml like: -8657435577410.93 164005044842 A.GL_CODE sample data A.DESCR1 sample data
Usman
  • 23
  • 1
  • 6
0
votes
1 answer

Weblogic server window exit when start BI Publisher

I have installed Oracle BI Publisher trail edition, when i click to Start BI Publisher to start server, command window appear and exit after 10 seconds. when i click again to Start BI Publisher, command window exit after 4 seconds. may be some…
kumar
  • 317
  • 1
  • 6
  • 15
0
votes
2 answers

Can BIRT tool be an alternative for BI Publisher to generate reports?

I am using Oracle BI Publisher to generate reports with my java webservice call. My input source is XML files and design template is RTF. when i have huge volume of data in XML file, its throwing an out of memory at some point of time. So, planning…
janasainik
  • 811
  • 5
  • 20
  • 40
0
votes
1 answer

Creating .docx files from RTF templates

I using BI publisher desktop API to create doc from RTF templates. I want to use templates so that any slight modifications in presentation can be made directly in templates. Currently I am able to create only doc file because creating docx is not…
nevin
  • 73
  • 7
0
votes
1 answer

Dynamic Images in BIP Template?

We have set of images in a shared path. In the query we have written a logic that would give us the path of the image something like \\path\Logos\ test.jpg . In the RTF template, we have used a dummy image with the Alt Text set to the path of the…
Niranjan
  • 172
  • 1
  • 5
  • 19
0
votes
0 answers

AND condition in Multiple Select of BI Publisher

Is there any way, we could use AND condition in Multiple Select drop down? I mean if the drop down contains 3 values like first_option second_option third_option I have to do an AND condition. The query we use is select some_column from table…
Niranjan
  • 172
  • 1
  • 5
  • 19
0
votes
1 answer

Japanese Characters in Oracle BI Publisher

We are using Oracle BI Publisher. We have a report in Japanese. The output of the report is in HTML and is getting displayed properly. When we send it as a mail using either schedule button or send button, the japanese text is not getting displayed…
Niranjan
  • 172
  • 1
  • 5
  • 19
0
votes
1 answer

Email attachment in Oracle BI Publisher?

The send button in BI Publisher (Oracle Business Intelligence Publisher Release 10.1.3.4) will send the generated report into the body of an email. We have to manually key in email parameters like to, cc, etc. Is there a way we could attach a…
Niranjan
  • 172
  • 1
  • 5
  • 19
0
votes
1 answer

Crystal Report design file to BI publisher template

I am currently working on the conversion of Crystal Report to BI publisher report. I am wondering if there's a way to convert the crystal .rpt design file to word .rtf template directly?
Bo PENG
  • 86
  • 4
0
votes
1 answer

Data is not loaded in BI Publisher flash template - Error #2032

I have created a simple reprot with one level of XML data, and followed all the guide lines from oracle tutorial http://docs.oracle.com/cd/E10383_01/doc/bip.1013/e10416/flashtemp.htm When I run the application from Flash Builder, it works fine, a…
sameh.q
  • 1,691
  • 2
  • 23
  • 48
0
votes
1 answer

message box in Oracle BI Publisher 10g

In Oracle BI Publisher 10g, I have two parameters for from date and to date and the date entered in to date should be greater than from date. How can I display a message so that the user is prompted to re-enter the to date.
chemicalkt
  • 816
  • 5
  • 16
  • 33