Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- 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
- 
             Any best practices for Security / User group setup?Summary best practice recommendations on security/user groups Content We are looking at different options for security using User Groups to limit the requisitions that r… Any best practices for Security / User group setup?Summary best practice recommendations on security/user groups Content We are looking at different options for security using User Groups to limit the requisitions that r…
- 
             Placement of Dashboard Report LinksSummary Can the Dashboard Report Links (e.g., edit, export, add to briefing book, etc.) be moved from the bottom of the page to the top? Content Is it possible to move t… Placement of Dashboard Report LinksSummary Can the Dashboard Report Links (e.g., edit, export, add to briefing book, etc.) be moved from the bottom of the page to the top? Content Is it possible to move t…
- 
             Change order of Pie Graphs and Legend itemsSummary I created a Pie Graph view and would like to specify the order Content I created a pie graph view with multiple pie graphs and of course a legend. Is there a way… Change order of Pie Graphs and Legend itemsSummary I created a Pie Graph view and would like to specify the order Content I created a pie graph view with multiple pie graphs and of course a legend. Is there a way…
- 
             Formula HelpSummary Need help developing formula for date range Content Hello All, I am looking for help developing a formula that will help me identify if the date in a column is w… Formula HelpSummary Need help developing formula for date range Content Hello All, I am looking for help developing a formula that will help me identify if the date in a column is w…
- 
             OBI Self-Service Reporting (i.e. OBI Content View Only)Summary Have any customers been successful with launching OBI Self-Service? Content Oracle told us they do not have folder security permissions and Read-Only capability … OBI Self-Service Reporting (i.e. OBI Content View Only)Summary Have any customers been successful with launching OBI Self-Service? Content Oracle told us they do not have folder security permissions and Read-Only capability …
- 
             HELP! Deletion, Merging and Incomplete SubmissionsSummary Any advise? Content Hi, We configured the system to hide incomplete submissions in recruiting and also perform data auto-deletion tasks/merging. We however notic… HELP! Deletion, Merging and Incomplete SubmissionsSummary Any advise? Content Hi, We configured the system to hide incomplete submissions in recruiting and also perform data auto-deletion tasks/merging. We however notic…
- 
             Table View is missing from BIP Data Model in R11Summary Why was Table View taken away from BIP Data Model in R11 and how do we get it back? Content When editing a Data Model in R10, there was a link to View the data i… Table View is missing from BIP Data Model in R11Summary Why was Table View taken away from BIP Data Model in R11 and how do we get it back? Content When editing a Data Model in R10, there was a link to View the data i…
- 
             Merged cell in Excel 2007 Excel ExportSummary Can you remove the merged cell in a 2007 Excel OBI export? Content Hello, When you export a large document from OBI to 2007 Excel, there is a merged cell that is… Merged cell in Excel 2007 Excel ExportSummary Can you remove the merged cell in a 2007 Excel OBI export? Content Hello, When you export a large document from OBI to 2007 Excel, there is a merged cell that is…
- 
             Help with a formula to capture # of career site postingsSummary Help with a formula to capture # of career site postings Content Hello - I'm trying to create a few formulas to determine the following - How many requisitions h… Help with a formula to capture # of career site postingsSummary Help with a formula to capture # of career site postings Content Hello - I'm trying to create a few formulas to determine the following - How many requisitions h…
- 
             Days between Step/StatusSummary OBI Days between Step/Status Content I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status.… Days between Step/StatusSummary OBI Days between Step/Status Content I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status.…
- 
             Issue in OBI Catalog with folders getting moved automaticallyContent Hi, We have seen a strange behaviour where sometimes any random folder in the catalog gets moved under another folder. This happens randomly without any intentio… Issue in OBI Catalog with folders getting moved automaticallyContent Hi, We have seen a strange behaviour where sometimes any random folder in the catalog gets moved under another folder. This happens randomly without any intentio…
- 
             Adding Filters to promptsSummary For you gurus out there, please I need a help Content I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that ar… Adding Filters to promptsSummary For you gurus out there, please I need a help Content I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that ar…
- 
             Anyone experience issues with Reporting using IE 11?Summary Anyone experience issues with Reporting using IE 11? Content I am running into problem when using my IE v11 browser in BI Publisher. All of a sudden buttons with… Anyone experience issues with Reporting using IE 11?Summary Anyone experience issues with Reporting using IE 11? Content I am running into problem when using my IE v11 browser in BI Publisher. All of a sudden buttons with…
- 
             Days on Hold CalculationSummary Need a days on hold formula for Legacy environment Content Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment… Days on Hold CalculationSummary Need a days on hold formula for Legacy environment Content Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment…
- 
             Max Export into Excel 2007 from OBISummary Wondering what the max export is into Excel 2007 Content Hello, Does anyone know what the max number of rows you can export from OBI into Excel 2007? I have hear… Max Export into Excel 2007 from OBISummary Wondering what the max export is into Excel 2007 Content Hello, Does anyone know what the max number of rows you can export from OBI into Excel 2007? I have hear…
- 
             Scheduling Reports in OBIEE based on dynamic datesSummary Schedule report delivery on dynamic date parameter. Content Is it possible to schedule a report in OBIEE based on a dynamic date parameter via prompts built into… Scheduling Reports in OBIEE based on dynamic datesSummary Schedule report delivery on dynamic date parameter. Content Is it possible to schedule a report in OBIEE based on a dynamic date parameter via prompts built into…
- 
             Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it.. Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..
- 
             Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBI Content We have Parent- child hiearchies for the COA segment values especially for BSV, Natu… Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBI Content We have Parent- child hiearchies for the COA segment values especially for BSV, Natu…
- 
             How do you make columns show distinct values in a table in BI PublisherContent I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplic… How do you make columns show distinct values in a table in BI PublisherContent I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplic…
- 
             Error while running BIP report (0ORA-10260: limit size (1048576) of the PGA heap set by event 10261Content Hi, We are getting an below error while working on BIP report to fetch Person data in HCM module. Any idea what could be the cause..? Thanks! ORA-10260: limit si… Error while running BIP report (0ORA-10260: limit size (1048576) of the PGA heap set by event 10261Content Hi, We are getting an below error while working on BIP report to fetch Person data in HCM module. Any idea what could be the cause..? Thanks! ORA-10260: limit si…