Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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 suppress rows and columns with 0 value on a pivot table?I have a pivot table, and I want to be able to hide entire rows or columns if all of the values are NULL. How can I achieve this? I tried the obvious things such as filt… -
How to fetch the First start date and latest end date from multiple rows in OTBI.I was trying to fetch the first start date and latest end date for and absence taken. since the short-term disability plan stores multiple rows in weekly wise so not abl…
-
Include report parameter in bursting output?Content I'm using bursting to control the filename/delivery of a report run as a part of a flow. I'm not actually splitting the data up, so I'm just using the Split/Deli…
-
-
Pull a report of OTBI User Folder AccessSummary We need to be able to pull a report of all user access to all OTBI folders. Content We need to be able to pull a report of all user access to all OTBI folders. T…
-
NULL values in OTBII think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable null val…
-
BI Publisher report not delivering as expected due to large sizeHi, we are using OAS 7.0, EBS 12.2, OBIA7.6.4, Oracle 19 db on linux set up. We have a BI Publisher report that has around 500K rows that we are exporting in .xlsx file.…
-
OTBI Analysis result via SOAP request/response with proper column namesHi, I am using OTBI and I have created an Analysis. This works great. Now I want fetch the result via a SOAP call. This also works fine. I use the XmlViewService and the…
-
Report of Objects in BI Catalog FoldersSummary Is there a way to produce a report of folder structure along with objects/types that exist in the folder Content Hi, Is there a way to create a report or if one … -
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeWe are trying to create a Analysis report based on General Ledger-Transactional Balances Real Time to display: Natural Account Segment Fiscal Quarter Ending Balance Repo…
-
Performance Goals DashboardI have a Performance Goal Dashboard that reports Goals created and Goals not created. When the number for goals created is selected, it brings up report within the dashb… -
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBIWe have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some approache…
-
BIP Report fails with Maximum Limit Exceeded even after applying all filtersBIP Report fails with Maximum Limit Exceeded even after applying all filters Content (please ensure you mask any confidential information): Hi Team, Greetings! We are ge…
-
Which BI Role is required to develop OTBI AgentHi, Can you please suggest which BI Role is required to develop OTBI Agent? Do we need BI Admin Role to create or schedule OTBI Agent? Thanks in Advance.
-
Monitoring and analyzing HCM workflow email bounces--Please advise if this post belongs in a different forum-- As we know, bursting emails is possible in BIP, and OTBI provides bursting via agents. Recipients receive mes… -
Reporting on Incomplete ApplicationsWe are working with our Management Service team to create an Incomplete Applications report in BIP. Is this possible and if so, what fields do we need to pull? Thanks, M…
-
How to add return button in error page of OTBII added return button on the result page in OTBI report using Javascript but that return button is not visible when error comes or in scenario of no data found. How can …
-
Can we update Tax Name in Oracle Fusion?Hi Everyone, I would appreciate your insights on whether it’s possible to update the Tax Name of an existing tax in Oracle Fusion Financials. If direct modification isn’…
-
What is the procedure to configure the SSL certificate in oracle apex?Hi, We are planning to enable the SSO to the oracle apex application. As a prerequisite to enable the SSO, we need the URL which we use should be in https (as a secure).…
-
Error joining subledger and general ledgerHello, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real Time and General Ledger: Journals Real Time. It works fine up to t…