Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 169
- Customizing Reports 156
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 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…
-
Combining Project cost (Subject area) with General Ledger - Journals Real TimeHas anyone ever successfully created an OTBI report with Project - Costing Real Time and General Ledger - Journals Real time? Having some issues with the values. Thanks
-
Hi, wanted to know if in W2 form we have any box id, if yes in which table it gets stored?I wanted information on if we have any box ids for W2 forms? If there are any such ids, in which table do they get stored?
-
How do I display Years in drop down list without the decimals?When I set the default to show as the current year it doesn't show with the decimals (second screenshot), but when I go to select the other values they display with deci…
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…
-
How to consolidate several rows in one line in OTBI Pivot table?Hi All, Thank you in advance for your assistance. I have a query regarding the OTBI report I was working on for asset depreciation. I was wondering if it is possible to …
-
How to add a calculated column in OTBI Pivot Table ?Hi All, Thank you in advance for your help and support. I have a query regarding the OTBI pivot table. I was wondering if there is a way to add a calculated column to th…
-
BI Publisher desktop Not working with Office 365I installed BI Publisher desktop 32bit and 64 bit on office 365, but both are not working, I am unable to see BIP Addin in office tool Bar, I tried to to enable the AddI…
-
Pivot Table in RTF - BI ReportHello I have pivot table report and that works fine. I have to add a url (in another xml tag) to be hyperlink of the across field of the pivot. I tried following but it …
-
Bursting output file name character limitContent Hi, I have defined Bursting Output file name in the query as below- LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_D…
-
Option to get the Permissions associated with BI reportsWe have noticed that few of our BI reports have permissions which are incorrect and we would want to anlyze all the BI reports and their permissions to correct the same.…
-
How to add sql query to OTBI filterI want to create an OTBI analysis that gives data between last 7 days. I tried creating a filter using SQL expression but it doesnt work. Can someone pls help with the r…
-
Where to find access and visibility information within the learning subject areasHello, we need to develop, within the learning module, two infolets relating to the editions to which managers can enroll their subordinates, and the editions to which p…
-
-
What's the column name for Requisition Number under Inventory Transfer Order Real Time subject area?I'm creating an OTBI report to pull open interorganization transfer orders and link the Requisition number from source org. These details are showing in 'Manage Transfer…
-
What's the column name for Requisition Number under Inventory Transfer Order Real Time subject area?I'm creating an OTBI report to pull open interorganization transfer orders and link the Requisition number from source org. These details are showing in 'Manage Transfer…