Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,113
- Analysis and Data Visualization 984
- BI Publisher 852
- Analysis 681
- Oracle Fusion Analytics 583
- Administration 555
- OAC 447
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 354
- Security 293
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 175
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
-
What privilege grants access to data in the Purchase Order Measures folder columns?I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role… -
How do I convert comma separated values to columns in OTBI ReportHi Team, How do I convert comma separated values to columns in OTBI Report. For eg- We have created a multiple select choice list field and data is showing in comma sepa…
-
Recommended frequency to extract the active primary keys/application dataWe are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics (one time full load followed by incremental loads). Noticed that BICC…
-
HCM - Calculate average number of goals per employeeHello, What would be the best way to Calculate average number of assigned performance goals per employee with breakdown per department? Formula needed is = Total count o…
-
Oracle Catalog Manager DownloadCould anyone please provide URL to downloading catalog manager? I have request to pull all reports using X column and found through other community posts that catalog ma…
-
OBIEE - Creating Agent from Analysis with "Is Prompted" fields - returning 0 rows.Hi, First time post here with hopefully a simple question. I have created an analysis with various prompts; on the analysis there are also 3 fields that are set as “Is P…
-
BIP Keep rows grouped together so they don't break between pagesWe have a custom PO BIP report and each record (PO line) of the PO is comprised of three rows within a table structure (for-each repeating element). The issue we're faci…
-
OTBI duplicate linesHi. Does anyone have any idea how to deal with duplicate lines in OTBI? The subject are we are using is Receivables - Standard Receipts Application Details Real Time. We… -
Having drill down BI Publisher report using rtf template, how can we rename tabIt shows RTF Template window tab but we would like to have it renamed and showing either the BIP layout name or report name. Howe can it be done ? Thanks.
-
BICC : Last Extract Date for PVOs reset only if the Extract Schedule completed successfullySummary Update the logic to ensure Last Extract Date for PVOs resets only if the whole Extract Schedule completed successfully Content Currently, we have instances where…
-
How export more than 25,000 rowsHello, I have a question that frequently comes up among colleagues who use OTBI for report extraction. There are two ways to export data: Formatted > Excel Limit of 25,0… -
Workforce Mgmt - Areas of Responsibility does not extract Responsibility Type linked to RecruitmentGood morning We have an OTBI report built using the subject area: Workforce Management - Areas of Responsibility with the following fields: Person Number Display Name Re…
-
Schedule an OTBI agent to send the analysis using parametersHello, We have created an OTBI analysis, for which the parameters are as follows: --Year to Date; --Ledger ; Also, I created an agent to send daily by e-mail the report …
-
Context Value in Work Relationship subject areaHello experts, does anyone can help me better understand what type of information refer to the following fields of the Workforce Management - Work Relationship Real Time…
-
How to fetch the lookup codes and lookup Types created in Fusion HCM into OTBI reportHello All, we are using a OTBI analysis (Subject Area - Workforce Learning - Learning Records Real Time) to fetch the Learning Records for a few particular courses. so, …
-
How to create an OTBI report to count all employees with no goals assignedHello, Need to create an OTBI report to count all employees with no goals assigned or with no individual goals assigned. When using the Workforce Goals - Goal Status Ove…
-
How to get industry name from receivables in otbi(receivables-customer real time)Hi we are joining two subject areas receivables-customer real time and receivables-transactions real time through (bill to customer number and organization number), we a…
-
Talent review template name column subject area for otbiHi, We are in need of assistance to locate the OTBI subject area for the following columns: Talent Review Template name Selected Population Employee Name Selected Popula…
-
Excel report only showing parameter page and not data page when burstingSee attachment. When I run the report online it works. When I orride the bursting, it works. When I schedule with DM Bursting, the excel spreadshhet has the parameter va…
-
OTBI Last Accessed Folder or Default Folder OptionI've noticed that when using OTBI, it doesn't retain the last folder I was in when I return to the tool. Each time I log in, I have to manually navigate back to the fold…