Analyses
Discussion List
-
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 51 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
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 21 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
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 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
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 51 views 10 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
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 21 views 9 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
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: ****-XX-XXXX (112-10-1234) TI…satya_nvs 21 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)
-
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 31 views 3 comments 0 points Most recent by Stefan pettersson General Transactional Reporting (OTBI)
-
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 11 views 4 comments 0 points Most recent by Wilromar Benevides General Transactional Reporting (OTBI)
-
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 21 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
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 21 views 4 comments 0 points Most recent by JITHU JOSE General Transactional Reporting (OTBI)
-
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 31 views 7 comments 0 points Most recent by Palak Karma General Transactional Reporting (OTBI)
-
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 31 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
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 11 views 2 comments 0 points Most recent by JITHU JOSE General Transactional Reporting (OTBI)
-
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 11 views 3 comments 0 points Most recent by Jahnavi-Oracle General Transactional Reporting (OTBI)
-
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 11 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
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 21 views 3 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI)
-
Matrix Manager field not showing up values as recorded in myHRSummary: When I try to include Manager Type field into the report & look at options (for Matrix Manager) - don't see Matrix Manager option to pick. Can you let me know h…
-
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 21 views 4 comments 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI) -
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 11 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
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 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…Jessie Gee 21 views 1 comment 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace -
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 21 views 7 comments 0 points Most recent by Mirza_Adeel General Transactional Reporting (OTBI)
-
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 41 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
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 5.7K views 14 comments 11 points Most recent by LCann-Oracle General Transactional Reporting (OTBI)
-
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 21 views 5 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
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 1 view 4 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI) -
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…Richard Beet 157 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
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 87 views 5 comments 0 points Most recent by Yves Chassein General Transactional Reporting (OTBI)
-
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 11 views 4 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)