Popular Tags
- OTBI 1,416
- Reporting 1,376
- FDI 1,012
- Analysis and Data Visualization 965
- BI Publisher 827
- Analysis 667
- Oracle Fusion Analytics 558
- Administration 554
- OBIEE 426
- OAC 372
- Analytics 360
- BI Publisher Data Models 338
- Security 279
- Answers 264
- Analyses 253
- HCM 245
- Developers 240
- BIP 236
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 190
- Report Output 181
- Customizing Reports 152
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
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…Arti P 19.3K views 3 comments 1 point Most recent by Harriet Huang-Oracle Oracle Analytics Cloud and Server -
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 65 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion Data Intelligence -
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…Dhamu 94 views 5 comments 0 points Most recent by GayathriAnand-Oracle Oracle Analytics Cloud and Server
-
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 16 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence -
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…Ankan Chanda 51 views 3 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
7Excel & 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…Neil M 1 122 views 0 comments 7 points Started by Neil M 1 Oracle Analytics Cloud and Server Idea Lab
-
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 Started by Francine Gemora Oracle Transactional Business Intelligence
-
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 71 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
-
2Customer 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 23 views 1 comment 2 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 205 views 7 comments 4 points Most recent by Gail Langendorf-Oracle Oracle Transactional Business Intelligence Idea Lab
-
7UI 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 402 views 17 comments 7 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 21 views 0 comments 0 points Started by Thanigainathan R Oracle Transactional Business Intelligence
-
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 61 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 Started by Brendan J. Doyle-Oracle Oracle Analytics Cloud and Server -
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 382 views 8 comments 7 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server 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
-
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… -
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 12 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence
-
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 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence