Popular Tags
- OTBI 1,417
- Reporting 1,376
- FDI 1,012
- Analysis and Data Visualization 966
- BI Publisher 828
- Analysis 667
- Oracle Fusion Analytics 562
- Administration 554
- OBIEE 426
- OAC 372
- Analytics 362
- BI Publisher Data Models 339
- Security 282
- Answers 264
- Analyses 253
- HCM 246
- Developers 240
- BIP 236
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 190
- Report Output 181
- Customizing Reports 152
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Automating Email Recipient Updates in Oracle Fusion HCM BI Publisher: Seeking Community InsightsHello Oracle Community, Problem Statement: We frequently receive multiple tickets from the business requesting updates to the email/distribution list recipient list in B…PMDinesh 13 views 1 comment 0 points Most recent by PMDinesh Oracle Transactional Business Intelligence -
14Need ability to add OCI Object Store/Buckets in OTBI & BIPNeed ability to deliver files in OCI Object Storage buckets from Fusion OTBI & BI Publisher. Currently this capability is available from OAC BIP but not an option for OT…User_SAHMO 52 views 4 comments 14 points Most recent by User_Z57T6 Oracle Analytics Cloud and Server Idea Lab
-
OTBI column formula assistance - Change 5 days to 5 working daysI am trying to amending the below column formula to count 5 working days instead of 5 days (which it is at the moment)? I need to exclude Saturdays and Sundays. Can anyo…Tracy Goodchild 17 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
9select all columns option on drag and drop while creating report with data modelDescription select all columns option on drag and drop while creating report with data model Use Case and Business Need It would be better if we have a option to select …Thiru Ch 952 views 12 comments 9 points Most recent by LindsayA Oracle Transactional Business Intelligence Idea Lab
-
Drill through from an OAC DV report into an OTBI analysis (Action Link)Hi Experts ! Greetings ! I’m trying to drill through from an OAC DV report into an OTBI analysis using a URL, but I'm currently stuck on getting the correct URL format t…Ramprapanna Bhattacharya-Oracle 24 views 0 comments 0 points Started by Ramprapanna Bhattacharya-Oracle Oracle Analytics Cloud and Server -
Is it possible to configure SFTP command when triggering extract run?Hi experts, We have a payroll extract that is sent daily to our customer's SFTP server. Sometimes the file doesn't reach the configured destination. To improve connectiv…emtiren 14 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Analytics Publisher
-
1What happens to my OTBI Deeplinks when Redwood apps are activated?Hi, I have a tone of otbi reports that have deeplinks back to Work Orders, Purchase Orders and PO Receipts. What will happen to these links as the Redwood apps replace t…Hylton 21 views 4 comments 1 point Most recent by User_6PFML Oracle Transactional Business Intelligence Idea Lab
-
PAY_RUN_BALANCES missing the last_updated_columnI'm a newbie to Fusion. I'm looking for a date column to pull the data from the pay_run_balances table for a quart-yearly HR payroll plans vs actuals report. The table i…Dinesh T 19 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Benefits - Enrollment Real Time - Dependent Data Not Coming InWe have a basic report that is supposed to bring in Employee and Dependent data into a report and now the report is not reporting on Dependent Data anymore. Either none …JA1 316 views 20 comments 3 points Most recent by Pijush Biswas Oracle Transactional Business Intelligence
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 702 views 8 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
4Introduce WMS Integration status column in OTBIOrganization Name MASSIMO ZANETTI BEVERAGE GROUP SPA Description We are creating a report using OTBI with the "Shipping Real Time" subject area. We couldn't find the col…Bernardo Murolo 31 views 4 comments 4 points Most recent by Shyam Patel Oracle Transactional Business Intelligence Idea Lab
-
104Use .xlsx Excel templates in BI PublisherDescription Currently only .xls Excel templates are available. The idea is to support .xlsx Excel templates as well in BI Publisher. Use Case and Business Need If .xlsx …timvanlith1 3.1K views 53 comments 104 points Most recent by Ajay Samala Oracle Analytics Publisher Idea Lab
-
Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…Sudheer YN 45 views 6 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence
-
3Attribute-Based Values in FDI PivotsThe Ask We'd like to propose an enhancement for Data Visualization (DV) within Fusion Data Intelligence (FDI). Specifically, we're requesting the ability to use an attri…Purnima Mishra 26 views 0 comments 3 points Started by Purnima Mishra Oracle Analytics Cloud and Server Idea Lab
-
Convert Date Field to "YYYY-Qx" FormatSummary Need to convert a date field from MM/DD/YYYY to "YYYY-Qx" format. Content Hi, I’m trying to convert a date field from the standard MM/DD/YYYY format into a "YYYY…aayhindujaswiss 13 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
Why a new role cannot run OTBI reports but can run BIP reports when permissions are the sameWe have created a new role in oracle HCM. The user will be using this role for reporting needs. They can use BIP reports with no issues. But OTBI is causing problems. Th…Max W 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence -
Oracle Fusion OTBI and Data/Role SyncHi Team, I am a Oracle Security Specialist and often have to play with data sync and validate in UI and in OBI layer reporting. When I do a HDL to Bulk terminate users I…Nicolas Trojack 15 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…JITHU JOSE 101 views 3 comments 0 points Most recent by Paula Dyason Oracle Transactional Business Intelligence
-
186Report that provides a list of permissions for all folders in BI CatalogOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): There …Saloni Gupta-Oracle 3.9K views 98 comments 186 points Most recent by Ray Switzer Oracle Transactional Business Intelligence Idea Lab
-
90Detailed log for OTBI AgentOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): University of Northumbria at Newcastl…Bhaskar Konar 1.2K views 24 comments 90 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab