Popular Tags
- OTBI 1,387
- Reporting 1,362
- FDI 924
- Analysis and Data Visualization 923
- BI Publisher 807
- Analysis 658
- Administration 547
- Oracle Fusion Analytics 541
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 324
- OAC 302
- Answers 260
- Security 258
- Analyses 252
- Developers 238
- HCM 231
- BIP 225
- Data Modelling and Datasets 212
- Data Connectivity 205
- ERP Analytics Content 193
- BI Publisher Report Templates 182
- Report Output 181
- Agents 151
- Customizing Reports 145
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Models
Discussion List
-
6Extend ERP Hierarchy Reorder Function to FDIThe data hierarchies are ordered alphanumerically by code values in ERP. Recently the reorder function was improved in ERP & EPM (from EDMCS) to allow these to be reorde…Johanna McGrath 46 views 1 comment 6 points Most recent by Krishna Prasad Kotti-Oracle Oracle Fusion Data Intelligence Idea Lab -
SQL editor for Oracle BISummary What tools are people using to edit SQL in Oracle BI? Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model…Alex Andreadis-21319 86 views 5 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence -
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 1.9K views 9 comments 2 points Most recent by User_5VV3R Oracle Transactional Business Intelligence
-
I need to know the key column information to be associated with the OOTB subject area.I need to know the key column to be tied to the OOTB subject area. I want to create a custom subject area in the semantic model extension based on the OOTB subject area … -
4Adding Purchase Order Detail Information to Subject Area: AP Holds in FAWBusiness wants the ability to access Purchase Order information to on top of which invoices are currently on hold. Fields we need to map out to subject area - AP Holds a…Juan Hurtado 32 views 1 comment 4 points Most recent by Juan Hurtado Oracle Fusion Data Intelligence Idea Lab -
OBIEE Data Model ParametersI have transitioned an analysis to a data model using the OBIEE connection. It's been requested to add parameters to the data model and report. I'm used to building them…Sean-B-01 62 views 16 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
How to hide parameters from data model when the report is embedded by link in a dashboard?Hi, I have a report that's embedded with link in a dashboard. I wanted to use dashboard prompt for the parameters. How can I hide the parameters from the data model with…Ivony Ann Paula Salango 23 views 6 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence -
Is it possible to remove a certain field/column from the output of CSV file in OTBI report?Hi, Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format. As you…Ivony Ann Paula Salango 31 views 8 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
3Data Flow Record CountsA visual record (row) total on screen or a concise way to calculate the total count associated with each individual step in a Data Flow is needed Users would like to hav…Matt_B 1 view 1 comment 3 points Most recent by Branden Pavol Oracle Fusion Data Intelligence Idea Lab
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 5.9K views 21 comments 1 point Most recent by Sushant95-Oracle Oracle Transactional Business Intelligence -
What parameters to put in "Transactions Print Data Model"Hi Team, Hope you all are doing great! I want to know what all parameter data would be required to put in the "Transactions Print Data Model" to generate the XML data di…
-
Is it possible to edit the "retirements" formula in Fixed Asset Balances Real Time?I put the "retirements" field in my report, but they are considering SOURCE_TYPE_CODE = RETIREMENT and ACCOUNT_TYPE = COST, DEPRECIATION_RESERVE e TRUE_DEPRECIATION_RESE…Riane 11 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not Provide Content Hi, we're in the middl…Juan Miguel Isip-94819 132 views 2 comments 1 point Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
2Set security in data ModelSome users have access to the Data Model, and the customer needs to set security restrictions within the Data Model. For example, User X should only be able to see emplo…Mohamed Mohsen 38 views 3 comments 2 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab -
1Property or Option to Exclude a Field in the Data ModelThe requirement is when we are exporting a .CSV report, we wanted to have an option to select/deselect fields to be included in the export file. We have a case that ther…Ivony Ann Paula Salango 1 view 0 comments 1 point Started by Ivony Ann Paula Salango Oracle Transactional Business Intelligence Idea Lab
-
Product roadmap for BI Publisher Data Models in Fusion ERP CloudHi Team, Could you please share roadmap for BI Publisher Data Models in Fusion ERP Cloud?Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by RichardChan Oracle Analytics Publisher
-
Is there any function like data model in OTBI Analysis and Interactive Reporting?Hello, I am working on training users in our organization to utilize the analysis and dashboard features in OTBI. However, I have encountered a challenge: filters and me…User_60BGL 63 views 3 comments 0 points Most recent by User_60BGL Oracle Transactional Business Intelligence
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 22 views 3 comments 0 points Most recent by Federico Venturin Oracle Analytics Publisher
-
Error during query processing (SQLExecDirectW).Hello expert. We are facing an issue with analytics, this occurs randomly We created an agent based on an Analytic This works fine almost all the time, but randomly fail…User_KUEXP 351 views 4 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
November Webinars - Register Today!November 4 - Administration and Security November 5 - Deploy a Vanity URL for Oracle Analytics November 12 - Getting Started with Fusion Data Intelligence November 13 - …Aimee Williams-Oracle 83 views 1 comment 1 point Most recent by Aimee Williams-Oracle Oracle Analytics Trainings