Popular Tags
- OTBI 1,451
- Reporting 1,395
- FDI 1,132
- Analysis and Data Visualization 988
- BI Publisher 861
- Analysis 683
- Oracle Fusion Analytics 595
- Administration 555
- OAC 470
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 359
- Security 296
- HCM 271
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 211
- ERP Analytics Content 210
- Oracle Analytics Cloud 209
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analysis
Discussion List
-
Build a OTBI analysis using 2 subject areas but results is giving blank table.I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User Sy…Sourav Bose 866 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
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 20.5K 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 80 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 113 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 37 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 66 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 140 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 33 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 90 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 418 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 31 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 236 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 482 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 24 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 67 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 14 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 416 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 27 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 27 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence