Popular Tags
- OTBI 1,494
- Reporting 1,412
- FDI 1,276
- Fusion AI Data Platform 1,049
- Analysis and Data Visualization 1,012
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 627
- OAC 569
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 441
- Analytics 439
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 293
- Oracle Analytics Cloud 283
- BIP 273
- Answers 266
- Analyses 257
- Fusion Data Intelligence 253
- 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
Answers
Discussion List
-
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 91 views 1 comment 0 points Most recent by rashid ramzan-45341 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
-
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 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
-
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 131 views 3 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
-
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
-
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 72 views 2 comments 0 points Most recent by Kim Welker Oracle Transactional Business Intelligence Forum
-
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 201 views 4 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence Forum
-
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 291 views 11 comments 0 points Most recent by Rahul Thomas 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
-
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
-
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 51 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Oracle Transactional Business Intelligence Forum
-
Field Level Security and Folder PermissionsSummary We want all user types to share one folder, but have user type permissions that can restrict certain confidential fields Content Hi - We are trying to find the b…Kim Welker 32 views 1 comment 0 points Most recent by Azfar Hussain-31614 Oracle Transactional Business Intelligence Forum
-
Issue with Percentage in Pivot TableSummary Issue with Summarizing Percentages in Pivot Tables Content I have a calculation for the fill rate based upon hired vs target. This is working fine in the details…Ellen Manthei 31 views 0 comments 0 points Most recent by Ellen Manthei Oracle Transactional Business Intelligence Forum
-
Sorting alphabetically on nameSummary Sorting alphabetically on name Content Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special lette…Maria Lieberman 81 views 5 comments 0 points Most recent by Rachel Martorelli-Oracle 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 82 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence Forum
-
Format prompt selectionsSummary Add specific formatting to prompted selections Content Is there a way to format the selections that show for prompts? For instance i need to have a prompt that f…User_EQ8R5 82 views 4 comments 0 points Most recent by User_EQ8R5 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 56 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence Forum