Analyses
Discussion List
-
How do I bring back data greater than 6 months in Workforce Performance.Performance rating real timeSummary: We've been told that the link conversation performance only captured data from the last 6 months of the creation date. When we investigated the report there is … -
Does anyone have any suggestions to help me fix this issue?Summary: Dashboard performance issue Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up …Donna Fazio 1 view 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Briefing Book is not updated if we change the filter condition of AnalysisSummary: I have created a updateble briefing book based on an analysis, later we updated the analysis using filter condition as per requirement, but Briefing Book is not…Shubham Singh 1 view 4 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…Shubham Singh 1 view 0 comments 0 points Started by Shubham Singh General Transactional Reporting (OTBI)
-
Records dropping from basic analysis due to filter(s)Summary: Content (required): I have a very basic analysis in obiee that is pulling all active CWK. I need to include Home Email, however, when I filter, I lose ~25% of m…Karen Delaney 1 view 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…Darius Sunder 2 views 0 comments 0 points Started by Darius Sunder General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 24 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
Subject Area for Area of Responsibilities (AOR)Summary: I am looking to see if it is possible to build a custom Subject Area for the AOR I know that the AOR doesn't already exist in the Subject Areas but we have many…
-
Access denied error when user is Saving Current Customization of a DashboardSummary Access denied error when user is Saving Current Customization of a DashboardContent Hi All, we are facing a situation where when user is trying to save current c…Prashant Kumar - 2103 13 views 4 comments 0 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI) -
Fusion Dashboard AuditSummary: Fusion Dashboard Audit Content (required): Hi Team, We have requirement to extract the list of HCM dashboard name, dashboard path and how may user has ran the d…[Deleted User] 2 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
How to export all rows at one go in OTBI DashboardsSummary: Hi, We have Dashboard created with OTBI Report , when we export data by OTBI report 1440 records are exported. But when we export by Dashboard only 13 rows are …Nidhi Chhajed 11 views 3 comments 0 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
Missing fields in Subject Area Workforce Management - Worker Assignment Real Time?Summary: While attempting to add a field to the query, I found that I can't locate a couple of other fields that are already on the query Content (required): I am trying…
-
Need to find where the Certificate Number is in the Subject AreaSummary: Need to retrieve the Certificate Number under Licenses and Certifications for an employee "- All Profile Content"."Content Type" = 'Licenses and Certifications'…PamS 12 views 15 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
OTBI REPORTING CAPABILITYContent Can we do all sort of reporting with otbi or do we need bi publisher for customizable reportingChes-Oracle 30 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle General Transactional Reporting (OTBI)
-
Consolidate MultiList values into single fieldSummary We need to be able to see all of the multi list values against a sku in a single fieldContent We have several MultiList fields in our sku attributes. When report…ALASTAIR BURNS 13 views 0 comments 0 points Started by ALASTAIR BURNS General Transactional Reporting (OTBI)
-
OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleSummary OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleContent Hi, OTBI Analysis Prompts NOT SEEN when I run the report in supply ch…Sanjiiv Chavaan-158651 13 views 2 comments 0 points Most recent by Pulkit Kumar Jain General Transactional Reporting (OTBI)
-
Forward and Backward Button in BI AnswersContent Currently, the challenge is that you can't reset changes in BI Answers. Accordingly, a deleted field or a changed expression cannot be reset, but must be created…User_5HU7Y 16 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle General Transactional Reporting (OTBI) -
Custom column in OTBI analysis with case statement is not displaying data in graphSummary I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph d…Harpreet Shergill 23 views 4 comments 0 points Most recent by Harpreet Shergill General Transactional Reporting (OTBI)
-
OTBI session and repository variables full listContent Hi, could anyone provide the full list of session variables and repository variables available in OTBI Regards, AlbertoAlberto Boccato 22 views 6 comments 0 points Most recent by mgoswami General Transactional Reporting (OTBI) -
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest valueContent OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If differ…Srinivas Challa 77 views 3 comments 1 point Most recent by Matthias Ludewig General Transactional Reporting (OTBI)
-
Something off in SQL expression for criteriaSummary Trying to capture last month's dataContent The report functions with the expressions below; however, It doesn't seem to actually capture the last day of the prev…Cassandra Kurth 40 views 2 comments 1 point Most recent by User_UEHCK General Transactional Reporting (OTBI)
-
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In OutputContent The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for asso…User_EQ8R5 4 views 2 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 12 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI)
-
OAC/OBIEE and Hyperion Planning PBCS integration questions about RPD and about reportingContent We have two Oracle Cloud Services: OAC and Hyperion PBCS. My questions about general integration between these two. OBIEE and OAC works the same way, that is why…
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBIContent Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bus…Nathan CCC 17 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Calculating Percentage in OBIEE ReportSummary Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field.Content Hello, I am trying to calculate …MarkS 17 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle General Transactional Reporting (OTBI)
-
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 33 views 1 comment 0 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI)
-
set metric alert for dashboard or analysis (Fusion OTBI)Content Hello, I have a question regarding metric alert or email notification, let suppose there is KPI for total sales MTD (1M), I want to add a condition to alert the …Maram Abuzaid 13 views 2 comments 0 points Most recent by Maram Abuzaid General Transactional Reporting (OTBI)