Popular Tags
- OTBI 1,507
- Reporting 1,423
- FDI 1,302
- Fusion AI Data Platform 1,055
- Analysis and Data Visualization 1,015
- BI Publisher 900
- Analysis 699
- Oracle Fusion Analytics 636
- OAC 590
- Administration 565
- Analytics 454
- Fusion HCM Analytics 449
- Fusion ERP Analytics 447
- OBIEE 444
- BI Publisher Data Models 371
- Security 305
- Oracle Analytics Cloud 300
- HCM 296
- Fusion Data Intelligence 285
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Fusion Data Intelligence FDI 245
- Data Modelling and Datasets 238
Analysis
Discussion List
-
HCM | SQL query to get details of the employees belonging to departments below the selected departmeContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
Which FAW table stores indirect Reportees data?I am looking for a table/column in FAW that stores the data for indirect reportees of a manager. dwc_manager_dn_dh_tbl table stores the data for direct reportees only (i…Dinky Dudeja 101 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion Data Intelligence Forum -
Can I use BVT for regression testing of dashboards/analysis in OASContent Hi, We're using Oracle Analytics Server(OAS) for PO reporting. I'm trying to validate the dashboards and analysis through regression testing in both the cases of…
-
Newly Created Order Management Line and Header EFF not available in OTBI Subject AreaNew Order Management Extensible Flexfields created with BI enabled flag checked. Flexfield deployed. ESS Job - Publish Extensible Flexfield Attributes successfully compl…Swagatam 42 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
Unable to fetch dynamic data from MS SQL --> OAC --> ADW(APEX)Content Dear team, We are trying to migrate dynamic data from MS SQL server to OAC and then from OAC to ADW through data flows, but we are able to migrate only static da…
-
8Excel & CSV Export Date to Use the Correct Time ZoneCurrently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis a…
-
OTBI Analysis Subject Area to Extract Employee Data for Customer CreationWhat subject area(s) can be used to extract a list of Employees created in HCM who have not yet been setup as Customers in Receivables? Tried exploring the Suppliers and…Francine Gemora 32 views 0 comments 0 points Most recent by Francine Gemora Oracle Transactional Business Intelligence Forum
-
6Create a Recommended Assignments subject area (was add to existing subject area)Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): JP Morgan Chase Description (Required…Jamie Leslie 91 views 3 comments 6 points Most recent by Chaitanya__K Oracle Transactional Business Intelligence Idea Lab
-
3Restrict the display of information from a custom report to specific users through data access.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Aseguradora Aserta, S.A. de C.V. Grup…Fernando Ch 411 views 1 comment 3 points Most recent by Balasubramanian Oracle Transactional Business Intelligence Idea Lab
-
3Customer Audit Report - Extension RequestOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Johnson Controls Inc Description (Req…Showkath Athif 33 views 1 comment 3 points Most recent by User_YFX37 Oracle Transactional Business Intelligence Idea Lab
-
4OTBI Subject Areas missing Grade Ladder / Grade Step ValuesOrganization Name WM MORRISON SUPERMARKETS PLC Description Seeded metric value dimensions in OTBI Compensation - Salary Details and Workforce Management - Grade Rates su…User_2RD6B 262 views 7 comments 4 points Most recent by Gail Langendorf-Oracle Oracle Transactional Business Intelligence Idea Lab
-
8UI for Logical SQLDescription Logical SQL is a powerful tool that we can use to help us join subject areas that might not otherwise return useful data using the standard cross join analys…Gail Langendorf-Oracle 602 views 17 comments 8 points Most recent by MaartenDIF Oracle Transactional Business Intelligence Idea Lab
-
Conversion rate and Conversion date not populating - Budgetary Control - Transactions Real TimeI am trying to create a analysis using 'Budgetary Control - Transactions Real Time' subject area. Where I suppose to display transaction conversion rate and conversion d…Thanigainathan R 22 views 0 comments 0 points Most recent by Thanigainathan R Oracle Transactional Business Intelligence Forum
-
1Report link in test instance gets redirected to production instance.Description Request Oracle to provide Location Alias functionality which helps to enable actions to refer to a location alias rather than a fixed URL as Setting up alias…melanie antoine 112 views 2 comments 1 point Most recent by Gayatri Chappalli-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Feature Friday: Constraining Filter Values in Oracle AnalyticsThis video show how to use the parameter binding functionality to constrain the list of values on a filter within Oracle Analytics data visualization. In Oracle Analytic…Brendan J. Doyle-Oracle 11 views 0 comments 5 points Most recent by Brendan J. Doyle-Oracle Oracle Analytics Forum -
7Integrated LLM Chatbot within OACIs Oracle planning to introduce an embedded OAC chatbot for querying ADW and EBS data? While Oracle's partnership with Cohere focuses on fine-tuned chatbots for propriet…Toby Culler 452 views 8 comments 7 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Idea Lab -
Workforce Management - Work Relationship Real Time: filter by ActionSummary: To find Action field for hire/rehire etc from the subject area or similar: Workforce Management - Work Relationship Real Time Content (required): I am having is…MDSchoonover-Oracle 21 views 1 comment 0 points Most recent by Patrick_Midd Oracle Transactional Business Intelligence Forum
-
Lookup the value from another column?Hi, Is there a way through calculation that will lookup the value from another column? For example, I want to add a new column that if China Region Part is present in Ot…JobDeLuna 141 views 1 comment 0 points Most recent by JoseP-Oracle Oracle Fusion Data Intelligence Forum -
How to display Customer Account Class lookup meanings instead of codes in OTBI?Hello, In the subject area Receivables - Customer Real Time, we need to have the Customer Account Class list of values available for our analysis, as they appaear on UI,…Olivier Dupret 80 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence Forum
-
Export OTBI Analysis Criteria in a flat fileWe need to do an impact analysis on certain work structure and organization change in all integration and reports. We have some 1000 OTBI reports to analyze the impact o…Akash Kiran Jana 36 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence Forum