Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,104
- Analysis and Data Visualization 983
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 400
- 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 192
- 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
- 
             HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin View Content In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but … HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin View Content In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but …
- 
             InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate function Content Names in our system are entered inconsistently and the goal is to be consistent wit… InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate function Content Names in our system are entered inconsistently and the goal is to be consistent wit…
- 
             External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int… External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…
- 
             Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel. Content Hi, I have one report which is automatically scheduled to be s… Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel. Content Hi, I have one report which is automatically scheduled to be s…
- 
             How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una… How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una…
- 
             Adding two measures not workingSummary Adding two measures not working Content I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within t… Adding two measures not workingSummary Adding two measures not working Content I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within t…
- 
             Help with DashboardsSummary Help with Dashboards Content I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test t… Help with DashboardsSummary Help with Dashboards Content I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test t…
- 
             Embedded Reporting/BI PublisherSummary audit report using offer fields Content Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for th… Embedded Reporting/BI PublisherSummary audit report using offer fields Content Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for th…
- 
             Analytics Cloud (OAC) portsContent What ports does OAC currently use for the BI component? Is it 80 instead of 9704? How about for the Essbase component? Analytics Cloud (OAC) portsContent What ports does OAC currently use for the BI component? Is it 80 instead of 9704? How about for the Essbase component?
- 
             Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal… Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal…
- 
             OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Area OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Area
- 
             Report that shows Agents and BI SchedulesSummary Report that shows Agents and BI Schedules Content We have multiple scheduled BI reports and Agents and we need a way to shift through them all. I know the BI sch… Report that shows Agents and BI SchedulesSummary Report that shows Agents and BI Schedules Content We have multiple scheduled BI reports and Agents and we need a way to shift through them all. I know the BI sch…
- 
             Data Sync licensingSummary Want to know if we need to license data sync separately. Content Hi BI Experts, I am posting this on behalf of my colleague. We need the below details. Do we nee… Data Sync licensingSummary Want to know if we need to license data sync separately. Content Hi BI Experts, I am posting this on behalf of my colleague. We need the below details. Do we nee…
- 
             How to adjust 1000 notation within a BI Publisher graphContent Hello, We would like to adjust the y axis of a chart we made so that the 1000 counts are not seperated with a comma. Where can we adjust this formatting? See att… How to adjust 1000 notation within a BI Publisher graphContent Hello, We would like to adjust the y axis of a chart we made so that the 1000 counts are not seperated with a comma. Where can we adjust this formatting? See att…
- 
             Emergency ContactSummary Workforce Management - Person Real Time. Content Using Fusion version 7 and the fields phone number and phone type do not feature in subject area - Workforce Man… Emergency ContactSummary Workforce Management - Person Real Time. Content Using Fusion version 7 and the fields phone number and phone type do not feature in subject area - Workforce Man…
- 
             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… 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…
- 
             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… 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…
- 
             Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t… Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t…
- 
             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… 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…
- 
             OBIEE Visual AnalyzerSummary Is visual analyzer available with OBIEE Content Hi we are looking for ways to load external data to OBIEE for reporting purpose. I saw the article https://develo… OBIEE Visual AnalyzerSummary Is visual analyzer available with OBIEE Content Hi we are looking for ways to load external data to OBIEE for reporting purpose. I saw the article https://develo…