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
- 
             report on user account details - Role NamesSummary SQL for reporting on employees roles Content Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAM… report on user account details - Role NamesSummary SQL for reporting on employees roles Content Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAM…
- 
             Is there an Enhancement Request for BICS "exceeded configured maximum number of allowed input recordSummary Our BICS users get this error message when trying to look at years worth of data. Our users have to run multiple reports now in BICS to get the results. In OBIEE… Is there an Enhancement Request for BICS "exceeded configured maximum number of allowed input recordSummary Our BICS users get this error message when trying to look at years worth of data. Our users have to run multiple reports now in BICS to get the results. In OBIEE…
- 
             Pivot table in analysis - aging bucketsSummary how to create a pivot table with columns as calculated field Content i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a cal… Pivot table in analysis - aging bucketsSummary how to create a pivot table with columns as calculated field Content i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a cal…
- 
             how to set a pivot table as default view in analysisSummary how to set a pivot table as default view in analysis Content Hi is there a way to set a pivot table view when running an analysis. For some reasons the table vie… how to set a pivot table as default view in analysisSummary how to set a pivot table as default view in analysis Content Hi is there a way to set a pivot table view when running an analysis. For some reasons the table vie…
- 
             Exporting to Excel & Word WrapSummary I want cells with longer text to wrap automatically when I export an analysis to excel 2010. Content I have a built an analysis that pulls in requisition user co… Exporting to Excel & Word WrapSummary I want cells with longer text to wrap automatically when I export an analysis to excel 2010. Content I have a built an analysis that pulls in requisition user co…
- 
             Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI export Content When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day… Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI export Content When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day…
- 
             Concatenating Multiple Columns with Commas and SpacesSummary Trying to concatenate multiple columns in OBI Recruiting Legacy Content Hello, I'm trying to concatenate multiple columns with spaces and commas in OBI Recruitin… Concatenating Multiple Columns with Commas and SpacesSummary Trying to concatenate multiple columns in OBI Recruiting Legacy Content Hello, I'm trying to concatenate multiple columns with spaces and commas in OBI Recruitin…
- 
             Auditing on ReportsSummary Auditing on Reports Content Hello All, I am looking at option how we can have an Audit on Reports. We have created a report which is consumed by 3rd party via We… Auditing on ReportsSummary Auditing on Reports Content Hello All, I am looking at option how we can have an Audit on Reports. We have created a report which is consumed by 3rd party via We…
- 
             OTBI Security HelpContent Hi All, We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, w… OTBI Security HelpContent Hi All, We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, w…
- 
             Time To Find CalculationSummary Time To Find Calculation - need Days on Hold metric by Candidate! Content Hi - I'm hoping to get some help on an issue that we have had for several years now. Cu… Time To Find CalculationSummary Time To Find Calculation - need Days on Hold metric by Candidate! Content Hi - I'm hoping to get some help on an issue that we have had for several years now. Cu…
- 
             Use multiple prefix variables in a reportSummary Using multiple prefix variables on advanced tab of a report Content Is is possible to have more than one prefix variable in the "Prefix" section on the advanced … Use multiple prefix variables in a reportSummary Using multiple prefix variables on advanced tab of a report Content Is is possible to have more than one prefix variable in the "Prefix" section on the advanced …
- 
             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… 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…
- 
             How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it delivered Content Is there a way to schedule an OTBI Analysis to run periodically and save the outp… How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it delivered Content Is there a way to schedule an OTBI Analysis to run periodically and save the outp…
- 
             Problem with adding days in a date(sql)Summary Problem with adding days in a date (sql) Content Hi All, I’m building a bi report and I have the following problem when building the data model. Oracle provides … Problem with adding days in a date(sql)Summary Problem with adding days in a date (sql) Content Hi All, I’m building a bi report and I have the following problem when building the data model. Oracle provides …
- 
             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… 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…
- 
             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… 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… 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… 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… 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 … 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 …