Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 982
- 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 191
- 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
- 
             How to provide the gap between the 2 bars in bar graphHow to provide the gap between the 2 bars in bar graph How to provide the gap between the 2 bars in bar graphHow to provide the gap between the 2 bars in bar graph
- 
             Why does the value for CUSTOMER_ANNUAL_REPORTING is changed to mixed case?Hello, I am updating activity report. The field Subject COMED have multiple values, and I used REPLACE to use the Subject COMED as filter. (REPLACE "Activity Extension".… Why does the value for CUSTOMER_ANNUAL_REPORTING is changed to mixed case?Hello, I am updating activity report. The field Subject COMED have multiple values, and I used REPLACE to use the Subject COMED as filter. (REPLACE "Activity Extension".…
- 
             DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there … DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there …
- 
             Content of different email fields in OTBIWe noticed that the email data that we get for the learners from OTBI is inconsistent and would like to know where those differences may come from and which OTBI email c… Content of different email fields in OTBIWe noticed that the email data that we get for the learners from OTBI is inconsistent and would like to know where those differences may come from and which OTBI email c…
- 
             OTBI - Benefits Enrollment Realtime - Unable to pull the dependent data for a benefit planI am trying to create a OTBI report, which includes person number, benefit plan and covered dependents for the plan. Seeing blank data for the dependent information colu… OTBI - Benefits Enrollment Realtime - Unable to pull the dependent data for a benefit planI am trying to create a OTBI report, which includes person number, benefit plan and covered dependents for the plan. Seeing blank data for the dependent information colu…
- 
             How to send prompted OTBI analysis results by emailSummary: When you submit an OTBI analysis results by entering some prompts to filter results, system shows list of results according to filters applied before. If you se… How to send prompted OTBI analysis results by emailSummary: When you submit an OTBI analysis results by entering some prompts to filter results, system shows list of results according to filters applied before. If you se…
- 
             How to retain report format after exporting to Excel?Hello, Upon extracting the report, the format of values in excel file have extra characters and extra spaces. Is there a way to correct the data upon exporting? Report v… How to retain report format after exporting to Excel?Hello, Upon extracting the report, the format of values in excel file have extra characters and extra spaces. Is there a way to correct the data upon exporting? Report v…
- 
             Pivot Table incorrect totalI created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly … Pivot Table incorrect totalI created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly …
- 
             No Output When Adding Parameters in the Bursting QueryThis is my snippet of my added code. Both SUCCESS SCHEDULE USING HARDCODED DATES USING LINE2 PARAMETER No Output When Adding Parameters in the Bursting QueryThis is my snippet of my added code. Both SUCCESS SCHEDULE USING HARDCODED DATES USING LINE2 PARAMETER
- 
             Line Manager Dashboard OTBI not showing dataLine manager Dashboard not showing any data for any employee with line manager role having direct reportees along with essential access roles that is employee line manag… Line Manager Dashboard OTBI not showing dataLine manager Dashboard not showing any data for any employee with line manager role having direct reportees along with essential access roles that is employee line manag…
- 
             Is there a BICC PVO for privileges and their link to roles ?Is there a BICC PVO for privileges and their link to roles ? Is there a BICC PVO for privileges and their link to roles ?Is there a BICC PVO for privileges and their link to roles ?
- 
              
- 
             Business Unit prompt not working when TopN is applied in OTBIHi All I have a margin analysis where I added Business Unit as a prompt so the user can switch between BUs. But when I apply a TopN filter, the Business Unit prompt is n… Business Unit prompt not working when TopN is applied in OTBIHi All I have a margin analysis where I added Business Unit as a prompt so the user can switch between BUs. But when I apply a TopN filter, the Business Unit prompt is n…
- 
              
- 
             How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to… How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…
- 
             Where can we find list of BICC Public View Objects (PVO) for all releasesHi All, Can you help us with the documentation where the list of PVOs are provided for BICC. Thanks, Where can we find list of BICC Public View Objects (PVO) for all releasesHi All, Can you help us with the documentation where the list of PVOs are provided for BICC. Thanks,
- 
             How to remove HTML tags in Column Values?Hi everyone, Kindly seeking your assistance with an issue in the column values that shows HTML tags. The data is being saved in the backend with HTML tags that's why the… How to remove HTML tags in Column Values?Hi everyone, Kindly seeking your assistance with an issue in the column values that shows HTML tags. The data is being saved in the backend with HTML tags that's why the…
- 
             Can we get user license related information from OTBI?Hi, Is there any subject area for us to extract information relating to user license consumption? or any method where the client themself can see this information time t… Can we get user license related information from OTBI?Hi, Is there any subject area for us to extract information relating to user license consumption? or any method where the client themself can see this information time t…
- 
             How to LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an… How to LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an…
- 
             Oracle Community Idea Raised - No ResponseWe have raised an Idea in Oracle Community (below is the link): https://community.oracle.com/products/oracleanalytics/discussion/19536/restriction-of-data-in-reports-and… Oracle Community Idea Raised - No ResponseWe have raised an Idea in Oracle Community (below is the link): https://community.oracle.com/products/oracleanalytics/discussion/19536/restriction-of-data-in-reports-and…