Popular Tags
- OTBI 1,373
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 898
- BI Publisher 794
- Analysis 655
- Administration 543
- Oracle Fusion Analytics 537
- OBIEE 417
- BI Publisher Data Models 328
- Analytics 313
- OAC 278
- Answers 259
- Security 255
- Analyses 251
- Developers 235
- HCM 225
- BIP 218
- Data Modelling and Datasets 210
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
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… -
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…
-
Help with my SQL CodeSummary Help with my SQL Code Content I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
Agent LimitationsSummary Encountering limitations on the exports from agents Content I am currently encountering an issue where exporting data through an agent is cutting off at 25,000 r…
-
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…
-
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…
-
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 …
-
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…
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…
-
SQL editor for Oracle BISummary What tools are people using to edit SQL in Oracle BI? Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model…
-
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…
-
Terminated Line ManagerSummary Report on where an employee's Line Manager is Terminated Content does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues …
-
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…
-
Pushing Shortcut to Custom Folders to Users "My Reports"Content If we have a custom folder with many reports, I know that as a user, I can create a shortcut and have that in My Reports. Is there a way for an Admin to push the…
-
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. …