Popular Tags
- OTBI 1,427
- Reporting 1,383
- FDI 1,061
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 405
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 255
- Analyses 253
- BIP 247
- 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 168
- 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
-
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…
-
OTBI Subject area - Query for Work DaysIs there a subject area where we can find the employees Scheduled work days and any leave planned on those days any help would be appreciated.
-
OTBI Subject area - Query for Work DaysIs there a subject area where we can find the employees Scheduled work days and any leave planned on those days any help would be appreciated.
-
Current Year Promotion ReportI want to get the promotions of current year in OTBI report, I am getting it but the if there is any action after promotion then system is not picking that employee reco…
-
Issue with multi-select filter in reportI'm developing a report and encountered a problem when trying to select items in a filter. In its current configuration, I can extract either ONE specific item or ALL it… -
How to create ess job that will directly use the parameter of the data model?Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to re…
-
How to query PVO in Oracle BI Publisher Data ModelI need to query PVO data in BI Publisher, here's the PVO name: HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue Any screenshots, ideas, hints? Thanks.
-
Client cannot view report dataI have create a report BIP with data model but when the user execute it the result is empty when I can see data example: My user view: Customer view: