Popular Tags
- OTBI 1,474
- Reporting 1,406
- FDI 1,200
- Fusion AI Data Platform 1,040
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 612
- Administration 556
- OAC 531
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 280
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Fusion Data Intelligence 215
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Models
Discussion List
-
BIP report to get the approval status with history and attachments for Leave encashment, salary trasHi Experts Could you please help me with the BIP report sql query on how to get the approval status for Leave encashment, salary transfer letter requests along with appr… -
Extract scheduled ReportHi Experts , Can someone help me with scheduled extract report? Looking for actual start date and end date of the scheduled job. Referred the below link which has next s…
-
How to use attachment tab in datamodel ?Hi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c…Nivya M 44 views 5 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum
-
Create Data Model optionHi, I have all the Application Admin and BI Admin/Author roles but in Reports and Analytics > Create > there is no Data Model option ? What role do i need to get this op…Junade_Shujaat 12 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum
-
Fusion Analytics Extensiblity Series: Case study-Semantic Model (Part 3 of 4)In this series, we will discuss the use case and showcase the steps to bring in the custom object (created in Oracle Fusion Application) into Fusion Analytics and model …Abhishek Bajpai - CEAL Team-Oracle 413 views 3 comments 2 points Most recent by A Vidhan Oracle Fusion AI Data Platform Forum -
2Sort/rearrange data sets for improved visibility in the workbook while working with multiple set.This feature should allow users to organize the data set within the workbook by sorting or dragging items into a preferred sequence. Reordering the data set with multipl… -
4Better 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 21 views 0 comments 4 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…Abhi_19 743 views 9 comments 0 points Most recent by Taraka Ram-Oracle Oracle Analytics Publisher Forum
-
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… -
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.7K views 13 comments 2 points Most recent by Sergey6885 Oracle Transactional Business Intelligence Forum
-
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 2 views 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 71 views 6 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence Forum -
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 35 views 3 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
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 141 views 6 comments 1 point Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum
-
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 52 views 1 comment 6 points Most recent by Krishna Prasad Kotti-Oracle Oracle Fusion AI Data Platform 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 …Michi-Oracle 31 views 2 comments 0 points Most recent by Michi-Oracle Oracle Fusion AI Data Platform Forum -
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 41 views 1 comment 4 points Most recent by Juan Hurtado Oracle Fusion AI Data Platform 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 141 views 16 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum
-
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 83 views 6 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum