Popular Tags
- OTBI 1,509
- Reporting 1,428
- FDI 1,330
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 615
- Administration 568
- Fusion HCM Analytics 463
- Analytics 463
- Fusion ERP Analytics 461
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 312
- Security 309
- Fusion Data Intelligence 298
- HCM 297
- Fusion Data Intelligence FDI 280
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
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 267 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 149 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 40 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 462 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 16 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 22 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.3K 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 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 114 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 59 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 6 views 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 171 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 56 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 41 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 45 views 1 comment 4 points Most recent by Juan Hurtado Oracle Fusion Data Intelligence Idea Lab