Popular Tags
- OTBI 1,427
- Reporting 1,383
- FDI 1,060
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 428
- OAC 402
- Analytics 381
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 255
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Community
The Oracle Analytics Community helps connect with Data, Analytics, and AI experts, explore forums, events, user groups, idea labs & share data visualizations.
Discussion List
-
325C Default Time Zone is lost on Schedule Reports when the calendar is selectedSince 25C when scheduling a report, the default time zone shows the schedule tab, for us its GMT. Once the calendar is selected the default is now (UTC-11:00) Midway - S…Julie Watson 50 views 5 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab -
Need backend query to fetch audit details of Job profileHi, We have enabled audit for jobs and trying to fetch the job profile details through BIP Report who, when and what are the changes that are made but somehow we couldn'…Anjana Bharidey 8 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Using report parameter to call different excel template in different layoutHi, We have an requirement from our client. They have more than 10 RTF different template for a report. When the user run the report, user have an option to choose which…Yeung Shing Keith 13 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Is there a way to find all data models using a specific field?I asked Oracle this question years ago (and the answer was no), but I wanted to check again with this group to see if anyone found a way to accomplish it. We need to fin…Scott Paulin 21 views 4 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Is there a REST or SOAP API to post receipts to the ledger in Oracle Cloud Financials?Hello everyone, I'm currently working with Oracle Cloud Financials and looking to automate the process of posting cash receipts to the general ledger. In the user interf…
-
46Increase in OTBI Analysis row limitOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): In Oracle OTB…Ranjithkumarrr 1.7K views 2 comments 46 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
SQL to get individual compensation plan items to show under Additional compensationI want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and option…
-
11Option to increase ACL limitOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): WM Morrisons Supermarket Limited Desc…Pradeep TU 352 views 4 comments 11 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Difference between FDI and OBIEECan you share the differences between FDI and OBIEEUser_U0OY6 19 views 2 comments 0 points Most recent by MandeepGupta Oracle Analytics Cloud and Server
-
OTBI analysis - problem with left outer joinHi, I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submit…User_RD03L 68 views 2 comments 0 points Most recent by JustinLitalien Oracle Transactional Business Intelligence
-
1Supply Chain Command CenterSupply Chain Command Center is an Intelligent Application built on top of the Intelligent Applications Framework in Fusion Data Intelligence. The basic framework for Int…Krishna Prasad Kotti-Oracle 15 views 0 comments 1 point Started by Krishna Prasad Kotti-Oracle Oracle Analytics Sharing Center -
6Use PAC to reach all private cloud and on-premise services (FTP-SMTP etc)Description Hello, actually PAC (Private Access Channel) guarantees only DB data connection, but if you use Publisher to send files via FTP or EMAIL notification, PAC do…Andrea D'Angelo 78 views 4 comments 6 points Most recent by Melanie' Oracle Analytics Cloud and Server Idea Lab
-
5Ability to identify orphaned scheduled Agents & Jobs after their owner leavesWe are having tough time with identifying orphaned agents and BIP jobs which are running and sending alerts by employees who are no longer with the company. With OAS 9.0…User_SI7HK 14 views 0 comments 5 points Started by User_SI7HK Oracle Analytics Cloud and Server Idea Lab
-
3OAC Classic - Control over which folders are automatically expanded in the dashboard menuDescription On opening the dashboard menu in OAC Classic, a number of folders are automatically expanded. I understand this is by design and "The menu uses a certain amo…Phil Walker 22 views 2 comments 3 points Most recent by User_SI7HK Oracle Analytics Cloud and Server Idea Lab
-
3Dynamic display of sets of columns in OTBI or BIP reporting tools depending on run locationOrganization Name Marriott Description Hi We have a gap in our requirements where we need the reports to only display country specific columns. We want our reports (BIP …Michael John Sabaco 14 views 2 comments 3 points Most recent by Rodrigo Baca Oracle Transactional Business Intelligence Idea Lab
-
Fiscal Year / Fiscal Period filters not applying correctly in AP Expense subject area workbookHi, Relatively new to FDI and trying to create a simple table visualisation from the Financials - AP Expense subject area but the Fiscal Year and Fiscal Period fields ar…Elaine Hendry 30 views 6 comments 0 points Most recent by Gianni Ceresa Oracle Fusion Data Intelligence
-
Not receiving totalResults value while using filter in /hcmRestApi/scim/Users restAPIWe tried using the below query: https://hctz-dev2.fa.us2.oraclecloud.com/hcmRestApi/scim/Users?totalResults=true&filter=(active eq true) to find all the active users in …
-
How can we calculate total Off Cycle Payments using the standard columns available in HCM SAHow can we calculate total Off Cycle Payments using the standard columns available in HCM SAViswanatha Reddy Patil 19 views 2 comments 1 point Most recent by Gianni Ceresa Oracle Fusion HCM Analytics
-
Insert base64 QR Code data in Oracle FusionHello Oracle Community, We are working on implementing eInvoice solutions for our client. From the API, we receive base64 QR Code data, which is 16,000 characters in len…User_V9TJK 17 views 4 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
111Use .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.3K views 56 comments 111 points Most recent by NicolòD Oracle Analytics Publisher Idea Lab