Reports
Discussion List
-
Create BIP Report to Fetch the ESS Job Name, ID, And the SubmitterHi, We would like to create a report to fetch the ESS job name, id, and the submitter. ThanksAhmed Maher K. 13 views 2 comments 0 points Most recent by Ahmed Maher K. BI Publisher Learning Center -
Report Missing NotificationsHi All, We have loads of notifications we have from Oracle and few we develop custom. We have them scheduled and some are BI Bursting notifications. Due to multiple reas… -
Aggregation function like stringagg() is supported in oracle BI queriesselect string_agg(goal_name,',') from (select distinct goal_name from HRG_GOALS) t Received ORA-00904: "STRING_AGG". invalid identifierChandra Thangavelu 2 views 1 comment 0 points Most recent by Mandeep Gupta BI Publisher Learning Center
-
BIP Jobs list detailsIs there a way to get the list of jobs scheduled in BIP (And the job run history details) exported into a document?Jahnavi-Oracle 12 views 2 comments 0 points Most recent by Jahnavi-Oracle BI Publisher Learning Center -
BI Publisher Word Plug-In ErrorI have the Word Plug-in that has previously worked without issue, however it is now kicking back an error when I attempt to preview my data. Steps taken: Opened rtf temp…
-
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…
-
Narayanan Subramaniam-Oracle 28 views 1 comment 1 point Most recent by ALOK SH-Oracle BI Publisher Learning Center
-
Bursting by quantity of results? And "pull" delivery???I need to export a couple million rows of data from Financials as CSV files or similar. Even when I limit the output by fiscal year, some years produce well over a milli… -
BI Publisher Report Timeout error on accessing it from Oracle Integration CloudOracle Integration Cloud process invoking (https://XXXX.xx.xx.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL) a BI Publisher report error out with the…
-
Combine BIP report with dashboard promptI've heard from a different post that it is possible to use filtering on a report through a dashboard prompt. However I haven't been able to find out how exactly to conn…Annie Cho 15 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Hiding list of values in parameters of bip report according to user data access role.Can we hide the list of values in parameter scetion of a bip report for users according to the roles and priviledges they have. For eg we have ledger names coming from l…User_M14OP 12 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Reports and Analytics- Folder Security changes after 22a?We are noticing changes in security access to BI Publisher reports in our Custom Reports and Analytics Folders and Sub Folders. Example 1: Employees with only the Employ…Mike Spalding 11 views 3 comments 1 point Most recent by Yasheswi Challa BI Publisher Learning Center -
How to build a rule that is Malaysia pull the National Identifiers no, Non Malaysia pull passport noWe Need to build a rule that is Malaysia pull the National Identifiers Field, Non Malaysia pull the Passport number may i know how to write logic. and which field we nee…AjayKumar Maddipati 2 views 1 comment 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center -
BIP Samples?Is there another place to see samples of reports? the links from this page are broken
-
Getting Log of ESS JobsHi Experts, We have a requirement to get the log of ESS job from fusion. Any pointer will be helpful like table name to get document Id or REST API to get this detail?Rajeev Nayan 2 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
BI Publisher Report producing values for next row when values cannot be foundHi all, Hoping you can assist me with some off behaviour that I am experiencing when producing a report in BI publisher. We have written a data model that when run appea…Luke.Findex 1 view 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Office-365 … -
Filtering turned on for excel templateIs there a way to create an excel template so that filtering is automatically turned on when the excel report is generated? (I know you can set the 'freeze' view...so ma…
-
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…
-
Is it possible to create drilldown in BI publisher report?I have worked with drill down options in OTBI & OAC. Want to check if this option is available in BIP. Can you please advise?
-
BIP Extensibility Training - How to Customize an RFT Report LayoutSummary This short tutorial details how to customize an RTF report layoutContent This short tutorial details how to customize an RTF report layout. You will learn how to…nedicken-Oracle 545 views 8 comments 23 points Most recent by Tamer El-Tonsy - FudgeLearn UK BI Publisher Learning Center
-
Please share tutorials on how to make SQL Queries for BIP ReportsSummary of Request Please share tutorials on how to make SQL Queries for BIP ReportsContent Hi, I am interested in learning SQL query building for BIP Reports. Please sh…Renuka Soneja-154959 47 views 0 comments 1 point Started by Renuka Soneja-154959 BI Publisher Learning Center -
How to Draw vertical lines in BIP ReportSummary of Request How to Draw vertical lines in BIP ReportContent HI All, I want to draw vertical lines in my BIP report. When I am adding those as a object, it's start…Ashutosh jain 18 views 3 comments 0 points Most recent by Kristine Kukich-Oracle University-Oracle BI Publisher Learning Center
-
BIP Extensibility Training - How to Create a New ReportSummary This short tutorial details how to create a new report:Content This short tutorial details how to create a new report: You will learn how to: * Create the data m…nedicken-Oracle 418 views 2 comments 12 points Most recent by Farooq H Syed BI Publisher Learning Center
-
BIP Extensibility Training - How to Delete a Report LayoutSummary This short tutorial details how to delete a report layoutContent Learn how to delete a report layout in this short tutorial. Runtime: 00:01:18 View the tutorial.
-
BIP Extensibility Training - How to Create a Report LayoutSummary This short tutorial details how to create a new RTF layout for your reportContent This short tutorial details how to create a new RTF layout for your report: You…
-
BIP Extensibility Training - Enabling Additional Output Formats for Reports LayoutsSummary This short tutorial details how to enable CSV and Excel output formats for report layouts using the BIP Customize FeatureContent This short tutorial details how …
-
Error Displaying RTF TemplateSummary of Request ErrorContent Good afternoon, At the time of creating the template by the bipublisher extension of WORD and save it in RTF format and upload it to the …Cristian Rebellón 26 views 0 comments 0 points Started by Cristian Rebellón BI Publisher Learning Center