Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- 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
-
Counting number of rows up to a specified value by an idHello, I have a dataset with id, test date, test_type, test result. ID Test_Date Test_Type Test_Result 1 2024-03-21 A Fail 1 2024-04-21 A Fail 1 2024-04-30 A Pass 1 2025… -
How to ensure the relevant BU Data Access for OTBI reports?Hello, I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from …
-
divide two row values using same column of OTBI analysisHi, Each of the two rows is derived from analysis of same subject area. The reason for this design is i cannot accommodate two different conditions in same analysis so I…
-
OTBI Report based on AOR.Hi Team, There is a requirement to have the OTBI report output based on AOR. I have done the necessary setup and have verified from UI that the data is restricted based …
-
OTBI Unable to see a DFF in the Procurement Purchasing Agreement real timeOTBI Unable to see a DFF in the Procurement Purchasing Agreement real time. I have 4 DFF's and I am unable to see it. I ran the " Import Oracle Fusion Data Extensions fo…
-
Which table holds audit data or historic LC Expiration date under supplier master business classfi..Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
-
Send notification to line manager based on reportI have built a schedule based on a report however even though the report contains the data it is not bring this back in the email. This is the message in the email I rec…
-
Scheduled query not bring back and dataHi, I have created a report to send a notification when a certain trigger has been hit but it is not bring back the data, I have created the test data so know there data…
-
How to add an imagen in the report RTFI have a query to extract the image from the items, but I can't add it to a report because the image or the table field doesn't have the information in base64 (encoded).…
-
Overtime status is not showing data in workrelation subject areaHi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fix the iss…
-
How to add parameterized OTBI report on InfoletSummary: Hi Team, We have created parameterized OTBI Report and a dashboard with prompt. However when we add them to infolet , but infolet is not asking for parameter an…
-
-
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…
-
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 to create a condition based column in Column selector in OTBI Report?We are creating an OTBI report in which we want to use column selector . Inside that column selector, we are trying to add the condition based column but we are unable t…
-
How to provide the gap between the 2 bars in bar graphHow to provide the gap between the 2 bars in bar graph
-
Why does the value for CUSTOMER_ANNUAL_REPORTING is changed to mixed case?Hello, I am updating activity report. The field Subject COMED have multiple values, and I used REPLACE to use the Subject COMED as filter. (REPLACE "Activity Extension".… -
DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there …
-
Content of different email fields in OTBIWe noticed that the email data that we get for the learners from OTBI is inconsistent and would like to know where those differences may come from and which OTBI email c…
-
OTBI - Benefits Enrollment Realtime - Unable to pull the dependent data for a benefit planI am trying to create a OTBI report, which includes person number, benefit plan and covered dependents for the plan. Seeing blank data for the dependent information colu…