Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- 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
-
How to Stop Duplication of Billed Amount in AnalysisI am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense report level.… -
How to Connect Item/Category to Task/Project via DataModelWe are in the process up updating a report, one that provides Item and Category descriptions, in order to try and find the associated Task Number as could be found on a …
-
Supplier DFF creation using REST APIs as a part of Supplier creation EndpointHi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a libr…
-
what is the issue of below logic in FAW?cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code…
-
OTBI Analysis to get Working Days count and total hours spent by employee in given date RangeDear Team, I was trying create a Dashboard with multiple Analysis and Graphs. One requirement is to get Working Days count in the given Date Range and Total Work Hours s…
-
Saved Customization report being deleted in OTBIUser cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently. Description of need: To have an audit log on …
-
SA- Payroll Element Entries Real Time - Filtering Displayed Input Value using Input Value nameHello all, Trying to create an allowance report using the SA - Payroll Element Entries Real Time, I have this so far I would like to remove the 'Input Value Name' column…
-
Payroll Legal Entity Registration Unit Field NavigationHello everyone, I have a requirement that needs to be pulled into the report, and I want to map it first in the UI/Front End. Can anyone provide where to find this field…
-
Issue when subsequently calculating from formulas containing FILTER functionBackground I have a single Oracle DB table set up as a basic Subject Area, comprising of one row per person per calendar month, showing data as of the last day of the ca…
-
How can we confirm impacted reports before removing the subject area access from some rolesThere are many reports are developed using some subject area and saved in different folders. Can i check how many reports would be impacted before removing the access? F…
-
Hiring manager and recruiter's full names not displayed in anaylsisHello experts, we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear fr…
-
Supplier DFF creation using REST APIs as a part of Supplier creation EndpointHi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a libr…
-
Oracle BI Publisher Silent InstallationThe Official installer for the BIPublisherDesktop is provided in .exe format. The official command that is being used is BIPublisher64.exe /S /v/qn The installation fail…
-
-
Due Date field from Receivables Transaction Real Time is not displaying any data/valueEven though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Receivables: …
-
How to source: Profile Item Id in OTBI to populate spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
OTBI Performance tiles for non measure fieldsHi, We would like to create a performance tile in OTBI analysis that will count distinct SR references that were opened in the last 2 days. Meaning, we want to use a dim…
-
Embed Hyperlink on Fusion UI to OTBI analysis with parametersHI, I want to embed a Hyperlink on my Fusion UI to an OTBI analysis with parameters. Thus: I have added a Hyperlink Component on Fusion UI and gave destination path to a…
-
Implement a dynamic default value for a DFF field based on another DFFCan anyone help with a SQL query - To implement a dynamic default value for a DFF field based on another DFF field in edit mode, ensuring that values captured in Task 1 …
-
Embedding OTBI Report Directly in HCM without Page Composer or Page IntegrationHi there, I'm wondering if there are other ways to embed reports or include links to reports directly in HCM without using Page Composer or Page Integration tools. I saw…