Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Models
Discussion List
-
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 157 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 43 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 11 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 415 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…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 784 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 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 77 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 32 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 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 51 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 34 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 145 views 16 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum