Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
Fixed Asset Treatment - Compliance with CIPFA's Financial Management CodeTwo key issues that prevented our organisation from progressing with the Oracle Fixed Assets module back in August 2022 were as follows:- 1. The new template that we rec… -
Enterprise Contracts - Show Supplier Name in one column along with all parties in another columnHello, I'm trying to build a "Contract Expiry" analysis for an end user using the "Enterprise Contracts - Contracts Real Time" SA. The user wants a column called "Suppli…
-
Is there a way to generate a report of the individual access of all users for OTBI reports?Is there a way to generate a report of the individual access of all users for OTBI reports (Reports, Analysis)? For auditing purposes, it is necessary to know which OTBI…
-
Is there any means to capture the count of reprint of BIP or OTBI reports.The client wants to limit the number of prints taken for a report. They want an audit of the counts of the reprint which happens for BIP and OTBI reports. Is there any m…
-
How to hide only data model in Report and Analytics page?Hi Expert, I have requirement to hide only Data model in Report and Analytics pag2)e, it should be visible to particular employees only. I have removed below mentioned t…
-
BICC - Set Extract Date for Individual PVO in a JOBHi All, We have a job for data extracts which extracts data from Around 100 PVOs. In our initial extract some pvos were erroring out due to timeout issue. So we separate… -
Can I merge between two subject areas in different module?Hi All, I am currently working on a dashboard that pulls data from the Procurement - Requisition Real Time subject area. I have a requirement to add a filter that reads …
-
Audit of print/reprint counts of BIP or OTBI reportsThe client wants to restrict the print of certain reports to specific users. They require to capture reprint count for these sepcific reports. Is there any option availa…
-
OTBI - Folder permission depending on the user's accessHello, We would like to know what is the best way to restrict access to OTBI folders depending on the user's access. Meaning, we would like the AB BU users to have acces…
-
Export OTBI Analysis Criteria in a flat fileWe need to do an impact analysis on certain work structure and organization change in all integration and reports. We have some 1000 OTBI reports to analyze the impact o…
-
Time Out IssueI'm trying to run a simple analysis that should yield approximately 700K records. It doesn't make sense to me why it keeps timing out. Does anyone have any tips I can us…
-
How can I get "And" instead of "Or" to work with the same column?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
Current and previous work schedule not returned in 1 rowI'm currently working on a report where it should return the current and previous work schedules in 1 row. Is there a way to do it in OTBI? I'm currently using Person Re…
-
Coverage gaps and Normal vs Extract PVOIn extract type of PVOs, we observe that some columns are missing when scheduling using BICC. To get exact functionality of normal PVO, we need to use Multiple Extract P…
-
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…
-
How can I add the name/URL of the environment to my OTBI reports in a Fusion SaaS solution?There is a requirement, that an OTBI-report run from 'Reports and Analytics' in Fusion always will show information about the environment, in which it was run. Basically…
-
Need to remove the NULL option value from OTBI dependent promptWhen we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL parameter repo…
-
Accrual rate- plan balance APIHow we get the actual accrual rate in plan balance API response payload. https://xxxx-xxxx.oraclecloud.com:443/hcmRestApi/resources/latest/planBalances?orderBy=balanceAs…
-
Can we pull the filters used in OTBI Analysis?Hi We are searching for the feasibility/way to pull the filters used in the OTBI Analysis thru BI report or any other way. Please find the screenshot. Regards, Aruna Aou…
-
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…