Popular Tags
- Reporting 1,325
- OTBI 1,285
- Analysis and Data Visualization 847
- FDI 748
- BI Publisher 734
- Analysis 640
- Administration 526
- Oracle Fusion Analytics 503
- OBIEE 400
- BI Publisher Data Models 302
- Answers 258
- Analyses 248
- Analytics 247
- Developers 231
- Security 222
- Data Connectivity 202
- Data Modelling and Datasets 199
- HCM 198
- OAC 194
- ERP Analytics Content 182
- BIP 180
- Report Output 168
- BI Publisher Report Templates 160
- Agents 148
- Customizing Reports 132
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
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 -
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 12 views 1 comment 0 points Most recent by Clifford-Barrington Trett Oracle Transactional Business Intelligence
-
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 81 views 5 comments 0 points Most recent by Alice Kim, SPHR-SCP 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 22 views 1 comment 0 points Most recent by krishiveth Oracle Transactional Business Intelligence
-
Report that shows Agents and BI SchedulesSummary Report that shows Agents and BI Schedules Content We have multiple scheduled BI reports and Agents and we need a way to shift through them all. I know the BI sch…Shawn McDonald 205 views 3 comments 0 points Most recent by Rick Brobbel Oracle Transactional Business Intelligence
-
Data Sync licensingSummary Want to know if we need to license data sync separately. Content Hi BI Experts, I am posting this on behalf of my colleague. We need the below details. Do we nee…Santhosh K Gaddam 42 views 4 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI Analysis Content I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less t…Brenda Jacks-49721 83 views 1 comment 0 points Most recent by rashid ramzan-45341 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 42 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence
-
Hands-On Training/Consulting Svcs on OBI DashboardsSummary Hands-On Training/Consulting Svcs on OBI Dashboards Content Hello:) Can anyone recommend a consulting services that provides hands-on training for OBI Dashboards…Melva McElroy 22 views 1 comment 0 points Most recent by David Ivester 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 210 views 4 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence
-
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 118 views 3 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 82 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.4K views 7 comments 0 points Most recent by Rachel Martorelli-Oracle 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 72 views 3 comments 0 points Most recent by Antony Hooper-29731 Oracle Transactional Business Intelligence
-
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 63 views 2 comments 0 points Most recent by Kim Welker Oracle Transactional Business Intelligence
-
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 131 views 4 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence
-
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 187 views 11 comments 0 points Most recent by Rahul Thomas 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 32 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 52 views 3 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence
-
Conditional Formatting on Column Sub-TotalContent Hello, I've built a sickness report that counts the number of instances of sickness and number of days sickness over a time period. I've figured out how to add a…Evan Jenkins 45 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Oracle Transactional Business Intelligence