Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,109
- Analysis and Data Visualization 984
- BI Publisher 852
- Analysis 680
- Oracle Fusion Analytics 583
- Administration 555
- OAC 447
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 354
- Security 293
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 174
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
How to add a parameter when calling a function from the trigger sectionI have a parameter that I pass directly to the data model - RDATE, and this parameter is automatically added to the triggers section. I get an error when calling the fun…Vitalii_Alliance_dgtl 92 views 8 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher -
Field is in DM but not showing on BI Publisher to add to templateI'm trying to add a field to a BIP report and the field is included in the DM. When I open the template and access BIP and select field to add it to the template the fie…
-
Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embeddedselect ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,okc_k_articles_b cab, okc_article…Snehashis_Santra 12 views 3 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher
-
'Print Receivables Transactions' Data Model does not return any Sample Data.The underlying data model for 'Print Receivables Transactions', ' Transactions Print Data Model', does not return any sample data. I would need this to get a sample XML …Reena Agrawal 44 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Want to customise Standard Oracle SalesOrder Report by adding new columnsI want to add few new columns in salesorder standard Oracle Report ,but unfortunately standard XML attached in the datamodel does not have the tags that I require , Is t…
-
How to access PaaS table or external database through BI PublisherWe have a PaaS solution where we have created a custom screen and stored the data in the custom table(DBCS), and we have another DW system as well; we want to build a re…
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence
-
How to disable pdf attachment while bursting in Oracle Fusion HCMGiven 'FALSE' as parameter6 in my bursting query. Still attachments are triggering. Suggestion PLEASESai Krishna Chelikani 353 views 5 comments 0 points Most recent by Sumanth V -Oracle Oracle Analytics Publisher
-
1Allow Ability to Restrict Data Model Creation in OACCurrently there is no role in OAC which restricts users from creating Data Models in the Published Reporting section of OAC. This is an issue because it allows all Conte…Lee Eslick-Huff 12 views 0 comments 1 point Started by Lee Eslick-Huff Oracle Analytics Cloud and Server Idea Lab -
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…Saher 66 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data ModelHi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it…KDR 64 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
2How to restrict the data access for different users on BIP reportsWe developed some custom BIP reports in our system, and by default, BI consumer role is taking the read access, thus, most of our users who have the BI consumer role wil…Jay0089 101 views 0 comments 2 points Started by Jay0089 Oracle Transactional Business Intelligence Idea Lab
-
ESS job Is not generating the PDF file in the output sectionHi Team, I was trying to get the bursting query output through ess job, but my job is getting succussed and output file is not generating. why I am not getting pdf file …Pooja_123 49 views 2 comments 0 points Most recent by Kevin M-Oracle Oracle Transactional Business Intelligence -
Java.sql.SQLException: Invalid column indexSummary Errors out with the mesaage Content Hello There, We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution i…Donald 5K views 14 comments 0 points Most recent by User_0YPLB Oracle Transactional Business Intelligence
-
Can Someone help with table and column details for the Manager performance check-in feedback columnHi, we have OTBI report developed for check-in details summary information. As this is hitting performance issues very often and taking very long time to run. we are con…User_LEKDP 23 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Repeating Footer on Invoices Report Output and print ContinuedThe request here is for the footer to display (repeat) on every page of a multi-page invoice. On all pages apart from the LAST page, the footer should repeat with the wo…Pooja K-Oracle 51 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher
-
13Ability to extract all ESS job and job set name via Manage Enterprise Scheduler Job for HCM/Fin/CRMOrganization Name Department of Treasury and Finance Description Hi Team, Per Oracle Fusion product limitation, The Jobset and Job Definitions are not stored in any DB t…Akash Gupta 446 views 4 comments 13 points Most recent by Emiliano R Oracle Transactional Business Intelligence Idea Lab
-
Is it possible to run the procedure in Oracle BI Publisher ?Hello everybody Is it possible to perform the procedure before generating a report in Oracle BI Publisher, when creating a Data Model ? I have reports that are executed …Vitalii_Alliance_dgtl 216 views 4 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher
-
"Not Enough Memory to open this page" -BI ReportHi Folks, We have a report which generates assignment details, we are able to export the report in xml format, but while running in HTML format , first it takes time to …Sushant95-Oracle 71 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher
-
How to add Rerun option to generate BI report for incremental dataHi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to run option to…Jeetesh Singh 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher