Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 948
- Reporting 843
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 503
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 239
- Analyses 237
- Developers 223
- FAW 211
- BI Publisher Data Models 211
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 132
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 104
- OBIEE Answers 102
- Access and Manage Data 102
Data Models
Discussion List
-
Table Location of To/From Dates for Talent RatingsI am looking to find the the save table location for the To/From dates for the Talent Rating module. This is for a BI publisher report using a Data Model. The associated…Adam Cook 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
Fusion Analytics Tech Tips : Custom Case Study PVO using Data Augmentation and Semantic ModellingThe document describes how to extract data from Fusion through data augmentation in FAW and then use it to build new subject areas . If your use case is The basic proced…Abhishek Bajpai -CEAL Team-Oracle 19 views 0 comments 2 points Started by Abhishek Bajpai -CEAL Team-Oracle Fusion Analytics Warehouse
-
Fusion Analytics Tech Tips: Creating a custom data model using the Semantic Model ExtensionsThere may be times when the many ready-to-use data models provided in Oracle Fusion Analytics Warehouse (FAW) don't fully cover the extent of the reporting you want to d…Abhishek Bajpai -CEAL Team-Oracle 22 views 0 comments 2 points Started by Abhishek Bajpai -CEAL Team-Oracle Fusion Analytics Warehouse
-
Creating Data Model Using SQL Querry is Causing Data Breach IssueDoes Anyone who has both HCM and ERP in same project have the concern if a user has access to create Data Models using SQL Querry?? That is, if a user account having acc…V P Aravind 51 views 2 comments 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server
-
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 195 views 2 comments 1 point Most recent by Abhishek Bajpai -CEAL Team-Oracle Fusion Analytics Warehouse
-
OTBI data model thought (BI Publisher) web service errorWe are trying to fetch the data displayed in an OTBI data model through an web service for further integrations. We use BI Publisher web services -> ReportServicesSoapBi…maria.stanciu 242 views 11 comments 0 points Most recent by User_47CVA Oracle Transactional Business Intelligence
-
4Allow Developers to write SQL and preview data on the same screenWhen creating an SQL Data Model, I have to write my SQL in the "Diagram" tab, close the window go into the "Data" tab to see a preview of the results. Realize the change…User_315WR 41 views 2 comments 4 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Business Intelligence
-
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 249 views 5 comments 0 points Most recent by SyedMustafaArshad Oracle Transactional Business Intelligence
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…maria.stanciu 115 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
How can restrict the data in reports?Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have one of the report called Leave Balance Report. It contains all empl…Malak 81 views 3 comments 0 points Most recent by Krithika Raghavan-Oracle Fusion Analytics Warehouse
-
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 287 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 105 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
View/Table details for Data SecuritySummary: Hi Everyone, We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table detai…Maruvada Sanat Kumar-Oracle 55 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 55 views 3 comments 0 points Most recent by Mike Burnett Oracle Transactional Business Intelligence
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 26 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Oracle Transactional Business Intelligence
-
How to fix an RTF report related error in OBIEESummary In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the error Content Hello Oracle Team, In OBIEE, …Jonathan Chan gmg 75 views 3 comments 0 points Most recent by Arghyo Banerjee -Oracle Oracle Transactional Business Intelligence
-
Table Documentation - Data Source: AuditViewDBContent Hi all - I cannot find documentation for the data source AuditViewDB. I have the documentation for the data source ApplicationDB_HCM (https://docs.oracle.com/en/…Prudence K 109 views 5 comments 0 points Most recent by User_B8VQC Oracle Transactional Business Intelligence
-
Row Count - Auditor RequestContent Hi all - is it possible to add a row count to our reports, so we know how many rows are expected in the final output? If I am understanding the tool correctly, t…Prudence K 45 views 2 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence
-
OAC - SaaS Data Replication Functionality CapacityContent Hi Team, is there any limitation to row count to be extracted via OAC - SAAS Data replication functionality. We are planning to bring data from Oracle SaaS Fin, …AnkitR Gupta 47 views 2 comments 0 points Most recent by AnkitR Gupta Oracle Transactional Business Intelligence
-
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 166 views 1 comment 0 points Most recent by Sahil Makhiza Oracle Transactional Business Intelligence
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 185 views 16 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
Meaning of Oracle table name with and without "_" at its end?Summary What is the difference between Oracle tables named with and without "_" at the end? Content Hello Oracle Community, 1) What's the difference between Oracle table…Jonathan Chan gmg 26 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
How to correctly script the "OR" function in Group Filter section in Data Model in OBIEE?Summary In OBIEE, an error was prompted when I was scripting the "OR" function in Group Filter section of the Data Model interface. Content Hello Oracle community, In OB…Jonathan Chan gmg 65 views 4 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
How to pick mulitple fields into table box when buidling report using data model?Summary How to pick mulitple fields into table box when buidling report using data model? Content Hello Oracle Community, When building report using data model, in the "…Jonathan Chan gmg 126 views 14 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
Can data model data be called out by infolets on Oracle Cloud/Fusion?Summary In addition to analysis data, can data model information be added to infolet on Oracle Cloud/Fusion? Content Hello Oracle Community, Is there anyway to post data…Jonathan Chan gmg 45 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
how to remove decimile from the chartSummary how to remove decimile from the chart Content Hi, In OTBI dashboards charts shows the values in fractions see the chart as attached, so how can we remove the fra…Farooq H Syed 55 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
Packages in BI publisherSummary Packages in BI publisher Content Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pa…Islam Abu Khamseh-76822 45 views 1 comment 0 points Most recent by rajArun Oracle Transactional Business Intelligence
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin View Content In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but …Jonathan Jackson-2093 25 views 1 comment 0 points Most recent by jcs Oracle Transactional Business Intelligence
-
Using Subject Area for Report: "Unable to retrieve metadata from data model"Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …Wendy Ware 25 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence
-
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 45 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence