Popular Tags
- OTBI 1,509
- Reporting 1,428
- FDI 1,330
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 616
- Administration 568
- Fusion HCM Analytics 463
- Analytics 463
- Fusion ERP Analytics 462
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 314
- Security 309
- Fusion Data Intelligence 299
- HCM 297
- Fusion Data Intelligence FDI 280
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
Report Output
Discussion List
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTH Content In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norm…Stephane Cote-Oracle 25 views 0 comments 0 points Most recent by Stephane Cote-Oracle Oracle Transactional Business Intelligence Forum -
Bursting ReportSummary A report on Probation which bursts out to Line Managers Content is there any example reports which look at Probation Period? Also sample reports for Bursting?Peter Kirwan 52 views 1 comment 0 points Most recent by Sowdhaminya Murugan Oracle Transactional Business Intelligence Forum
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all data Content Any suggestions on how to get the subtotals added to this report? Example below, want totals f…Michelle Slobig Rotsolk 335 views 1 comment 0 points Most recent by Manoj Madhavan Oracle Transactional Business Intelligence Forum
-
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where condition Content Hi, While adding this line in the existing query the below error occurs. Line used in where…NIRMAL KUMAR L 52 views 0 comments 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Forum
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sql Content Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to…NIRMAL KUMAR L 1.4K views 1 comment 0 points Most recent by Manoj.Gupta Oracle Transactional Business Intelligence Forum
-
Conditional FormattingSummary Conitional Formatting is not working properly Content I have created a report to help our teams identify at risk background checks. The report uses OBI condition…Tristan Hindes-55332 53 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Help with DashboardsSummary Help with Dashboards Content I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test t…Kelly Geldof 22 views 1 comment 0 points Most recent by Clifford-Barrington Trett Oracle Transactional Business Intelligence Forum
-
Embedded Reporting/BI PublisherSummary audit report using offer fields Content Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for th…Alice Kim, SPHR-SCP 133 views 5 comments 0 points Most recent by Alice Kim, SPHR-SCP Oracle Transactional Business Intelligence Forum
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal…Giuseppe 1234 328 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
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 co…Tristan Hindes-14952 131 views 3 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence Forum
-
Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI export Content When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day…Matt M 112 views 4 comments 0 points Most recent by Matt M Oracle Transactional Business Intelligence Forum
-
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 …Tim Welsh 241 views 0 comments 0 points Most recent by Tim Welsh Oracle Transactional Business Intelligence Forum
-
Concatenate non text fieldsSummary Function Concat does not support non-text types. Content Is there a way to concatenate non-text fields? I would like to concatenate Req id and Candidate id to cr…Lin Tiedemann 205 views 4 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence Forum
-
Email prompt does not allow for quotation markSummary Email prompt does not allow for quotation mark Content We have a report built in Performance that pulls in a manager's full reporting hierarchy (both direct and …Andy French 73 views 3 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence Forum
-
Issue with Percentage in Pivot TableSummary Issue with Summarizing Percentages in Pivot Tables Content I have a calculation for the fill rate based upon hired vs target. This is working fine in the details…Ellen Manthei 32 views 0 comments 0 points Most recent by Ellen Manthei Oracle Transactional Business Intelligence Forum
-
StatsSummary Stat Report Content 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 wou…Peter Kirwan 33 views 1 comment 0 points Most recent by Chris Dabel Oracle Transactional Business Intelligence Forum
-
Duplicates appearing - need true dataSummary I have one field that is pulling different dates - need true data Content Hi Group, I'm having an issue getting a single date to pull in correctly in OBI. The fi…Erin Caby-47393 62 views 3 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence Forum
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontal Content I need to change the layout of a sectioned Table from vertical to horizontal. …Andy French 46 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence Forum
-
Sorting In a Pivot Table OBISummary How to sort on a measure within Pivot Table Content I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I …MarkS 64 views 2 comments 0 points Most recent by MarkS Oracle Transactional Business Intelligence Forum
-
Adding new columns to a single view changes all viewsSummary Adding new columns to a single view changes all views Content Is there a setting that will stop this from happening? I have several reports that have multiple vi…Dawn Phipps 75 views 3 comments 0 points Most recent by Dawn Phipps Oracle Transactional Business Intelligence Forum