Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,175
- Fusion AI Data Platform 1,029
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 604
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 416
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 275
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
19OTBI Link to Payables Invoice ImageOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Wincanton Description (Required): I a…DennisOliver 485 views 8 comments 19 points Most recent by srirams Oracle Transactional Business Intelligence Idea Lab -
How to report on Historical Organization Hierarchies?We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy is showin…Mark Stoker 31 views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum -
Are there alternative ways to format display when there are "no results"?I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data. For example, I've got a Projects dashboard I b…RyanPE 31 views 3 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence Forum -
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 …Sinem Ozmen -Oracle 1.5K views 12 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence Forum -
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 …Vikas V. Kamat 71 views 2 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence Forum -
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…diego m schenquerman 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence Forum -
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…Jo Adoniadis 21 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
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…Jo Adoniadis 11 views 1 comment 0 points Most recent by Jo Adoniadis Oracle Transactional Business Intelligence Forum -
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).…Josue Jimenez 101 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
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 81 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 171 views 19 comments 1 point Most recent by Dolly Singhal Oracle Transactional Business Intelligence Forum -
13Automation of OTBI reports for version source control and deploymentOrganization Name Pengurusan Air Selangor Sdn Bhd Description We are looking for the mechanism to automate the archive and unarchive steps of custom BIP catalogs from Re…User_BKC13 421 views 3 comments 13 points Most recent by Sri Prasanth Oracle Transactional Business Intelligence Idea Lab -
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 31 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