Reports
Discussion List
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 17 views 0 comments 1 point Started by Aaron Leggett General Transactional Reporting (OTBI) -
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel.Content Hi, I have one report which is automatically scheduled to be se…Christopher Finnerty-57466 25 views 2 comments 0 points Most recent by Christopher Finnerty-57466 General Transactional Reporting (OTBI) -
Adding two measures not workingSummary Adding two measures not workingContent I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within th…Robin Friedberg O'Connor 23 views 1 comment 0 points Most recent by RichardChan General Transactional Reporting (OTBI) -
Help with DashboardsSummary Help with DashboardsContent I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test to…Kelly Geldof 65 views 1 comment 0 points Most recent by Clifford-Barrington Trett 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 78 views 4 comments 0 points Most recent by Richard Beet General Transactional Reporting (OTBI)
-
Embedded Reporting/BI PublisherSummary audit report using offer fieldsContent Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for the…Alice Kim, SPHR-SCP 49 views 5 comments 1 point Most recent by Alice Kim, SPHR-SCP General Transactional Reporting (OTBI) -
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variableContent Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI analy…Giuseppe 1234 72 views 2 comments 1 point Most recent by RichardChan General Transactional Reporting (OTBI)
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Areakrishiveth 19 views 1 comment 1 point Most recent by krishiveth General Transactional Reporting (OTBI) -
Two Pivot Tables with Different ValuesContent Hi I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type co…Aaron Leggett 25 views 0 comments 0 points Started by Aaron Leggett General Transactional Reporting (OTBI)
-
How to adjust 1000 notation within a BI Publisher graphContent Hello, We would like to adjust the y axis of a chart we made so that the 1000 counts are not seperated with a comma. Where can we adjust this formatting? See att…Marianne Kromwijk 26 views 2 comments 0 points Most recent by Marianne Kromwijk General Transactional Reporting (OTBI)
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank detailsContent how do I create a audit report for employees bank details. This needs to show …Peter Kirwan 74 views 1 comment 0 points Most recent by User_6T5YF General Transactional Reporting (OTBI)
-
Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t…Aaron Leggett 25 views 1 comment 0 points Most recent by Satish Kumar-21650 General Transactional Reporting (OTBI)
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…Peter Kirwan 57 views 4 comments 1 point Most recent by Ramesh Nakka General Transactional Reporting (OTBI)
-
Exporting to Excel & Word WrapSummary I want cells with longer text to wrap automatically when I export an analysis to excel 2010.Content I have a built an analysis that pulls in requisition user com…Tristan Hindes-14952 27 views 3 comments 1 point Most recent by Ramesh Nakka General Transactional Reporting (OTBI) -
Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI exportContent When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day …
-
Concatenating Multiple Columns with Commas and SpacesSummary Trying to concatenate multiple columns in OBI Recruiting LegacyContent Hello, I'm trying to concatenate multiple columns with spaces and commas in OBI Recruiting…MarkS 107 views 7 comments 1 point Most recent by Rachel Martorelli-Oracle General Transactional Reporting (OTBI)
-
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 58 views 1 comment 0 points Most recent by Suvankar Dasgupta General Transactional Reporting (OTBI)
-
Adding subtotal breaks into a BI Publisher table reportSummary How do I add subtotal breaks into BI Publisher report?Content In an Analysis created with subject areas it's easy to add subtotals by going into the view under C… -
Oracle Data WarehouseContent Hi In order to utilize the full capability of Oracle Reporting (OTBI), do we need to purchase the Data Warehouse? We are currently under the impression that we a…Aaron Leggett 33 views 3 comments 2 points Most recent by Antony Hooper-29731 General Transactional Reporting (OTBI)
-
Audit Related: Last Logon SessionSummary Last LogOn Session: Looking for a audit related report that shows last time accessing OracleContent I am able to query HCM related tables (such as per_users) to …Jason Schwartz 52 views 1 comment 1 point Most recent by Jason Schwartz 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 40 views 0 comments 0 points Started by Ellen Manthei 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 33 views 3 comments 0 points Most recent by Neil Peacock General Transactional Reporting (OTBI)
-
Format prompt selectionsSummary Add specific formatting to prompted selectionsContent Is there a way to format the selections that show for prompts? For instance i need to have a prompt that fo…User_EQ8R5 29 views 4 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
Using Subject Area for Report: "Unable to retrieve metadata from data model"Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …Wendy Ware 42 views 2 comments 0 points Most recent by Wendy Ware 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 43 views 2 comments 0 points Most recent by Aaron Leggett General Transactional Reporting (OTBI)
-
Link to DashboardSummary Looking to provide a direct link to our Recruiting Dashboard for users not logged inContent I'm trying to create a link to our Recruiting Dashboard to be include…Andy French 72 views 2 comments 0 points Most recent by Andy French General Transactional Reporting (OTBI)