Popular Tags
- OTBI 1,360
- Reporting 1,350
- Analysis and Data Visualization 895
- FDI 879
- BI Publisher 787
- Analysis 652
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 321
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 212
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 178
- BI Publisher Report Templates 177
- Agents 148
- Customizing Reports 141
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
-
Dashboard Prompt Not Updating Analysis TableI'm having an issue with my dashboard setup. I have a dashboard that includes a prompt and an analysis. However, when I select a value on my prompt, the table in my anal… -
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…
-
How to Show Two Columns As OneI have a report in OTBI that uses the Workforce Management - Processed Time Cards Real Time subject area. Two fields are included in the query, Absence Type and Hours Ty…
-
How to query PVO in Oracle BI Publisher Data ModelI need to query PVO data in BI Publisher, here's the PVO name: HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue Any screenshots, ideas, hints? Thanks.
-
how can i extract "The date that the invoice was sent to the client"how can i extract The date that the invoice was sent to the client The amount of days between when the final approver approved an invoice to when the invoice was sent to…
-
Can we create Inventory transaction costs report?Can we create Inventory transaction costs report using two subject areas Inventory Transactions real time & Costing standard cost time? Item Name Transaction Date Invent…
-
sql query to get recorded absences on their time cards in oracle fusion cloudHi All, SQL query to get recorded absences on their time cards in oracle fusion cloud hcm
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…
-
How to translate the data in a BIP Report to another language?We have created a BIP Report where English(en-US) is the default language. We want the data as well of the BIP Report to be translated to another language(Specifically S… -
How to Access OTBI report using Groovy within Oracle FusionHow to Access OTBI report using Groovy within Oracle Fusion
-
Need translated names in the otbi report.we have developed otbi report for Workforce Structure for one of the UAE client, in that customer requires translated names to be reflected along with the English names.…
-
Merging 2 PVOs for 1 BICC ExtractHello Team, Can we merge 2 PVO to create a single extract for BICC. Currenly we tried and it is giving 2 extracts. Any guidance would be helpful. Regards,
-
Projects - Performance Reporting Real TimeHere In above report I am trying to print class category column values as a separate column like GP Budget,GP Plan Year and GP Project Category. also want to print the v… -
How to navigate to fusion Sales Order page from otbi analysis aggregated fieldWe are trying to develop an OTBI report showing past due orders as a bar graph with range of days and count of orders in that range. Requirement is to click on 'count of…
-
Can i create custom heading in OTBI report?This is an example of what i want to achieve the first image is created in excel, the second is in OTBI can we have Custom Header like in excel. Regards, Omran
-
OTBI Expression not workingHello, We're creating an OTBI report that fetch employees time card details. Please see below requirements If employee did not work on a holiday, it should return 'PH' I…
-
UK PAYE Scheme Reference Number LocationI am attempting to output the PAYE Scheme Reference from the Payroll - Calculation Cards Real Time Subject Area but am unable to locate the column header. Can anyone adv…
-
OBTI report for Maintenance programFor a Maintenance Program forecast i want to make a OTBI report that anyone can easily understand the activities. The built-in Program Gannt chart is very difficult to u…
-
Generate report for Transactional tables in API want to create a data extract for transactional tables (AP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALL etc). I cannot find the Views for these tables in Financials to …
-
I am trying to build an OTBI report that shows PRS with the statusI am trying to build an OTBI report that shows PRS with the status, if it's pending approval i need the name of the current assignee Is it applicable by OTBI ?