Popular Tags
- OTBI 1,415
- Reporting 1,376
- FDI 1,009
- Analysis and Data Visualization 965
- BI Publisher 827
- Analysis 667
- Oracle Fusion Analytics 558
- Administration 554
- OBIEE 426
- OAC 369
- Analytics 360
- BI Publisher Data Models 338
- Security 279
- Answers 264
- Analyses 253
- HCM 244
- Developers 240
- BIP 236
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 190
- Report Output 181
- Customizing Reports 152
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
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 62 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 155 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 191 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 31 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 51 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 43 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Oracle Transactional Business Intelligence
-
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 31 views 1 comment 0 points Most recent by Azfar Hussain-31614 Oracle Transactional Business Intelligence
-
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 51 views 5 comments 0 points Most recent by Rachel Martorelli-Oracle Oracle Transactional Business Intelligence
-
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 71 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence
-
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 62 views 4 comments 0 points Most recent by User_EQ8R5 Oracle Transactional Business Intelligence
-
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 33 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence
-
StatsSummary Stat Report Content is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows wou…Peter Kirwan 31 views 1 comment 0 points Most recent by Chris Dabel Oracle Transactional Business Intelligence
-
Link to DashboardSummary Looking to provide a direct link to our Recruiting Dashboard for users not logged in Content I'm trying to create a link to our Recruiting Dashboard to be includ…Andy French 41 views 2 comments 0 points Most recent by Andy French Oracle Transactional Business Intelligence
-
Duplicates appearing - need true dataSummary I have one field that is pulling different dates - need true data Content Hi Group, I'm having an issue getting a single date to pull in correctly in OBI. The fi…Erin Caby-47393 51 views 3 comments 0 points Most recent by Reena Trangri Oracle Transactional Business Intelligence
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontal Content I need to change the layout of a sectioned Table from vertical to horizontal. …Andy French 31 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence
-
Candidate ID PromptSummary Adding required candidate ID prompt with text box entry Content Trying to add a prompt for candidate ID. I want users to be able to copy/paste or type into a tex…Shannon_Johnson 72 views 7 comments 0 points Most recent by Suvankar Dasgupta Oracle Transactional Business Intelligence
-
Sorting In a Pivot Table OBISummary How to sort on a measure within Pivot Table Content I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I …
-
Functional Documentation for seeded ReportsContent Hi, Is there any functional documentation for seeded Reports (Financials) ? Thank you,Victor Ardiaca 31 views 1 comment 0 points Most recent by Lisa Schenk Oracle Transactional Business Intelligence
-
Adding new columns to a single view changes all viewsSummary Adding new columns to a single view changes all views Content Is there a setting that will stop this from happening? I have several reports that have multiple vi…Dawn Phipps 52 views 3 comments 0 points Most recent by Dawn Phipps Oracle Transactional Business Intelligence