Popular Tags
- OTBI 1,416
- Reporting 1,376
- FDI 1,012
- Analysis and Data Visualization 965
- BI Publisher 828
- Analysis 667
- Oracle Fusion Analytics 561
- Administration 554
- OBIEE 426
- OAC 372
- Analytics 361
- BI Publisher Data Models 339
- Security 281
- Answers 264
- Analyses 253
- HCM 246
- Developers 240
- BIP 236
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 190
- Report Output 181
- Customizing Reports 152
- Agents 151
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 LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an… -
setup printer with oracle fusion cloudhi we need to setup zebra Industrial Label Printer which is configured in our on-prem network, we need to setup it in oracle fusion application to print label and barcod… -
How to keep the column's width fixed in OTBI?Hello, I have a concern with my Activity report, the 'Activity Description' column keeps widening every time we use the 'Activity Type' prompt. Original View/Width After… -
Missing Data in Simphony Export – Guest Check GST TableA data export configuration was created in Simphony using the standard template named “FiscalStandardExp”, which includes the following subject areas: FCR Invoice Contro… -
How can I print a chart from an interactive report?I need printing chart fom interactive report object. Are there someone to have get this, already
-
Secured BI Publisher with asignment based AoR SecurityHi, I created a BI Publisher report that are based on the secured view PER_ASSIGNMENT_SECURED_LIST_V and assigned the privilege "Report Assignment" to the user's custom …
-
How can a third party reporting software Power BI be connected to Oracle Reports in FusionSummary: One of my client is using Power BI for reporting purpose they want to continue using power BI with fusion on a Realtime basis , So is there a way to sync up Pow…
-
Custom prompt based on values last 3 , last 6 , Last 9 and Last 12 monthsHi! We have a requirement to create custom prompt based on values such as: -last 3 months -last 6 months -Last 9 months -Last 12 months Above parameters work based on cu…
-
OTBI column formula assistance - Change 5 days to 5 working daysI am trying to amending the below column formula to count 5 working days instead of 5 days (which it is at the moment)? I need to exclude Saturdays and Sundays. Can anyo…
-
No data elements displayed in the subject area created by manual queryHi community! I have created a manual query that I was able to run and preview the data as shown but cannot see any data displayed while creating a workbook. Could someo…
-
How can I get both account-contact and orphan contact in OTBI Analysis?Hi, Is there a way for me to get all contacts that are associated in an account and contacts that don't have an account in OTBI analysis? I am using subject areas below …
-
Aggregation by Period (ex. Month) CalculationHello, Working within Netsuite Analytics Warehouse workbook using the data visualization table. Goal: to generate the total feet shipped per month. Table 1 (by Item Code…
-
Concatenated values for Depreciation Expense and Depreciation Reserve AccountHi, I am working on an OTBI report and using the Subject Area "Asset Balances Real Time". I am looking for Depreciation Expense and Depreciation Reserve Account(Concaten…
-
Query to identify Work Orders WHERE Work Centre IS NULLIs it possible to create an analysis in OTBI to retrieve work orders that are not associated to any work centre? Our organisation has multiple departments (work centres)…
-
Building Customized reportsHello, I want to be able to have more options under my edit columns >"add fields" section when customizing and adding more fields. We need more transactions, GL account … -
How to export all rows at one go in OTBI DashboardsSummary: Hi, We have Dashboard created with OTBI Report , when we export data by OTBI report 1440 records are exported. But when we export by Dashboard only 13 rows are …
-
What role should be given to end users?Is it necessary for end users to only be able to view the latest version of the report, without being able to edit or view the dashboards? To prevent them from editing t…
-
PAY_RUN_BALANCES missing the last_updated_columnI'm a newbie to Fusion. I'm looking for a date column to pull the data from the pay_run_balances table for a quart-yearly HR payroll plans vs actuals report. The table i…
-
Issue with VAT Details Report – Cancelled and Reversed Postings Not IncludedIs it possible to obtain the VAT amounts of a cancelled posting and its reversal, as apparently the system does not support it Any insight, workaround, or confirmation o…
-
Calculated column totals incorrecti am working on Margin analysis for the group of companies , in that i have calculated revenue column , calculated margin and Percentage of margin , individually margin …