-
Enhancement about OAC extraction performance achieve even for reports with a large number of rows
【The definition of improvement】 We can't found anything common characteristics in terms of "design" and "functions used" for OAC reports that increased BI (OAC) 's response time compared to BIEE. The only commonality was that those reports has a large total number of column x row cells. 【Enhancement Request】 We would like…
-
OCI Logging for OAC Enhancement on Catalog Permissions updates
Use Case: The Audit logs available via OCI Logging enables administrators to identify the changes to catalog objects, specifically permissions. For example, When changing the permissions on some Shared Folders with Sub-Folders, whether for testing purposes or by user error, The only way to revert the changes is by…
-
Option to select Excel column headers
Description When importing an Excel dataset into OAC’s Data Visualisation, there is no option to select the row to use for column headers. The 1st row is used by default and there is no option to override that. Use Case and Business Need The only option available currently is to alter the Excel worksheets and to place the…
-
Resource/Service Principal support for Storage and Auth payloads for Snapshot APIs
Hi Team For security & compliance reason we(OCI HORIZON team) are advised to get rid all the local users, but currently OAC snapshot/appmodule APIs only support user principal for Storage and Auth payloads. This is a major blocker for our automated snapshot/appmodule deployment process. Can you please provide support for…
-
Running Sum option
In classic we have option "Running Sum" under Pivot table. We should have similar option in DV table and Pivot table.
-
Validations in the National Identifiers for the Bahamas country based on Gender and Date of Birth
Hello, Customer want validations for the National Identifiers for the Bahamas country based on Gender and Date of Birth (Month and Year). Validation Table for NIB number and DOB Gender Q1 Q2 Q3 Q4 Males 1 2 3 4 Months Jan-Mar Apr-June July-Sept Oct-Dec Females 5 6 7 8 Months Jan-Mar Apr-June July-Sept Oct-Dec Example NIB…
-
Manage overlap of data labels in line graph
We need the ability that OAC manage smartly "Data Labels" in line graph. When we have many data points those data labels could frequently overlap each others like in the following screenshot : This is quite unaesthetic and unreadable. "Tableau" could manage that by displaying only some data value labels in a smart way.…
-
Enable Data Action Link when DV Project is integrated in Classic BI Dashboard
Organization Name Deloitte Description The data action option works when DV Project is opened directly but when DV Project is embedded in Classic BI dashboard, the data action link option disappears. This is restricting to use dashboard and DV together as key drill-down functionality is lost. Use Case and Business Need…
-
Excel & CSV Export Date to Use the Correct Time Zone
Currently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis and Report Limits (oracle.com)). This approach makes this data of no or limited value to most businesses and users. The time zone in which businesses…
-
Enhance the Google Analytics 4 connector to allow for historical data.
Filed on behalf of TEKTRONIX INC This connector only gives us real time data on very few metrics. There is not even a date field as a starting point. See Power BI connector to Google Analytics or Google Analytics Data API and see for yourself that what is provided right not is really not a solution the connector seems to…
-
Allow use of session variables in dataset role-based filters
Allowing the use of RPD session variable values in a dataset role-based filter would be a huge step in security for our instance of OAC. Currently, we have row-level security on RPD subject areas that allows a user to only see HR/payroll data for departments they are authorized to see in our PeopleSoft HMS instance. This…
-
Repetition of sub-headers across slides in Data Visualization workbook for power point export
Hi team, We are having a requirement to repeat subheaders across multiple slides while exporting as powerpoint. This is essential for users to identify metrics in each slides without scrolling to the first slide in the case where the export is spread across multiple slides (especially for large volume of data). Attached…
-
Having Wrap the "boxes" in the Selected Columns of the Criteria tab, instead of having a scroll bar
Mayo Clinic user request -: Can we please wrap the "boxes" in the Selected Columns of the Criteria tab, instead of having a scroll bar that goes on and on when numerous dimensions & measures are selected? I have attached a screen shot of the request. When the columns are wrapped we see all of them in one place compared to…
-
Monitor Deliveries - recipients and export resultlist
In Monitor Deliveries, you can get an overview of current deliveries/agents. I however, I miss the possibility to also get a list of which users are recipients on the respective agent. In an older environment with many agents, it gets quite messy - who receives what ? I also miss the functionality to be able to export the…
-
Stacked Bar Chart Total issue
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): LCRA Description (Required): There seems to be a total issue with the Stacked Bar Chart. When we are adding two positive numbers, the correct total is displayed at the top of the Bar (see…
-
Call ODI Load plan From OAC.
Hi Team, We are trying to implement one custom solution in OAC. The objective is to call the ODI Load Plan from OAC using Invoke Web Service. We have gone through an A team blog, which says, the following solution is technically possible in the case of OBIEE. However, we are not getting any Knowledge repository for a…
-
Enable stylesheets on OAC and Oracle DV
Enabling stylesheets would allow for further customisation, accessibility and branding to be implemented on OAC and Oracle DV.
-
Control Dataset access to certain custom role
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Advertising (Oracle Internal) Description (Required): OAC supports custom roles for object level security to restrict access of certain folder content to set of users belongs to the…
-
Feature To change massively the datasources password in the RPD
I would like to request a feature to massively change the passwords of the rpd data sources in the cloud. Many users have different database passwords depending on the environment (development, pre-production, production). When our environments were "on premise" we used the functionality of a jar called…
-
Automated BI cache clearance in Admin Console
Team, In the integration of Supply Chain Management (SCM) and Warehouse Management System (WMS), we rely on Business Intelligence (BI) reports to send details to WMS. However, in some cases, these BI reports pull up cached responses, which do not provide the correct data. I can provide relevant information to Oracle…
-
OBIEE to OACS Migration :USER system session variable holding different values causing issue
We are migrating from On Prem OBIEE (12.2.1.4) to OACS Gen2 (Nov23 release) as part of migration project. On Prem OBIEE instance having USER ID session variable populated with six digit character string for ex. singgae while OACS Gen2 having USER system session variable populated as 7 digit numeric code for ex. 78990000…
-
When selecting a Hierarchy level, customer want to open and close all to the desired levels at once.
Organization Name Oracle Corporation , Jejuair Description Jeju air is using Hierarchy functions well in thier analysis there are many Hierarchy like ( Air Route) they have regions , sub regions and many routes... Use Case and Business Need Issue : one of the requirments is that " When selecting a Hierarchy level, customer…
-
Pipeline: being able to REM a specific job like EPM Automate
We are currently going through the process of replacing all our EPM Automate scripts with Pipelines. The issue is we have specific integrations/business rules that are only supposed to be run during certain periods (Example: start of Budget cycle). In our EPM Automate scripts, we would REM out the line when we don't want…
-
Make Calculated Items/Groups features available in DV
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Czech National Bank Description (Required): We are currently in the process of "promoting" DV (within our OAS platform) to our business users (who use "classical" BI outputs created in…
-
Auditing or governance on DV Usage
Organization Name Consolidated Edison Company Of New York Description Auditing or governance on DV Usage We should have Auditing data like How many connection has been created in DV and who are all have access to those connections. the same way for Data sets and data flows. And even for Projects, and usage tracking for DV…
-
OAS: Support For JSON Payload For Data Action of HTTP API Type In DV
Request for the support JSON Payload for the data actions of "HTTP API" Type in Data Visualization. Currently, it supports only Form Type that accepts only URL parameters.
-
Button or syntax to reset all the filters set on a canvas
Description We have multiple graph on a canvas for example. One graph is the realization for each cluster, next a graph realization for each location and then some other graphs realization for each age category, month etc.. If you want to go back to the situation before the filter set, you have to go to each graph and…
-
Customize the Grand Total Column Heading in Table/Pivot Table Visualization in OAC
In Table/Pivot Table Visualization, the Grand Total Header automatically prefixing the Column Header with Grand Total. Sometimes, the header is very big and couldn't customize the Grand Total Header Name. Business expecting to customize the Header Name as header cell consumes some space and cell alignments are not good.…
-
HTML option in DV
There should be an option to enable HTML for Text Box in DV same as in classic BI. This feature will help users to use Variables(please see below sample code) to give more meaningful text for their workbooks. Also helps to add external content. <html><font face="tahoma" size="1.5"><b>Hierarchy: </b>…
-
Enable “Keep only” function even in the Dashboard when using hierarchy
Hi, I'd like to talk about hierarchy In Analytics, we can select "Keep only " options to drill down to the exact hierarchy levels But Analytics in the Dashboard, I cannot select option to drill down to the exact hierarchy levels and Keep only related, no “Keep Only” function is enabled when I import the analytics So It…
