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

Show the user name in the layout or prompt level

I have user the user name as 'USER1' to login to BI publisher.is it possible to display my user name like 'USER1' in prompt level or in layout level.i know we have to use 'xdo_user_name' but can any one explain how to use it.please help me thanks
Eswar Vignesh
  • 77
  • 2
  • 17
0
votes
0 answers

if condition in a for-each-group BI Publisher report

Im trying to get a summary output that displays data based on Product that have different CwaOrderType.
Yan
  • 35
  • 1
  • 4
  • 10
0
votes
1 answer

how call BI Publisher report from Apex?

how can I call bi publisher report from apex. bi publisher 11.1.1.7
Azam Sajid
  • 41
  • 2
  • 11
0
votes
1 answer

BI Publisher with Complex Report

I have a report with the following metrix: Item, Total item quantity in month, Total item quantity in previous week, Total item quantity in 2 previous weeks, Total item quantity in 3 previous weeks I write this matrix in a single query but it is…
Hoang Nguyen
  • 61
  • 1
  • 13
0
votes
1 answer

BI PUBLISHER url file after installation

I installed bi publisher but didnt save url file of enterprise manager etc. thats why i cant login to bi. my question is. where the url file saves in BI publisher installed location?
Azam Sajid
  • 41
  • 2
  • 11
0
votes
1 answer

BIP Report in Siebel Open UI

I created BIP report in Siebel Open UI. In my screen got two Applet : Information Applet - use Information BC Transaction Applet - use Transaction BC In Information Applet got two drop down field which are Acc and Credit Note No (for drop down…
Yan
  • 35
  • 1
  • 4
  • 10
0
votes
3 answers

How access xml file of "save as sample Data" in BI Publisher

When we create data model we perform " save as sample data". My question is how i access the xml file for uploading xml data in ms word.?
Azam Sajid
  • 41
  • 2
  • 11
0
votes
1 answer

count dictinctly by group in xml bi publisher

So I have to do a report that will display and count distinctly the CwaProductCode based on CwaChannel and CwaOrderType. Heres my xml: Customer Portal UT…
Yan
  • 35
  • 1
  • 4
  • 10
0
votes
1 answer

PeopleSoft BI Publisher Parameters on second sheet of Excel output

I am creating BI Publisher reports from PeopleSoft 8.53.08 that output to Excel. We would like for all data rows to be on one page, but for all the parameters entered to run the report be output to the second sheet.tab. Does anyone know if this is…
F. Swann
  • 1
  • 1
0
votes
2 answers

Count Distinct Value

I have to do a report summary table that will be displaying the same data. Tried using the xdoxslt:distinct_values to group the same value but it does not work nor it displays any error. What I have right now: 001 - 1 002 - 1 001 - 1 What I need to…
Yan
  • 35
  • 1
  • 4
  • 10
0
votes
1 answer

How to run BIP reports through unix script

We have a requirement of running/Scheduling BIP reports through unix script.Obiee will be installed in the same unix box. Could you please help me.I am not getting any clue on this.
mona16
  • 46
  • 8
0
votes
1 answer

Is it possible to parameter in Date from in Date parameter for BI publisher?

Is it possible to assign a parameter value for date from in date parameter? under date parameter we have date from and date to option to define the range of date to be selected in the calendar. I want to pass a parameter with date type to the date…
Eswar Vignesh
  • 77
  • 2
  • 17
0
votes
1 answer

Function list not appearing in BI Publisher when adding event triggers

I'm trying to create an after-report trigger for my data model. I created the following package on my database: Package: create or replace PACKAGE CM_BILL_PRINT_PACKAGE AS P_TO_ACCT_ID CI_ACCT.ACCT_ID%TYPE; P_FROM_ACCT_ID …
AbrasiveToast
  • 1
  • 1
  • 3
0
votes
2 answers

Bi Publisher Excel preview won't preview the right version

Hi everyone, During my development on BI Publisher for Excel I ran into a problem, I made a first version of the template without any problems, i could preview the result just right. But since a while, when i use the preview button : I only get the…
Noataq
  • 11
  • 3
0
votes
1 answer

Oracle BI Publisher - Dynamic number of columns

I'm creating a report in BI Publisher using the BI Publisher Desktop tool for Word. What I need is to have a table with a dynamic column number. Let's imagine I'm listing stocks by store: Each line is an item and I need to have a column for each…
Faquir
  • 185
  • 2
  • 4
  • 16
1 2 3
…
35 36