Welcome to the Oracle Analytics Community
Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
Analyses
Discussion List
-
Filter for a numerator only with a proportional metricWe have a dashboard including an analysis which computes a simple proportional metric (numerator/denominator) We want to have a dashboard filter available which only app…User12608135-Oracle 21 views 1 comment 0 points Most recent by Selvam Muthiah-Oracle Oracle Analytics Cloud and Server -
3Allow for control of each legend separately when using an Overlay chartOverlay charts are great because you can utilize multiple visualization types within one visual. However, the difficulty arises when using two separate charts, the legen…CarolineAnderson 17 views 0 comments 3 points Started by CarolineAnderson Fusion Analytics Warehouse Idea Lab -
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…rbeet88 352 views 7 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 131 views 2 comments 0 points Most recent by Kishore Ramkumar Oracle Transactional Business Intelligence
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best Practice Content This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 87 views 2 comments 0 points Most recent by SAHIL VASYANI Oracle Transactional Business Intelligence
-
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…Abhilash K - Deloitte USI 76 views 5 comments 0 points Most recent by Naresh313 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 117 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rashmi M-Oracle 2.6K views 20 comments 1 point Most recent by Sridhar_Rejeti_1423 Oracle Transactional Business Intelligence
-
Subject Area: Costing - New COGS and Gross Margin Details Real Time not giving any resultSummary: Analysis created using "Costing - New COGS and Gross Margin Details Real Time" subject area is not giving any output Content (required): I tried to create a sim…Dharmendra Shukla 70 views 2 comments 0 points Most recent by Yann Consolin-Oracle Oracle Transactional Business Intelligence
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisions Content Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision…Mr H 136 views 10 comments 0 points Most recent by User_259TP Oracle Transactional Business Intelligence
-
OTBI Report Performance IssueSummary: Customer facing performance issue with the reports developed using OTBI Content (required): Customer developed some of the reports using OTBI reporting tool whe…Praveen Gollu-Oracle 143 views 3 comments 0 points Most recent by Sahithi Kolasani-Oracle Oracle Transactional Business Intelligence
-
Can we change the color of Graphs?Summary: I've created a custom OTBI report in Graphical form as follows: Is it possible to change the cylinder "Employee with Goals Created" (Blue currently) to Green an…Shubham Shree 98 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 107 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBI Content Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bu…Nathan CCC 67 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 136 views 10 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Project Commitments Real Time - need current open PO balance by project OTBI analysisSummary: I am looking for a column for current open PO balance by project. I am currently using the "Project Costing - Commitments Real Time"."- Purchase Order Measures"…Alex Glose 126 views 9 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: XXX-XX-XXXX (112-10-1234) TIN…satya_nvs 79 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle Oracle Transactional Business Intelligence
-
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 67 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 114 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 26 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 47 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 123 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 117 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 46 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 39 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 147 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 69 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 46 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 118 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 56 views 1 comment 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence