Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: XXX-XX-XXXX (112-10-1234) TIN… -
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…
-
We have set operations report but unable to reviewSummary: Hi Team, we have set operations report but I'm unable to find out applied filters and where we need to check . any one help me on how can we review for enchanem…
-
How to build an Analysis on OTBI to show cumulative totals over time?Summary: What is the function (or any way) of an Analysis report that shows cumulative totals over time, in the same way as it is displayed on attached file? For example…
-
How to report Number of Performance Goals by employees (then broken up by categories) using OTBI ?Summary: Dear peers, My customer wants to report the no. of performance goals every employee has in their Goal Plan; Total and Category-wise (There are 13 custom categor…
-
How do we build an OTBI report to see the ratings of a Business Unit head's organization?Summary: The client requires a report that can be run to fetch the Performance ratings of all the employees that fall under a particular Business Leader (direct as well …
-
Clean up html formatting stored in table columnWe are using notes to store data in an application table (Oracle Cloud PPM, Project setup); users are copying and pasting data from an html page and inadvertently pastin…
-
Removing HTML tags from a datbase fieldSummary Remove HTML tags saved in database field Content Hi, I have an sql data model retruning HCM performance review data. One of the fields returned is a comments fie…
-
Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI reportSummary: Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report Content (required): We have loaded assignment EFF attributes using spr…
-
Action Reporting - Promotions, Increases, DemotionsSummary: Action Reporting - Promotions, Increases, Demotions Content (required): Hi there. I'm wondering if there are any detailed process documents for how to create an…
-
Scheduling an OTBI AnalysisSummary: We have a request to schedule an OTBI Analysis. This particular analysis has multiple prompts (Business Unit, Ledger Name, Start date, End date). Is there a way…
-
Unable to join Workforce Goals - Goal Status Overview Real Time and Workforce Performance - PerformaSummary: Hi Team, I have a requirement where I need to fetch goal plan details along with rating details for a specific goal plan for employees. I have included fact col…
-
Does anyone know what tables are needed to create OTBI report "Transactions awaiting my action"?Summary: Indirect Procurement stakeholder wants to create an OTBI report for "Transactions Awaiting My Action". This would be used to review POs that were not successful…
-
How to create formula to show PR where all lines have processed requisition line flag as yesSummary: We are trying to create an analysis to display those particular requisitions where all lines are processed successfully into PO Content (required): Need help to…
-
How to Dipslay Total at the Top of Stacked Vertical Bar ChartSummary Need to know how to Dipslay Total at the Top of Stacked Vertical Bar Chart Content While representing data as vertical bar chart (due to groupings used/needed) I…
-
OTBI analysis based on results of another analysisSummary: I have 1 OTBI analysis that looks at all invoices in system and filters it down based on 10 parameters. I have a second OTBI analysis that I then have a filter …
-
Facing Issue in calculating percentage for an Analysis in OTBISummary: We are trying to create a custom analysis to calculate the month wise percentage of delivered amount being early received including tolerances. We have calculat…
-
Report showing incorrect rolling monthsSummary: Hi Team, We have absence rolling report last 12months but only showing last 10 months data for country. i mean rolling need to Feb'22 to Jan'23 but its taking o…
-
Issue with deep link Functionality in OTBI AnalysesSummary: We need a functionality within OTBI Analyses where we click on a particular graph of the analysis, it redirects to the SaaS Page which has particular set of rec…