Popular Tags
- OTBI 1,449
- Reporting 1,395
- FDI 1,129
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 592
- Administration 555
- OAC 459
- OBIEE 433
- Analytics 406
- BI Publisher Data Models 357
- Security 294
- HCM 269
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 201
- Fusion Data Intelligence 190
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
Time in role reportSummary I need to create a time in role report Content I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Empl…Peter Kirwan 68 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 Oracle Transactional Business Intelligence -
Bursting ReportSummary A report on Probation which bursts out to Line Managers Content is there any example reports which look at Probation Period? Also sample reports for Bursting?Peter Kirwan 46 views 1 comment 0 points Most recent by Sowdhaminya Murugan Oracle Transactional Business Intelligence
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard? Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull…Brenda Jacks-49721 112 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence
-
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 43 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 103 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 86 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 36 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 85 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 29 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 219 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 46 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 44 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 23 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 213 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 121 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 89 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.6K views 7 comments 0 points Most recent by Rachel Martorelli-Oracle Oracle Transactional Business Intelligence