Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,116
- Analysis and Data Visualization 986
- BI Publisher 853
- Analysis 681
- Oracle Fusion Analytics 584
- Administration 555
- OAC 448
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 356
- 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 191
- Report Output 184
- Fusion Data Intelligence 177
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Models
Discussion List
-
2Better methodology for entering SQL for Dataset within Data Model for BIP reportsBusiness Case: Our BIP reports require that large SQL scripts must be written to accomplish our reporting requirements since the "canned" reports are woefully insufficie…Dawn Watson 13 views 0 comments 2 points Started by Dawn Watson Oracle Transactional Business Intelligence Idea Lab -
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… -
Issues when trying to use a Datamodel in different workbooks with different subject areasWhen trying to use a Datamodel in different workbooks with different subject areas, an existing join is being removed. A warning appears - There is an existing match tha…Usha Athimakula 61 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Analytics Cloud and Server -
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 2.5K views 13 comments 2 points Most recent by Sergey6885 Oracle Transactional Business Intelligence
-
1Data Models: Restrict/enable access to certain data tablesWe want our CMMS analyst team to have access to (and build) data models specifically for the Maintenance area. However, due to current system limitations, we are unable …POD AH 1 view 1 comment 1 point Most recent by ShankarS-Oracle Oracle Transactional Business Intelligence Idea Lab
-
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 43 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 24 views 3 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
1Faulty Oracle subject areas - is there a register?Is there a list or register where faults in std Oracle OTBI subject area models can be raised? for Example I find that the Work Definitions in the "Work order costs real…Hylton 1 view 0 comments 1 point Started by Hylton Oracle Transactional Business 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 121 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 44 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 45 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 76 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 42 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 66 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 7.4K views 21 comments 1 point Most recent by Sushant95-Oracle Oracle Transactional Business Intelligence -
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 12 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 135 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