Customizing Reports
Discussion List
-
Audit History to access changes made in BIP Data ModelSummary Require table or methods to find out changes done in BIP Data ModelContent Hi, We have encountered an issue recently where the data model query were updated by s…User_O1YC5 36 views 2 comments 0 points Most recent by Joel Acha General Transactional Reporting (OTBI) -
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…Kristy Bartnes 17 views 8 comments 3 points Most recent by Marybeth Snodgrass General Transactional Reporting (OTBI) -
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI AnalysisContent Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub quer…Praveen Kumar-146357 77 views 3 comments 4 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
Formula to capture last 7 days of dataSummary Formula to capture last 7 days of dataContent Hello, We are looking to capture requisition in specific statuses (Approved, To Be Approved, Draft, Sourcing and Fi…Nicole Hicks 44 views 7 comments 1 point Most recent by rajArun General Transactional Reporting (OTBI)
-
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patchContent New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be…Senthilrajan V 19 views 0 comments 0 points Started by Senthilrajan V General Transactional Reporting (OTBI) -
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releasesContent Creating Reports with Direct Database Query in Oracle Fusi…Senthilrajan V 155 views 9 comments 2 points Most recent by Senthilrajan V 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)
-
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) -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.Content I am searchi…Tim Welsh 59 views 8 comments 0 points Most recent by rajArun 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)
-
NACHA format filesSummary NACHA format filesContent Can we create NACHA format files using BI Publisher template builder in Cloud? Any documentation for creating the same will be helpful.…Swathi gogula-80876 24 views 0 comments 0 points Started by Swathi gogula-80876 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) -
archive unarchive and oracle bi admin roleSummary archive unarchive and oracle bi admin roleContent Hi, in Oracle BI is it possible to get archive/unarchive functionality and not be an oracle bi admin? Our tech …Alex Andreadis-70445 69 views 4 comments 1 point Most recent by Alex Andreadis-70445 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)
-
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr…user11018780 51 views 0 comments 0 points Started by user11018780 General Transactional Reporting (OTBI)
-
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr…Vijaya Kumar-70229 47 views 0 comments 0 points Started by Vijaya Kumar-70229 General Transactional Reporting (OTBI)
-
Candidate Drop off ReportSummary a report that gives details on when a candidate drops off at an application and doesn't complete/submitContent We have been working on building a candidate drop …Iqra Khan 17 views 2 comments 0 points Most recent by Iqra Khan General Transactional Reporting (OTBI)
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTHContent In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norma…Stephane Cote-Oracle 23 views 0 comments 1 point Started by Stephane Cote-Oracle General Transactional Reporting (OTBI)
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…Aaron Leggett 42 views 2 comments 0 points Most recent by Manoj Madhavan General Transactional Reporting (OTBI) -
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard?Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull …Brenda Jacks-49721 48 views 5 comments 0 points Most recent by Sandor Banfi-52443 General Transactional Reporting (OTBI)
-
Conditional FormattingSummary Conitional Formatting is not working properlyContent I have created a report to help our teams identify at risk background checks. The report uses OBI conditiona…Tristan Hindes-55332 24 views 2 comments 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) -
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 24 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 25 views 2 comments 0 points Most recent by Marianne Kromwijk General Transactional Reporting (OTBI)
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI AnalysisContent I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less th…Brenda Jacks-49721 78 views 1 comment 1 point Most recent by rashid ramzan-45341 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) -
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…
-
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)