Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 987
- Analysis and Data Visualization 953
- BI Publisher 820
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 347
- OAC 338
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
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 -
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 41 views 2 comments 0 points Most recent by RichardChan 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 106 views 2 comments 0 points Most recent by 3487945 Oracle Transactional Business Intelligence
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una…Gala Meyerovich 81 views 4 comments 0 points Most recent by Gala Meyerovich 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
-
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 21 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 211 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 41 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 81 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 41 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 21 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 215 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 122 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 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
-
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
-
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 61 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 158 views 4 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence