-
Request to Increase Data Export Limits
Due to customer requests, we would like to increase the data export limits from 400,000 to 1,000,000 rows when exporting to formatted reports from analyses and dashboards on the 16 OCPU.
-
Global setting to add for All report In Oracle Analytics Publisher
We kindly request that a global setting be implemented for all reports in a single step. The report properties should be modified to reflect the global settings, as we are currently unable to adjust the settings for each individual report. A default setting that applies changes across all reports would be highly…
-
Creating Datasets - Full DISTINCT List of Values for Columns
Currently, when creating datasets, the dataset size limit is also limiting the list of values users can see in the column distribution and filter values available. This does not provide a holistic picture to users on data available. We need the column list of values to be separate from the dataset row limit to allow a full…
-
Set number of visible decimals of a measure via a calculation
Hi everyone, I'm currently building a report that has a varied audience from top level management to first line manager. The numbers we show range from a few k$ to m$. All our reporting is built to be as consistant as possible so for example, In a report we should only k$ or m$ so there is no missunderstanding on how the…
-
New health check /send string required for OAP without any user/password authentication
After OAP standalone installation was upgraded to version 7.6 (Linux x86-64) of a clustered setup with 2 bi_server instances (bi_server1 and bi_server2) each health check from the loadbalancer generates a stack trace output in the bi_server<X>.out file. The most likely reason is that the content of /xmlpserver/services is…
-
OAS 2023: OAS Metadata tables in BIPLATFORM should have Dataset name along with object ID
Hi Team, Current OAS configuration stores Dataset's object id as a plan name in DS_REQUEST table under BIPLATFORM schema, there should be another field or plan name should ideally show Dataset name. Object ID is always different from the dataset's name while creating a copy of the dataset. This leads to difficulty in jobs…
-
OAS -DV-Snowflake JDBC connection- Parameter To Support Key Value Pairs
It would be helpful if we have a textbox as part of the connection definition screen that accepts free text to support key value pairs for correct driver/additional configurations. Note: This is already available as part of the weblogic snowflake-Datasource definitions. Current connection string Vs Expected connection…
-
Create hierarchies from DV front end, Data Set, or Data Flow
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): HID Global Description (Required): Need the ability to create hierarchies on the fly, like Power BI, with custom data sets or in DV front end. Use Case and Business Need (Required): Any…
-
Interactive Viz title for View By analysis
DV visualizations have a title generated based on the grammar definition of the visualization as shown in the scatter below. The scatter viz uses the metrics and attributes in the core grammar drop targets to generate a viz title by default that can be further customized. This idea is focusing on the measure, attribute…
-
Conditional Formatting based on attributes
Currently in any visualization, conditional formatting can be done using measures. We have a requirement to add this functionality based on Status column which is a attribute but OAC doesn't support that.
-
OAC Search Functionality - Default to ALL
OAC users have raised a concern for the way the search default location in OAC appears, compared to OBIEE. They would like the default search path to be ALL (instead of the starting folder). This way OAC objects located in any folder are part of the search. (this is not about checkbox for include sub folders. High level…
-
Bookmark Link in DV
Organization Name GSO Description An option to create a bookmark link based on the customizations performed on a certain canvas: filters appplied, changes performed on visualizations, etc. This option should be available only for end-users (in Read-Only mode). Use Case and Business Need Like in Answers Dashboards it would…
-
Digital Signature Printed on 2nd Page in PDF
Digital Signature needs to be printed also on second page (and subsequent if any), not only on the first page of the PDF output
-
Running Data flow from Dashboard
There should be some option to run the dataflow from Dashboard itself. A dashboard user who only has viewer permission, if needs updated data should have an option to trigger the run of dataflow at the back end rather than waiting for schedule trigger.
-
Notification for failed Dataflow/Sequence
There should be an email notification to the user / owner of the Dataflow , sequence so that user can attend to the failure immediately.
-
Alternate values in Bars/Charts
There should be some capability to show the alternate values in the data labels in the bar/overlay charts. Sometimes the data values get overlapped and should have such option to skip the values.
-
Scrolling Issue in OAS while including columns
Issue: When accessing a dashboard to generate a report, we begin by selecting the required prompts. Upon obtaining the results, we may attempt to add a column to the report. Given that there are over 40 columns available for inclusion, navigating to the desired column becomes cumbersome. Specifically, scrolling through the…
-
Workbook Canvas Navigation
Navigating between canvases in a workbook with multiple canvases that extend beyond one page is challenging. It would be helpful to have an option similar to excel where you can click on the canvas tab, and see the names of all the other canvases, and select one to easily navigate to.
-
OAC Analytics : add a specific privilege to grant custom Data Format (HTML, Image, ...)
Hi, Today in OAC Analytics, we have only one privilege "Formatting/Save System-Wide Column Formats" to grant access to Override Default Data Format in "Column Properties/Data Format" with all items in the list (HTML, Image, ...) and to save System-Wide Column Formats. I only would like to grant BI Content Author users to…
-
The aggregation for Assignment count don't add up correctly in grand total
The default metrics assignment count displays the correct current total in subtotals/totals when a time dimension is not chosen. However, there are additional rows (in this case, President's Council) displayed creating a very confusing visualization because 9+1+9 is 19, not 18. This happens in both pivot and table view.…
-
Ability to hide rows/columns in a pivot visual - when no data present per filter selection
Details : When no data is selected for a parameter or a usual filter, there should be a functionality to hide the column/rows , At present, the column/row just remains in the pivot visual. Use Case and Business Need : This is an important functionality for DV Developers and consumers to be able to have a clean and clutter…
-
OAS - New Visualization - Racing Bars
The Oracle Analytics Extensions Library, available at the link below, has many additional visualizations that could be highly useful to users. Two that are particularly beneficial to our team at the moment are the Racing Bars and Funnel charts. However, these extensions are not officially supported by Oracle, despite being…
-
Ability to Arbitrarily Order Visualization Data Columns
Currently, visualizations (stacked Bars for this example) have limited options for ordering- alphabetical or reverse alphabetical only. However, oftentimes neither of these options meets business needs. For example, suppose we wanted columns to present in the following order |PY MTD| |PY YTD| |CY MTD| |CY YTD| |Q3 Plan|…
-
Ability to choose how the Multi-sheet excel data interpreted when imported
It is curretly possibly to import an excel file with multi-sheets however all the sheets are interpreted and model as a data mart model and the relevant joins are also suggested. However in one of my customer site it is the similar data provided by different team but it came as multiple sheets in the excel. It would be…
-
Restrict characters in the Analytics catalog
When working with the CLI tool for the analytics catalog certain characters cause issues when specifying the catalog object to be modified. Other systems like for example Windows have features that prevent a user from entering restricted characters when renaming a file. We would need a similar feature for preventing users…
-
Data Viz - multi-language support for data set column names
Organization Name HSBC Plc Description Hi, we are trying to modernise customer dashboards by producing visualisations and home pages using Oracle Data Viz. However we are receiving push-back on this strategy because Data Viz does not have the same multi-language potential as BI Dashboards. The key requirement is the…
-
Field sorting in Jobs and Schedules tabs of Jobs Area of OAC Visualization
Description In OAC Visualizazation: 1) Navigate to Jobs Area 2) notice fields in Jobs and Schedules tabs It would be nice to be able to sort on these fields by adding a Sort By picklist similar to what exists in Catalog and Data areas of Visualization. Use Case and Business Need This idea will allow the user to sort jobs…
-
Custom Order Table/Pivot Table rows
It would be good to be able to have custom ordering of rows in Pivot Tables and Table visualisations that isn't based upon Alphabetical or High/Low. My organisation has a preference to display certain divisions in a certain order that is not based upon a numerical value or alphabetical order. I appreciate Parameters can be…
-
Branded uniform method of user timeout/logout with redirection to a stable login location (SSO)
Having searched through some of the ideas here on the lab I have seen this topic spoken about a few different ways. In OAS 2024 we are seeing where a user's session is timed out they are sent to a default Oracle Sign in page. ../bi-security-login/login.jsp Not only is it not branded, the issue is that our users are…
-
Incorporate OAC Client Tools into the OCI SDK
Our team is looking to eventually automate the deployments of the Semantic Model through an end-to-end CI/CD workflow. Current State: We use Oracle Visual Builder Studio to manage a git repo that contains the JSON files that make up the Semantic Model. We use the OAC Semantic Modeler tool to pull from our git repo, make…
