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
- 
             Invalid characters error message wne loading csv or excel fileSummary Can't load csv or excel file into BI data model Content Hi, When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid cha… Invalid characters error message wne loading csv or excel fileSummary Can't load csv or excel file into BI data model Content Hi, When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid cha…
- 
             Drill down capability using hyperlinks to the transaction pagesSummary Drill down capability using hyperlinks to the transaction pages Content Hi, I would like to know how we can build an OTBI report with an embedded link (url) that…Raghunathan Narasimhan-21427 51 views 4 comments 0 points Most recent by Raghunathan Narasimhan-21427 Drill down capability using hyperlinks to the transaction pagesSummary Drill down capability using hyperlinks to the transaction pages Content Hi, I would like to know how we can build an OTBI report with an embedded link (url) that…Raghunathan Narasimhan-21427 51 views 4 comments 0 points Most recent by Raghunathan Narasimhan-21427
- 
             Convert text field to date to use for calculationContent We have a UDF field which is populated by the candidate on the recruiting side in a form. The input is a DATE. There is no other choice on how to bring in the da… Convert text field to date to use for calculationContent We have a UDF field which is populated by the candidate on the recruiting side in a form. The input is a DATE. There is no other choice on how to bring in the da…
- 
             Adding Filters to a BIP reportSummary Adding Filters to a BIP report Content Hi All, How do I add Filters to a BIP report? Regards, Yaniv Adding Filters to a BIP reportSummary Adding Filters to a BIP report Content Hi All, How do I add Filters to a BIP report? Regards, Yaniv
- 
             BIP layout using space as a number grouping separatorSummary We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not… BIP layout using space as a number grouping separatorSummary We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not…
- 
             Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat… Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
- 
             Exist Interview Responses Report Not working for some of countriesSummary: Hi Team, we haveExist Interview Responses Report it was developed on few years back still no issue but now yesterday only one of country working fine but reamin… Exist Interview Responses Report Not working for some of countriesSummary: Hi Team, we haveExist Interview Responses Report it was developed on few years back still no issue but now yesterday only one of country working fine but reamin…
- 
             how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am… how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am…
- 
             How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,… How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…
- 
             FTE Breakdown (last year of 2020 and 2021)Summary: I want to make a report showing FTE by worker category, department, legal employer... per end of a period like end of month, end of quarter and end of year. I t… FTE Breakdown (last year of 2020 and 2021)Summary: I want to make a report showing FTE by worker category, department, legal employer... per end of a period like end of month, end of quarter and end of year. I t…
- 
             Check Employee's Exit Clearance Details in HCM OTBII need to create a report where an 'Employee's Exit Clearance' status is displayed on the report, post his resignation/termination from the organization. Please share wh… Check Employee's Exit Clearance Details in HCM OTBII need to create a report where an 'Employee's Exit Clearance' status is displayed on the report, post his resignation/termination from the organization. Please share wh…
- 
             Does Generic soap webservice for BIP Report scheduling support JWT Token AuthenticationSummary:Does Generic soap webservice for BIP Report scheduling support JWT Token Authentication Content (required):Does Generic soap webservice for BIP Report scheduling… Does Generic soap webservice for BIP Report scheduling support JWT Token AuthenticationSummary:Does Generic soap webservice for BIP Report scheduling support JWT Token Authentication Content (required):Does Generic soap webservice for BIP Report scheduling…
- 
             Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t… Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…
- 
             Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E… Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E…
- 
             Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d… Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…
- 
             Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi… Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi…
- 
             Missing fields in Subject Area Workforce Management - Worker Assignment Real Time?Summary: While attempting to add a field to the query, I found that I can't locate a couple of other fields that are already on the query Content (required): I am trying… Missing fields in Subject Area Workforce Management - Worker Assignment Real Time?Summary: While attempting to add a field to the query, I found that I can't locate a couple of other fields that are already on the query Content (required): I am trying…
- 
             titlebody titlebody
- 
             Consolidate MultiList values into single fieldSummary We need to be able to see all of the multi list values against a sku in a single field Content We have several MultiList fields in our sku attributes. When repor… Consolidate MultiList values into single fieldSummary We need to be able to see all of the multi list values against a sku in a single field Content We have several MultiList fields in our sku attributes. When repor…
- 
             OTBI Payroll Distribution reportSummary Need a model for a employee-level payroll distribution report for a range of periods. Content Has anyone developed an OTBI model for employee-level payroll distr… OTBI Payroll Distribution reportSummary Need a model for a employee-level payroll distribution report for a range of periods. Content Has anyone developed an OTBI model for employee-level payroll distr…