Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,178
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 606
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 417
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 275
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
Meaning of Oracle table name with and without "_" at its end?Summary What is the difference between Oracle tables named with and without "_" at the end? Content Hello Oracle Community, 1) What's the difference between Oracle table…Jonathan Chan gmg 753 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to correctly script the "OR" function in Group Filter section in Data Model in OBIEE?Summary In OBIEE, an error was prompted when I was scripting the "OR" function in Group Filter section of the Data Model interface. Content Hello Oracle community, In OB…Jonathan Chan gmg 111 views 4 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to pick mulitple fields into table box when buidling report using data model?Summary How to pick mulitple fields into table box when buidling report using data model? Content Hello Oracle Community, When building report using data model, in the "…Jonathan Chan gmg 262 views 14 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog? Content In our PROD pod, we have several folders under the custom folder location that incl…User_VR8E0 453 views 4 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi Publisher Content Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shou…Alberto Romani-Oracle 291 views 3 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
BIP compress output prior deliverySummary Compress output prior delivery Content To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have writte…Niketa Ashwini 857 views 9 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
Pivot table in rtf bi publisher 12cSummary Edit for-each to fetch on another for-each-group Content Hello developers, In pivot table, it fetch all empcode with respective to the cross table but in my cas…Osama Fawzy 21 views 1 comment 0 points Most recent by Osama Fawzy Oracle Transactional Business Intelligence Forum -
call a procedure on oracle bi publisher 12cSummary oracle bi publisher add Global-Level Element by PL/SQL Content Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mod…Osama Fawzy 451 views 2 comments 0 points Most recent by Osama Fawzy Oracle Transactional Business Intelligence Forum -
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 231 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 Oracle Transactional Business Intelligence Forum -
how to connect to Bi publisher administer console in fusion 19C?Summary How to access the bi publisher administer console in fusion 19c? Content I have added some roles to my fusion account. But, I cannot see the bi publisher adminis…Geetha Devi 221 views 11 comments 0 points Most recent by Geetha Devi Oracle Transactional Business Intelligence Forum -
Security Console TablesContent Hi Everyone Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the rig…Aaron Leggett 221 views 5 comments 0 points Most recent by Karthik Vinodkumar Oracle Transactional Business Intelligence Forum -
Audit History to access changes made in BIP Data ModelSummary Require table or methods to find out changes done in BIP Data Model Content Hi, We have encountered an issue recently where the data model query were updated by …Samrat Chattapadhyay 565 views 2 comments 0 points Most recent by Joel Acha11111 Oracle Transactional Business Intelligence Forum -
BIP OptionsContent Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help! 1) Is it possible to allow users to type into a paramet…Prudence K 252 views 12 comments 0 points Most recent by Isaline Nguyen Oracle Transactional Business Intelligence Forum -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package. Content I am search…Tim Welsh 501 views 8 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum -
Dynamic Report layouts in BI PublisherSummary Dynamic Report layouts in BI Publisher Content We have a requirement from a client where from the prompts, if we select any attributes you report layout has to s…Ramesh Pusarapu 191 views 5 comments 0 points Most recent by Ramesh Pusarapu Oracle Transactional Business Intelligence Forum -
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …Abdalaziz Barham 42 views 1 comment 0 points Most recent by Abdalaziz Barham Oracle Transactional Business Intelligence Forum -
Dynamically place the custom logo in BIP reports in Fusion CloudSummary Dynamically place the custom logo in BIP reports in Fusion Cloud Content Hi, We need to developed few custom reports as per the requirements. In this implementat…Islam Abu Khamseh-76822 412 views 3 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum -
Packages in BI publisherSummary Packages in BI publisher Content Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pa…Islam Abu Khamseh-76822 61 views 1 comment 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum -
Translate SQL of OTBI in ApplicationDB HCMSummary How to Translate SQL of OTBI in ApplicationDB HCM? Content Hello, I have verified that in SA of OTBI there aren't some value that I want to use in a report. I fo…Giuseppe 1234 51 views 1 comment 0 points Most recent by Vijaya Kumar-70229 Oracle Transactional Business Intelligence Forum -
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sql Content Hi, Anyone know how to fetch the manager name for the terminated employees? For…NIRMAL KUMAR L 121 views 1 comment 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Forum