Popular Tags
- OTBI 1,371
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 897
- BI Publisher 792
- Analysis 655
- Administration 542
- Oracle Fusion Analytics 536
- OBIEE 415
- BI Publisher Data Models 324
- Analytics 310
- OAC 276
- Answers 259
- Security 254
- Analyses 251
- Developers 235
- HCM 225
- BIP 215
- Data Modelling and Datasets 209
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…Stefan pettersson 81 views 3 comments 0 points Most recent by Stefan pettersson Oracle Transactional Business Intelligence -
How to build an Analysis on OTBI to show cumulative totals over time?Summary: What is the function (or any way) of an Analysis report that shows cumulative totals over time, in the same way as it is displayed on attached file? For example…Wilromar Benevides 353 views 4 comments 0 points Most recent by Wilromar Benevides Oracle Transactional Business Intelligence
-
How to report Number of Performance Goals by employees (then broken up by categories) using OTBI ?Summary: Dear peers, My customer wants to report the no. of performance goals every employee has in their Goal Plan; Total and Category-wise (There are 13 custom categor…Shubham Shree 102 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
How to create formula to show PR where all lines have processed requisition line flag as yesSummary: We are trying to create an analysis to display those particular requisitions where all lines are processed successfully into PO Content (required): Need help to…JITHU JOSE 71 views 4 comments 0 points Most recent by JITHU JOSE Oracle Transactional Business Intelligence
-
Facing Issue in calculating percentage for an Analysis in OTBISummary: We are trying to create a custom analysis to calculate the month wise percentage of delivered amount being early received including tolerances. We have calculat…Palak Karma 392 views 7 comments 0 points Most recent by Palak Karma Oracle Transactional Business Intelligence
-
Issue with deep link Functionality in OTBI AnalysesSummary: We need a functionality within OTBI Analyses where we click on a particular graph of the analysis, it redirects to the SaaS Page which has particular set of rec…Palak Karma 302 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…JITHU JOSE 81 views 2 comments 0 points Most recent by JITHU JOSE Oracle Transactional Business Intelligence
-
Issue while creating analysis using Max and Avg functions in new calculated measure.Summary: We are trying to create a analysis for sales order processing lead time, but we are facing issue as the new calculated measure using avg function is not giving …JITHU JOSE 121 views 3 comments 0 points Most recent by Jahnavi-Oracle Oracle Transactional Business Intelligence
-
How to see what caused 'Agent Completed with Warnings'?Summary: How can one see what caused 'Agent Completed with Warnings' message. Content (required): Version (include the version you are using, if applicable): 22D (11.13.…Tom Buechler 301 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Populating OTBI Reports onto My DashboardSummary: I have created a number of OTBI dashboards and analyses that I would like to appear on the My Dashboard section of Oracle Cloud Fusion Applications. Content (re…rabarthel 465 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
when we scheduled the OTBI report in excel format recipient get missed(reduced file) countSummary: Hi Team, when we scheduled the OTBI report in excel format recipient get missed count like in report total count 38855 rows but after shcedule it will reduced .…AjayKumar Maddipati 81 views 4 comments 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
Why time stamp is empty on OTBI reportsSummary: Content (required): Hello: Does anyone know how to get the time stamp to populate for an event date? We have custom format selected of M/d/yy HH.mm.ss, and we g…55Chevy 232 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
We have Connect Conversation Questionnaire below in Performance mgmt how can we extract the reportSummary: we have Connect Conversation Questionnaire below in Performance mgmt how can we extract the report in below questions and answers filled by emps. Performance >>…AjayKumar Maddipati 71 views 1 comment 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
OTBI report shows records in two linesDear , I created on otbi report and its data is fine but issue its split data in two lines when i pivot why its happening For example i have leaves work from anywhere in…Mirza_Adeel 204 views 7 comments 0 points Most recent by Mirza_Adeel Oracle Transactional Business Intelligence
-
Can we report on the columns and subject areas used in an OTBI report?Summary: As 22d is removing the Workforce Learning - Learning Management Real Time subject area, I wondered if there was a report that could tell us which of our reports…Dawn Cawston - CPS 71 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 41 views 4 comments 0 points Most recent by Andrew_Schmitz Oracle Transactional Business Intelligence
-
OTBI Analysis - Getting DFF meaning instead of the valueContent Hi, I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the sy…Tmolina-Oracle 466 views 5 comments 0 points Most recent by Yves Chassein Oracle Transactional Business Intelligence
-
Which Subject area & folder to use to extract Manager Hierarchy fields (upto level 10) correctly?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 141 views 4 comments 0 points Most recent by Abhishek Bagh Oracle Transactional Business Intelligence
-
is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?Summary: Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person …Abhishek Bagh 81 views 4 comments 0 points Most recent by Abhishek Bagh Oracle Transactional Business Intelligence
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 351 views 7 comments 0 points Most recent by Swapnil Kashid Oracle Transactional Business Intelligence