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
-
We are unable to create pyramid chart in OTBI. Provide solution to create pyramid structure.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Use Session variable in Conditional Drill downSummary: Hi Team Currently, in OTBI, I can see only presentation variable available while creating Conditional Drill downs. Is Oracle planning to introduce Session Varia…
-
How can I use a presentation variable in OTBI to get data based on a parameter?I have an OTBI report with 'From Date' and 'To Date' parameters. I want to include a column in the report that displays the total amount from the same period in the prev…
-
OTBI Report font changes from Tahoma to Lucida Sans when exported to ExcelHello, We have multiple OTBI Reports which are embedded in Dashboard. As per Customer requirements, we have set the Font for Column heading and Column Values to Tahoma a…
-
Goals Analysis in OTBIHi, I am creating one analysis on the Workforce Goals - Goal Status Overview Real Time subject area in OTBI. Want to create a pie chart that shows the submitted and not …
-
How can I add multiple answers to multiple questions in OTBI?Hello, I hope I'm in the right place. I need to create a SQL function: I'm creating a report where I need to place an answer to a question in a column and replicate this…
-
Can we enable "Unsubscribe" link in a BIP Bursting Report which the receiver can select to optSummary: Hi Team, We have a requirement wherein Business wants an Option to include the "Unsubscribe " option in the email body so that the receiver can use that option …
-
SQL Query Execution Time Exceeded Limit During Report GenerationWe have encountered a significant issue with one of our reports. Specifically, the SQL query associated with this report is taking longer to execute than the maximum tim…
-
how to fetch active BIP scheduled job list using BI/OTBI reportHello everyone, We have lot of reports which are scheduled to SFTP or Email. In few of them bursting is enabled and few of them are not bursted. We want to fetch all the…
-
How can I alter axis value in the given guage chartHow can I alter axis value in the given guage chart, Screenshot 2024-06-27 104854.png I want to display the axis value like 0,0.5,0.75,1,2, My requiremnets are as below …
-
OTBI - DFF attribute number transform into CHARHello We have created a flex field in PER_ASG under the data type 'Number'. There is a value set linked to this with different values in CHAR. We now want to build an OT…
-
Why Print Html Text appears when Entire Dashboard Output is taken in html format?Print Html Text is appearing in output when Entire Dashboard Output is taken.
-
For analysis built using union all, Percentage Calculation Column is displaying wrong valueThere is a column that we expect to be the percentage of the aggregated amount of 2 other columns. That is not working because the report is doing the sum of 2 separate …
-
OTBI analyses on shipping Real Time Subject Area does not display correct Fulfillment lineFor split lines Fulfillment details are not cauputed correctly. Currently only Shipment lines are captured based on the Shipment Id. On the SR raised SR 3-36563504801, I…
-
OTBI Formula/SQL solutionHi, Wondering if someone can help my colleagues and I out, we have an issue with our date range on our Absence by Directorate report. We have a SQL statement that would …
-
OTBI conditional countHello, My problem is the following: I would like to have a customized metric with that counts the number of learners that have "General Information"."Enrollment Record S…
-
OTBI conditional countHello, My problem is the following: I would like to have a customized metric with that counts the number of learners that have "General Information"."Enrollment Record S…
-
OTBI Generating Multiple Rows Per Employee, How to Compress to One Row?I am trying to report on the Talent Profile and it looks like each section of the profile creates a row per employee. How do I compress this into one?
-
Employer Insurance CostHello! I am trying to pull a report of insurance cost to the employer per pay per month for a specific business unit. I have several fields pulled into the report but th…
-
Printable PDF of our Dashboard is distorted, It's not the same as it looks on dashboard/ portal pageHi all, When we click on Printable PDF of our dashboard, it doesn't give out exactly a neat format (as shown in attached file) . On the Dashboard it looks fine. But when…