Popular Tags
- OTBI 1,475
- Reporting 1,406
- FDI 1,205
- Fusion AI Data Platform 1,040
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 613
- Administration 556
- OAC 533
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 421
- Fusion ERP Analytics 411
- BI Publisher Data Models 361
- Security 302
- HCM 282
- BIP 267
- Answers 266
- Analyses 255
- Oracle Analytics Cloud 248
- Developers 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Fusion Data Intelligence 216
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
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…shiva G1 11 views 2 comments 0 points Most recent by shiva G1 Oracle Transactional Business Intelligence Forum -
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…Nidhi Chhajed 83 views 2 comments 0 points Most recent by User_42SLD Oracle Transactional Business Intelligence Forum
-
3Include the open interface tables and the error tables in the OTBI areasOrganization Name Landsbond Christelijke Mutualiteiten Description It should be possible to report upon the open interface tables and the errors that occurred during the…Mmuylle-Oracle 231 views 10 comments 3 points Most recent by Raghavender Oracle Transactional Business Intelligence Idea Lab
-
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 …Swapna Govind 182 views 19 comments 1 point Most recent by Dolly Singhal Oracle Transactional Business Intelligence Forum
-
How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…Luke.Findex 33 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum
-
20Need 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…
-
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 44 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…Nalinee Uppiah 1.9K views 14 comments 0 points Most recent by User_E2AKU Oracle Transactional Business Intelligence Forum
-
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 21 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum
-
13select 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 1.1K views 12 comments 13 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 22 views 0 comments 0 points Most recent by Ramprapanna Bhattacharya-Oracle Oracle Analytics Forum -
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 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Analytics Publisher Forum
-
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 31 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 31 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
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 473 views 20 comments 3 points Most recent by Pijush Biswas Oracle Transactional Business Intelligence Forum
-
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 51 views 4 comments 4 points Most recent by Shyam Patel Oracle Transactional Business Intelligence 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 61 views 6 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence Forum
-
5Attribute-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…
-
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 11 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
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 21 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence Forum