Popular Tags
- OTBI 1,426
- Reporting 1,383
- FDI 1,060
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 428
- OAC 402
- Analytics 381
- 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
-
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art… -
How to enable email bursting for Print Commercial Document Report?Hi, I was trying out the bursting method for print commercial Document process but it seems to be failing even on the slightest changes to the bursting query. I wanted t…
-
Require navigation path and calculation in OTBI Subject area 'costing - work Order Costs Real Time'In OTBI Subject area 'costing - work Order Costs Real Time', we require the application navigation path and calculation logic for the following fields: 1) Work Order Cos…
-
How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called … -
How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f…
-
Unable to Add More Than 5 Columns in OTBI Pivot TableHi everyone, I’m creating a report in Oracle Fusion OTBI based on a data model, and I want the report to be displayed as a pivot table. However, when I try to select the…
-
Employee Final Feedback not returning value in OTBIWe Are using the subject area Workforce Performance - Performance Rating Real time and we want to get the below columns Digital Signature Employee Final Feedback We are …
-
BICC extract failing for HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVOSummary: We are getting error while extracting data from below data store. the BICC job runs for phenomenally long time and then errors out. This is happening only in on…
-
How do you keep Row Numbers cascading?When adding a Row Number Column in OTBI using RCOUNT(1), how do you prevent the row numbers from changing order when you sort the report by a different column? We want t…
-
OTBI is NOT pulling Pending Workers Licenses/Certifications InformationHello, Need some assistance here! We are trying to create a report that will pull all licenses/certifications that have been updated in the last 7 days specifically for …
-
OTBI Logical SQL complex query assembler - Updated to 10 subject areasSummary Combine analyses from up to 10 different subject areas Content While building a report on OTBI, you will encounter some cases where the Subject Area will only pr…
-
OTBI Assignment Event Future dated positions missing position name/codeI have a report that is picking up assignment changes in the last week, which is based on the subject area Assignment Events Real Time. For future dated changes to an as…
-
How to limit values prompt dashboard values when using choice list valuesHello, In a dashboard Prompt we are using column prompts we want to limit the values based on the business unit access for users. The OTBI Dashboard is showing only the …
-
When data is export from Analysis, date is showing in different format:Summary: When data is export from Analysis, date is showing in different format: Export>Data>Excel… then date is exported in different format. Required Format : dd/MM/yy…
-
-
Is there is a way to see who created an OTBI Report in the reports & analytics folder?Summary: We are looking to know if there is a way to see who created an OTBI Report in the reports & analytics folder? Tough there is an owner listed; we are finding tha…
-
Clean-up of reports required to not slow down PRD pod or make it even unusable?In our project we have several reports scheduled via data analytics. Some of them need to run daily and some of them have an output for about 0,5 GB. My question now is …
-
Can the 'Sent File Name' column in payables be exposed into OTBI?Summary: One of our users has asked if the 'Sent File Name' field in payables (payments) can be exposed into OTBI to be reported upon (subject area: Payables Payments - …
-
Expense cost center, balancing segment, account, natural account is not visible in OTBISummary: While I create an OTBI for an Expense Report I saw the field Cost Center, Balancing Segments, Natural Account, Company, Product, Project and Account when I clic…
-
hierarchiesis possibile to create otbi subject area "General Ledger - Transactional Balances Real Time with hierarchies?