Popular Tags
- OTBI 1,494
- Reporting 1,412
- FDI 1,274
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,012
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 569
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 439
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 292
- Oracle Analytics Cloud 281
- BIP 273
- Answers 266
- Analyses 257
- Fusion Data Intelligence 251
- Developers 248
- Data Modelling and Datasets 237
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting
Discussion List
-
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 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 21 views 1 comment 0 points Most recent by Clifford-Barrington Trett 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 321 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
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 31 views 1 comment 0 points Most recent by krishiveth Oracle Transactional Business Intelligence Forum
-
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 51 views 2 comments 0 points Most recent by Marianne Kromwijk Oracle Transactional Business Intelligence Forum
-
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 Forum
-
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 51 views 1 comment 0 points Most recent by Satish Kumar-21650 Oracle Transactional Business Intelligence Forum
-
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 233 views 4 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 101 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 41 views 1 comment 0 points Most recent by Suvankar Dasgupta 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
-
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 82 views 3 comments 0 points Most recent by Antony Hooper-29731 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 71 views 3 comments 0 points Most recent by Andy French 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 81 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence Forum
-
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 51 views 2 comments 0 points Most recent by Wendy Ware 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 71 views 2 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
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 51 views 2 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence Forum