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 Kadeh 51 views 5 comments 0 points Most recent by Abhijit Sahu-Oracle BI Publisher Learning Center
-
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 123 views 1 comment 0 points Most recent by MandeepGupta 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 21 views 2 comments 0 points Most recent by Jahnavi-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 12 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 79 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…
-
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 11 views 1 comment 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center
-
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 12 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 11 views 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…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center
-
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…Neil Dickens-Oracle 565 views 8 comments 23 points Most recent by Tamer El-Tonsy - Tatonsy 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 57 views 0 comments 1 point Most recent 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 49 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…Neil Dickens-Oracle 428 views 2 comments 12 points Most recent by Farooq Syed, CPA, PMP, CISA 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 67 views 0 comments 0 points Most recent by Cristian Rebellón BI Publisher Learning Center