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
-
Report on usage of OTBI reportsWe are reviewing our reports in OTBI, please can you provide the following: A list of folders that have not been run in the last 14 months? Can you please confirm whethe… -
How to find if a specific day falls between two dates - OTBITrying to create a formula to show yes/no if the 12th of the month falls between {"Payroll Period"."Start Date"} and {"Payroll Period"."End Date"} I attempted a simple f…
-
Restrict visibility on self data on a OTBI reportHello, How can I restrict the visibility on self data for a user? in an OTBI report. For exemple : A HR representative opens a report. He will see all the population, ex…
-
-
How can we add date parameters through advance SQL in OTBI?Hi All, We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql? How we refer parameter …
-
How to pass parameters through agents in OTBI?Hi All, We created a fully customized OTBI report to fetch balance details, all the customization is done through advance sql/XML, the report is running fine manually, b…
-
No data from User System Usage subject areaWe're using this analysis from the start of the implementation to know how many users are accessing the system. However, the data was stopped at October 2023 and I'm pre…
-
Roles to Create and Schedule an OTBI AgentGood Day, Just want to ask what roles should be given to the user to be able to create and schedule an OTBI Agent. Thank you.
-
What is the logic to add while creating the prompt in the Logical sql query in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…
-
How to create a report/Analysis in OTBI to have details with respect to Security Audit?I need to create report with fields listed as below: User Name, User Email, Role Name, Role Provisioned date, Role provisioned by What are the steps/Subject areas/ SQL?
-
How to plugin OTBI analysis into Microsoft PowePoint (PPT) ?We have a requirement where we need to be able to pull individual OTBI analysis (with graphs) to be pulled into a slide in PPT. I looked on the documentation, there is n… -
Add restrictions to the subject area General Ledger - Transactional Balances Real TimeHello everyone, First of all, thank you for taking the time to study my question. I use General Ledger - Transactional Balances Real Time to create a GL report to identi…
-
Oracle Mobile Application Designer (MAD) DeprecationIn the April 2024 Release (24B), the Oracle Mobile Application Designer (MAD) feature is disabled in Oracle Transactional Business Intelligence. If you wish to enable th… -
Use a Oracle Data Base as a Data Source For ReportingHello Our customer is looking for a solution for a reporting app. At the moment they have some products for Oracle Fusion Cloud Application which include the tool OTBI. …
-
Event Date field generates too multiple rows for the same job req phase OTBIHi experts, we have created an OTBI analysis with the following fields taken from the 2 subject areas: Recruiting real time and Recruiting event real time. We have seen …
-
Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real TimeHi All, I have created a report using 'Recruiting - Recruiting Real Time' and one of the column Rejection/Withdrawal Reason("Recruiting - Recruiting Events Real Time"."J…
-
Candidate Job Submission With Requisition in OBIEEHi All - We are trying to extract report in OBIEE for Job Submission we have created the report with all the candidate fields on the application and added filters Submis…
-
Not getting email from BI AgentHi Team, I have created a BI Agent using a condition, have selected an analysis in the condition section of the agent, analysis is basically giving the results of contro…
-
How to Resize the Column in OTBI Report ViewsTried to apply Additional Formatting Options (width, height, etc. fields) and also applied Column Properties too ,which doesn't work as expected, is there any other way …
-
Is there a reason why OTBI would not show all employees within an absence plan?Our business have a Holiday Purchase Plan Report - which is in the Absence Real Time in OTBI using the Absence Plan. However when using this, there seems to be a signifi…