Popular Tags
- OTBI 1,500
- Reporting 1,418
- FDI 1,290
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,015
- BI Publisher 896
- Analysis 699
- Oracle Fusion Analytics 634
- OAC 582
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 443
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 293
- Fusion Data Intelligence 275
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 231
Data Models
Discussion List
-
Best Practices for OBI Semantic Modeler with Git Integration in a full lifecycle environmentHello, We've been looking at possible moving from the traditional RPD to the Semantic Modeler for our data modeling practice. Got everything set up with Git and it looks… -
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 233 views 9 comments 0 points Most recent by Adnan Saleem Oracle Transactional Business Intelligence Forum -
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 129 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 425 views 3 comments 2 points Most recent by A Vidhan Oracle Fusion Data Intelligence 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…Ancy Paul-Oracle 11 views 0 comments 2 points Most recent by Ancy Paul-Oracle Oracle Analytics Idea Lab -
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 Most recent 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 1.1K 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 3K 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 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 101 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 44 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 Most recent 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 156 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 54 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 …Michi-Oracle 42 views 2 comments 0 points Most recent by Michi-Oracle Oracle Fusion Data Intelligence 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 Data Intelligence Idea Lab