Analyses
Discussion List
-
OTBI Security HelpContent Hi All, We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, w…Aaron Leggett 57 views 1 comment 0 points Most recent by Suvankar Dasgupta General Transactional Reporting (OTBI) -
BI Cloud Extract IssueSummary BI Cloud Extract IssueContent Extract ran successfully in BI Cloud Connector Console but unable to view them in Universal Content management. As per MOS doc - Fu… -
Cell Splitting based on special characterSummary Split a field into two columns based on characterContent Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns inst…Kristen Magno 21 views 2 comments 0 points Most recent by Kim Welker General Transactional Reporting (OTBI)
-
Return Candidate Name only for Specific CSW Selection steps/statusesSummary How to modify my SQL statement to remove redundanciesContent Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pas…Kim Welker 32 views 11 comments 2 points Most recent by Rahul Thomas General Transactional Reporting (OTBI) -
Users information in reportSummary I need to create (or use one that exists) that will give me basic information on the usersContent Hi, I need to create (or use one that exists) that will give me…Mor Amsalem 28 views 2 comments 0 points Most recent by Mor Amsalem General Transactional Reporting (OTBI) -
Currency in reportsSummary When the users login with diffrante currency then $ the amount is correcet but the currency code is still $Content In user preferences you can define witch curre…Mor Amsalem 27 views 0 comments 0 points Started by Mor Amsalem General Transactional Reporting (OTBI)
-
Email prompt does not allow for quotation markSummary Email prompt does not allow for quotation markContent We have a report built in Performance that pulls in a manager's full reporting hierarchy (both direct and i…Andy French 13 views 3 comments 0 points Most recent by Andy French General Transactional Reporting (OTBI) -
Issue with Percentage in Pivot TableSummary Issue with Summarizing Percentages in Pivot TablesContent I have a calculation for the fill rate based upon hired vs target. This is working fine in the details,…Ellen Manthei 39 views 0 comments 0 points Started by Ellen Manthei General Transactional Reporting (OTBI) -
Sorting alphabetically on nameSummary Sorting alphabetically on nameContent Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special letter…Maria Lieberman 23 views 5 comments 2 points Most recent by Rachel Martorelli-Oracle General Transactional Reporting (OTBI)
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 32 views 3 comments 0 points Most recent by Neil Peacock General Transactional Reporting (OTBI)
-
StatsSummary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…Peter Kirwan 24 views 1 comment 0 points Most recent by Chris Dabel General Transactional Reporting (OTBI)
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…Aaron Leggett 42 views 2 comments 0 points Most recent by Aaron Leggett General Transactional Reporting (OTBI)
-
Terminated Line ManagerSummary Report on where an employee's Line Manager is TerminatedContent does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues i…Peter Kirwan 29 views 2 comments 0 points Most recent by Peter Kirwan General Transactional Reporting (OTBI)
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontalContent I need to change the layout of a sectioned Table from vertical to horizontal. I…Andy French 70 views 1 comment 0 points Most recent by JF Carpentier-23261 General Transactional Reporting (OTBI)
-
Sorting In a Pivot Table OBISummary How to sort on a measure within Pivot TableContent I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I c…
-
Adding new columns to a single view changes all viewsSummary Adding new columns to a single view changes all viewsContent Is there a setting that will stop this from happening? I have several reports that have multiple vie…Dawn Phipps 27 views 3 comments 0 points Most recent by Dawn Phipps General Transactional Reporting (OTBI) -
Placement of Dashboard Report LinksSummary Can the Dashboard Report Links (e.g., edit, export, add to briefing book, etc.) be moved from the bottom of the page to the top?Content Is it possible to move th…Andy French 44 views 2 comments 0 points Most recent by Maria Lieberman General Transactional Reporting (OTBI)
-
HELP! Deletion, Merging and Incomplete SubmissionsSummary Any advise?Content Hi, We configured the system to hide incomplete submissions in recruiting and also perform data auto-deletion tasks/merging. We however notice… -
Help with a formula to capture # of career site postingsSummary Help with a formula to capture # of career site postingsContent Hello - I'm trying to create a few formulas to determine the following - How many requisitions ha…Maria Lieberman 19 views 1 comment 0 points Most recent by Sachin Sirohi General Transactional Reporting (OTBI)
-
Days between Step/StatusSummary OBI Days between Step/StatusContent I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status. …Alexis Rivers 48 views 1 comment 0 points Most recent by Kellyzuckerman General Transactional Reporting (OTBI)
-
Issue in OBI Catalog with folders getting moved automaticallyContent Hi, We have seen a strange behaviour where sometimes any random folder in the catalog gets moved under another folder. This happens randomly without any intentio…Kiran Shenvi 21 views 4 comments 0 points Most recent by shashi polala General Transactional Reporting (OTBI) -
Adding Filters to promptsSummary For you gurus out there, please I need a helpContent I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that are…
-
Release 11 view issuesSummary Two views are not the same in Release 11 as they were in Release 10Content We recently were upgraded to R11 and I found two BI Answer views that are not the same…Shawn McDonald 24 views 0 comments 0 points Started by Shawn McDonald General Transactional Reporting (OTBI) -
Able to change "Searching..." text?Summary Able to change "Searching..." text?Content Are we able to change the text on the "Searching..." pop up that appears when an analysis is loading? See attached. We…Andy French 12 views 0 comments 0 points Started by Andy French General Transactional Reporting (OTBI)
-
Max Export into Excel 2007 from OBISummary Wondering what the max export is into Excel 2007Content Hello, Does anyone know what the max number of rows you can export from OBI into Excel 2007? I have heard…Kellyzuckerman 26 views 4 comments 0 points Most recent by Kellyzuckerman General Transactional Reporting (OTBI) -
Max Unposting DateSummary Using max to provide latest unposting dateContent I am using Max to provide the latest unposting date for requisitions. This is causing the number of completed s…Alexis Rivers 33 views 0 comments 0 points Started by Alexis Rivers General Transactional Reporting (OTBI)
-
Having nested criteria or pairing fields within your filtersSummary Missing candidates that have multiple hires in the time frameContent Having a hard time correcting the current filters that limit the output to the most recent '…Cassandra Kurth 12 views 0 comments 0 points Started by Cassandra Kurth General Transactional Reporting (OTBI)
-
Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..Anish Goswami 38 views 8 comments 0 points Most recent by Kiran Shenvi General Transactional Reporting (OTBI)
-
Deep Linking URLSummary Open a candidate submissionContent Hello, I am trying to create an analysis with a deep linking URL to the candidate's submission. I am trying to use the URL pro…Alice Kim, SPHR-SCP 43 views 0 comments 1 point Started by Alice Kim, SPHR-SCP General Transactional Reporting (OTBI)