Analyses
Discussion List
-
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBIContent Hi, Can someone please provide me working sample query f…Shalindra Singh 26 views 0 comments 1 point Started by Shalindra Singh General Transactional Reporting (OTBI) -
Any way to bypass the row LimitationSummary Bypass Row LimitationContent Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is ca…Robin Friedberg O'Connor 110 views 11 comments 1 point Most recent by Gustavo Erthal General Transactional Reporting (OTBI) -
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t…Natalie Andrek-27262 59 views 4 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI) -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the promptContent Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repor…Brenda Jacks-49721 95 views 1 comment 1 point Most recent by RichardChan General Transactional Reporting (OTBI)
-
Create a LDAP Data source for OTBISummary Need to be able to access LDAP folders from OTBIContent Hi, We have a need to verify the usernames in EPM to the LDAP account names. This is because we have inst…user13046722 39 views 1 comment 0 points Most recent by Jessie Jones General Transactional Reporting (OTBI)
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current BalancesContent Hello, Is anybody aware of a method in which we can view a colleag…Brad Hughes 49 views 1 comment 0 points Most recent by RyanPatrick General Transactional Reporting (OTBI) -
Hired Candidates from the Cleared ListContent Dear All Is there a way I can add a subquery in one the columns of the report to indicate a if the cleared candidate has been hired for another position ? Thank …Rafael Cano Vidal 6 views 0 comments 1 point Started by Rafael Cano Vidal General Transactional Reporting (OTBI)
-
How to add the number in BarChart in OTBISummary How to add the number in BarChart in OTBIContent I have created the Graph in OTBI, Pie chart and barchart but values is not showing on the charts . Like attached…Farooq Syed, CPA, PMP, CISA 36 views 4 comments 0 points Most recent by Krishnaraja Nelli-47394 General Transactional Reporting (OTBI) -
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem…Aaron Leggett 221 views 8 comments 1 point Most recent by Jatinder Tanda General Transactional Reporting (OTBI) -
OTBI - add a SQL column to a subject area analysisSummary Can you refer to a table using SQL and a subject area at the same time?Content Is it possible to add column to a subject area using SQL? I have tried editing the…Antony Hooper-29731 97 views 1 comment 0 points Most recent by venkata veeragoni General Transactional Reporting (OTBI)
-
Self-Defined Candidate Facts - Yellow BoxSummary How to create a self-defined candidate facts using UDFContent Hi Experts, Could someone please walk me through how to create a self-defined UDFs with embedded fo…Pofu Huang 11 views 3 comments 0 points Most recent by Pofu Huang General Transactional Reporting (OTBI)
-
Prompts OBIEE not working in OTBIContent I have created a simple new analysis in OBIEE for leavers and added a prompt so the user can run the analysis between termination dates. This works fine when ope…David Bean-24463 50 views 1 comment 1 point Most recent by Karthik Vinodkumar-76683 General Transactional Reporting (OTBI)
-
Oracle Essbase in the Cloud: A Mercer Advisor’s Success StorySummary Webinar on the successful implementation of Essbase in the Cloud at Mercer AdvisorsContent https://www.perficient.com/insights/webinars/on-demand-webinars/2017/o… -
Showing '0' for Null ValueSummary How do you show a 0 value in place of a blank value on an analysis?Content Hello, We want to show the total number of something on an analysis (in this case Lead…Stephanie Gott 94 views 12 comments 0 points Most recent by Stephanie Gott General Transactional Reporting (OTBI) -
Prefix - set effective date using SQL ExpresssionContent Hello - I'm hoping someone can help me with this please. I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the…Linda Stelling-61686 60 views 2 comments 0 points Most recent by Rick Brobbel General Transactional Reporting (OTBI)
-
Provide Link to Candidate Job Submission in OBIEE ReportSummary I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool.Content Is there a way to include a link to a candidate's job …Chris Shaver - HEB 15 views 4 comments 0 points Most recent by Chris Shaver - HEB General Transactional Reporting (OTBI) -
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 26 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
Day Name from DateSummary Need to get the name of the day of the week from the Creation DateContent Hello, I am using this function: DAYNAME("Service Request"."Creation Date") and it is n…Stephanie Gott 25 views 5 comments 0 points Most recent by GopiKAutomus General Transactional Reporting (OTBI)
-
BI/OTBI report location and last run date - is it possible?Summary BI/OTBI report location and last run date - is it possible?Content Hello I want to be able to extract a list of all OTBI and BI reports and their folder location…Helen Thomas-53877 60 views 2 comments 0 points Most recent by Helen Thomas-53877 General Transactional Reporting (OTBI)
-
Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLSummary Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLContent Hi All, We have a dashboard -Pipeline Time In Process which consists of both…Ramesh Nakka 13 views 0 comments 0 points Started by Ramesh Nakka General Transactional Reporting (OTBI) -
Column Properties InteractionSummary Primary Interaction = None but hyperlink still showing in the valueContent Hello, I have a report where I've set the "Primary Interaction" on the 'Value' to "Non…Stephanie Gott 25 views 6 comments 0 points Most recent by Stephanie Gott General Transactional Reporting (OTBI)
-
Phone screens completedSummary Looking to add the number of phone screens completed to reportContent I have a current report that I am needing to add the number of phone screens that have been…User_HZJPP 12 views 1 comment 0 points Most recent by Michael Scaduto General Transactional Reporting (OTBI) -
Case When for date fieldsSummary Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time"Content I'm trying to build a Case statement that shows If one date is…Stephanie Gott 35 views 2 comments 0 points Most recent by Stephanie Gott General Transactional Reporting (OTBI)
-
BI Mobile HD AppsSummary OTBI reports in BI Mobile AppContent We would like to view reports created in OTBI from within BI Mobile HD app. What steps need to be taken to have the OTBI cre…AnujSaxena-Oracle 16 views 0 comments 0 points Started by AnujSaxena-Oracle General Transactional Reporting (OTBI)
-
Prompt Dashboard for cross subject areasSummary Prompt Dashboard for cross subject areasContent Hello, I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in …Dario_DiFranceschi 48 views 2 comments 1 point Most recent by Jagadish Angadi-29558 General Transactional Reporting (OTBI)
-
Complex filters - grouping 3 filters togetherContent I want to create a complex filter which requires grouping 3 filters with another set of filters. I have played around clicking the AND / OR to get the combinatio…Shree Pawar 111 views 6 comments 1 point Most recent by User_8TDVH General Transactional Reporting (OTBI)
-
Dashboard Custom Print and Export design in 12CSummary Any resources that give detailed instructions on how to design a custom print layout?Content Hello, I have stumbled across a 'Custom Print and Export Layouts' fe…Stephanie Gott 18 views 0 comments 0 points Started by Stephanie Gott General Transactional Reporting (OTBI)
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …Abdalaziz Barham 88 views 1 comment 0 points Most recent by Abdalaziz Barham General Transactional Reporting (OTBI)
-
Table display issueSummary How do I expand the table results viewContent When I create an OTBI report sometimes the table does not fill the page (even with 2/3 columns) but instead creates…user10295792 30 views 6 comments 1 point Most recent by Vijaya Kumar-70229 General Transactional Reporting (OTBI) -
Purchase requistion Status analysisSummary Analysis for Purchase Requistions statusContent Hi, I need to developed OTBI analysis for Purchase Requisition with below information: PR number PR Amount Create…Farooq Syed, CPA, PMP, CISA 29 views 3 comments 2 points Most recent by Vijaya Kumar-70229 General Transactional Reporting (OTBI)