Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Models
Discussion List
-
Issue with multi-select filter in reportI'm developing a report and encountered a problem when trying to select items in a filter. In its current configuration, I can extract either ONE specific item or ALL it…Kauan_Bohn 28 views 6 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence -
Client cannot view report dataI have create a report BIP with data model but when the user execute it the result is empty when I can see data example: My user view: Customer view:Diego Zegarra 21 views 3 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence -
1Faulty Oracle data models - is there a register?Is there a list or register where faults in std Oracle OTBI data models can be raised? for Example I find that the Work Definitions in the "Work order costs real time" m…Hylton 1 view 0 comments 1 point Started by Hylton Oracle Transactional Business Intelligence Idea Lab
-
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 2K views 10 comments 2 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
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 102 views 6 comments 1 point Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
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 41 views 1 comment 6 points Most recent by Krishna Prasad Kotti-Oracle Oracle Fusion Data Intelligence Idea Lab -
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 35 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 61 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 25 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 33 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 6.3K 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 131 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 31 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 66 views 3 comments 0 points Most recent by User_60BGL Oracle Transactional Business Intelligence