Popular Tags
- OTBI 1,384
- Reporting 1,358
- FDI 921
- Analysis and Data Visualization 920
- BI Publisher 805
- Analysis 657
- Administration 544
- Oracle Fusion Analytics 541
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 322
- OAC 296
- Answers 260
- Security 257
- Analyses 252
- Developers 237
- HCM 229
- BIP 225
- Data Modelling and Datasets 212
- Data Connectivity 205
- ERP Analytics Content 193
- BI Publisher Report Templates 181
- Report Output 180
- Agents 151
- Customizing Reports 144
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
Prefix - set effective date using SQL ExpresssionContent Hello - I'm hoping someone can help me with this please. I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the…Linda Stelling-61686 72 views 2 comments 0 points Most recent by Rick Brobbel Oracle Transactional Business Intelligence -
Removing time from date criteriaContent In all criteria the date appears as 03/03/2015 03:56:13 PM. Is there anyway to remove the timestamp from the view so only the date appears in the columns? Thanks…Sara Simpson 481 views 9 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
Day Name from DateSummary Need to get the name of the day of the week from the Creation Date Content Hello, I am using this function: DAYNAME("Service Request"."Creation Date") and it is …slgott 94 views 5 comments 0 points Most recent by GopiKAutomus Oracle Transactional Business Intelligence
-
Column Properties InteractionSummary Primary Interaction = None but hyperlink still showing in the value Content Hello, I have a report where I've set the "Primary Interaction" on the 'Value' to "No…slgott 65 views 6 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
Phone screens completedSummary Looking to add the number of phone screens completed to report Content I have a current report that I am needing to add the number of phone screens that have bee…User_HZJPP 21 views 1 comment 0 points Most recent by Michael Scaduto Oracle Transactional Business Intelligence
-
Case When for date fieldsSummary Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time" Content I'm trying to build a Case statement that shows If one date i…slgott 101 views 2 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
archive unarchive and oracle bi admin roleSummary archive unarchive and oracle bi admin role Content Hi, in Oracle BI is it possible to get archive/unarchive functionality and not be an oracle bi admin? Our tech…Alex Andreadis-70445 523 views 4 comments 0 points Most recent by Alex Andreadis-70445 Oracle Transactional Business Intelligence
-
Missing Folder in OBISummary Is there a way to recover missing folder in BI. Content We have a folder Analytic Library that is missing in our production environment. I can see it in our PTFD…User_KCEP9 11 views 1 comment 0 points Most recent by Prudence K Oracle Transactional Business Intelligence
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …Abdalaziz Barham 33 views 1 comment 0 points Most recent by Abdalaziz Barham Oracle Transactional Business Intelligence
-
Scheduling Agent with PromptSummary Scheduling Agent with Prompt Content I have a report that has a facility filter prompt built into it. I've created several scheduling agents based on this report…Alexis Rivers 161 views 10 comments 0 points Most recent by Manjula K R Oracle Transactional Business Intelligence
-
Formatting Totals RowSummary Formatting Totals Row Content I have a report that I used the aggregation rule (totals row) to calculate the sum or average of the entire column upon running the…User_HZJPP 61 views 3 comments 0 points Most recent by Jagadish Angadi-29558 Oracle Transactional Business Intelligence
-
Translate SQL of OTBI in ApplicationDB HCMSummary How to Translate SQL of OTBI in ApplicationDB HCM? Content Hello, I have verified that in SA of OTBI there aren't some value that I want to use in a report. I fo…Giuseppe 1234 52 views 1 comment 0 points Most recent by Vijaya Kumar-70229 Oracle Transactional Business Intelligence
-
Candidate Drop off ReportSummary a report that gives details on when a candidate drops off at an application and doesn't complete/submit Content We have been working on building a candidate drop…Iqra Khan 23 views 2 comments 0 points Most recent by Iqra Khan Oracle Transactional Business Intelligence
-
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheet Content Hi Experts, I created 3 new reports as per our customer requirements. But they need all the rep…NIRMAL KUMAR L 82 views 3 comments 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence
-
Scheduler IssuesSummary Experiencing intermittent errors with scheduled reports Content Is anyone else experiencing any issues with scheduled reports? In the last 24 hours, a couple of …Andy French 135 views 7 comments 0 points Most recent by Sakshi Batra-39119 Oracle Transactional Business Intelligence
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sql Content Hi, Anyone know how to fetch the manager name for the terminated employees? For…NIRMAL KUMAR L 101 views 1 comment 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence
-
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 61 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 41 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 103 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.3K views 1 comment 0 points Most recent by Manoj.Gupta Oracle Transactional Business Intelligence