Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
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 52 views 1 comment 0 points Most recent by Satish Kumar-21650 Oracle Transactional Business Intelligence Forum -
Is there an Enhancement Request for BICS "exceeded configured maximum number of allowed input recordSummary Our BICS users get this error message when trying to look at years worth of data. Our users have to run multiple reports now in BICS to get the results. In OBIEE…Kim Lambrecht 21 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence Forum -
Pivot table in analysis - aging bucketsSummary how to create a pivot table with columns as calculated field Content i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a cal…new.bi 51 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence Forum -
how to set a pivot table as default view in analysisSummary how to set a pivot table as default view in analysis Content Hi is there a way to set a pivot table view when running an analysis. For some reasons the table vie…new.bi 71 views 2 comments 0 points Most recent by Ramesh Nakka 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 135 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 91 views 4 comments 0 points Most recent by Matt M Oracle Transactional Business Intelligence Forum -
Concatenating Multiple Columns with Commas and SpacesSummary Trying to concatenate multiple columns in OBI Recruiting Legacy Content Hello, I'm trying to concatenate multiple columns with spaces and commas in OBI Recruitin…MarkS 1.7K views 7 comments 0 points Most recent by Rachel Martorelli-Oracle Oracle Transactional Business Intelligence Forum -
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 43 views 1 comment 0 points Most recent by Suvankar Dasgupta Oracle Transactional Business Intelligence Forum -
BI Cloud Extract IssueSummary BI Cloud Extract Issue Content Extract ran successfully in BI Cloud Connector Console but unable to view them in Universal Content management. As per MOS doc - F…Sujith R 1 view 0 comments 0 points Most recent by Sujith R Oracle Transactional Business Intelligence Forum -
Cell Splitting based on special characterSummary Split a field into two columns based on character Content Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns ins…Kristen Magno 73 views 2 comments 0 points Most recent by Kim Welker Oracle Transactional Business Intelligence Forum -
Return Candidate Name only for Specific CSW Selection steps/statusesSummary How to modify my SQL statement to remove redundancies Content Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pa…Kim Welker 274 views 11 comments 0 points Most recent by Rahul Thomas Oracle Transactional Business Intelligence Forum -
Users information in reportSummary I need to create (or use one that exists) that will give me basic information on the users Content Hi, I need to create (or use one that exists) that will give m…Mor Amsalem 41 views 2 comments 0 points Most recent by Mor Amsalem Oracle Transactional Business Intelligence Forum -
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 curr…Mor Amsalem 31 views 0 comments 0 points Most recent by Mor Amsalem 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 74 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 31 views 0 comments 0 points Most recent by Ellen Manthei Oracle Transactional Business Intelligence Forum -
Sorting alphabetically on nameSummary Sorting alphabetically on name Content Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special lette…Maria Lieberman 76 views 5 comments 0 points Most recent by Rachel Martorelli-Oracle Oracle Transactional Business Intelligence Forum -
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 85 views 3 comments 0 points Most recent by Neil Peacock 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 32 views 1 comment 0 points Most recent by Chris Dabel Oracle Transactional Business Intelligence Forum -
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 74 views 2 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum -
Terminated Line ManagerSummary Report on where an employee's Line Manager is Terminated Content does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues …Peter Kirwan 52 views 2 comments 0 points Most recent by Peter Kirwan Oracle Transactional Business Intelligence Forum