Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 984
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 401
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 193
- Report Output 184
- Fusion Data Intelligence 170
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
- 
             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… 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… 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… 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… 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… 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… 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 … 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… 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… 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…
- 
             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… 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 … 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… 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… 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. … 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. …
- 
             Need Help in Creating a OTBI Analysis from Simple Logical SQLSummary I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurence Content I have attach… Need Help in Creating a OTBI Analysis from Simple Logical SQLSummary I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurence Content I have attach…
- 
             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… 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…
- 
             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 … 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 …
- 
             Upgraded to 15B and now reports related to hires and offers are erroringContent We recently upgraded to 15B.2 and now reports related to job submissions are having errors. Lists of open reqs are working fine. We are going on week 3 and they … Upgraded to 15B and now reports related to hires and offers are erroringContent We recently upgraded to 15B.2 and now reports related to job submissions are having errors. Lists of open reqs are working fine. We are going on week 3 and they …
- 
             Functional Documentation for seeded ReportsContent Hi, Is there any functional documentation for seeded Reports (Financials) ? Thank you, Functional Documentation for seeded ReportsContent Hi, Is there any functional documentation for seeded Reports (Financials) ? Thank you,
- 
             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… 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…