Popular Tags
- OTBI 1,373
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 898
- BI Publisher 792
- Analysis 655
- Administration 543
- Oracle Fusion Analytics 537
- OBIEE 417
- BI Publisher Data Models 325
- Analytics 311
- OAC 278
- Answers 259
- Security 255
- Analyses 251
- Developers 235
- HCM 225
- BIP 216
- Data Modelling and Datasets 209
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting
Discussion List
-
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…Aaron Leggett 71 views 2 comments 0 points Most recent by Brett-28437 Oracle Transactional Business Intelligence -
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 s…3487945 99 views 2 comments 0 points Most recent by 3487945 Oracle Transactional Business Intelligence
-
Adding two measures not workingSummary Adding two measures not working Content I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within t…Robin Friedberg O'Connor 31 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
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 11 views 1 comment 0 points Most recent by Clifford-Barrington Trett Oracle Transactional Business Intelligence
-
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 272 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
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 21 views 1 comment 0 points Most recent by krishiveth Oracle Transactional Business Intelligence
-
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 41 views 2 comments 0 points Most recent by Marianne Kromwijk Oracle Transactional Business Intelligence
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank details Content how do I create a audit report for employees bank details. This needs to show…Peter Kirwan 41 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence
-
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 41 views 1 comment 0 points Most recent by Satish Kumar-21650 Oracle Transactional Business Intelligence
-
report on user account details - Role NamesSummary SQL for reporting on employees roles Content Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAM…Peter Kirwan 214 views 4 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence
-
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 81 views 4 comments 0 points Most recent by Matt M Oracle Transactional Business Intelligence
-
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.5K views 7 comments 0 points Most recent by Rachel Martorelli-Oracle Oracle Transactional Business Intelligence
-
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 41 views 1 comment 0 points Most recent by Suvankar Dasgupta Oracle Transactional Business Intelligence
-
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 71 views 3 comments 0 points Most recent by Antony Hooper-29731 Oracle Transactional Business Intelligence
-
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 31 views 2 comments 0 points Most recent by Mor Amsalem Oracle Transactional Business Intelligence
-
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 51 views 3 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence
-
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 71 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence
-
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 31 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence
-
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 61 views 2 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence
-
Link to DashboardSummary Looking to provide a direct link to our Recruiting Dashboard for users not logged in Content I'm trying to create a link to our Recruiting Dashboard to be includ…Andy French 41 views 2 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence