Analyses
Discussion List
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…Dilpreet Kaur 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Why does the table edit page return results but the results page error?Summary: I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, i…Dawn Cawston - CPS 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
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 21 views 1 comment 0 points Most recent by Maruvada Sanat Kumar-Oracle General Transactional Reporting (OTBI)
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisionsContent Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision …Mr H 22 views 8 comments 1 point Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
How can I turn an analysis already created in a report? and put the information in a templateSummary: I created an analysis using the correct columns and some prompts, so what I want now is from the analysis create a report which has a template. Content (require…
-
Users are unable to create new Analysis Reports in the Transactional Business Intelligence windowSummary: Content (required): Users are not able to see any option in the "New" tab in Transactional Business Intelligence window to create OTBI reports (Analysis/Data Mo…Dian Minshan 1 view 4 comments 0 points Most recent by Dian Minshan General Transactional Reporting (OTBI) -
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 1 view 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 12 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] 1 view 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 11 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 15 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 52 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)