No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
What's New in Autonomous Data Warehouse

New Features and Updates for Oracle Analytics Cloud

Oracle Analytics combines three powerful forces—augmented analytics, self-service analytics, and governed analytics. With embedded machine learning and AI, Oracle delivers a single solution that quickly scales across your organization so that you can get the most from your data. To help you get the answers you need when you need them, Oracle is committed to ongoing product innovation. Here are the latest new features and updates.

October 2019 (Release 105.4)

Catalog & Home Page View


The Catalog make it easier to categorize the analytic assets in your system. The Home Page view on the OAC Catalog now includes all your Content from connections and data sets to reports, dashboards and visualizations. Use Natural language to search or use built-in filters to explore content by type, it will even forgive you for typos with new auto-correct abilities and recognition of plurals!

Access Data: Improved CSV data support


Improved logic and user interface makes it easier to work with numeric data from different locales, especially those using a variety of separators for thousands and decimal values.

Prepare: More built-in preparation steps


Cleaning data is a reality. In this release, Data Flows has added the ability to split columns on a variety of delimiters and Prepare Data has added a built-in Trim function.

Visualization: Spatial: Location Matching


The new location matching feature helps you spot data mismatches between your data set and map layers, making it easier to ensure your visualizations are representing your data accurately.

Visualization: Copy & Paste


Easily reorganize your canvases and reuse great visualizations in new or existing projects. Copy & Paste a single visualization or an entire canvas.

Visualization: Custom Fonts


You asked and we delivered! The ability to customize fonts on your visualizations and canvases gives you even more control over how you present your results.

Visualization: Create Custom Data Action Plug-ins


Data Action Plug-ins enable users to select data-points in visualizations and to invoke specific actions

Visualization: Trellis row (Y2 Axis) improvements


The default position of a visualization’s trellis row is the left side of the visualization. The formatting of the Values Axis is preserved when you change the position of the trellis row to the right side of the visualization.

Reporting: Publisher Data Sources


SSL support for Web Service and HTTP data sources has been added for Publisher.

Reporting: Publisher REST APIs


New REST APIs allow scheduling of normal & bursting operations for Publisher.

Reporting: Publisher Mandatory Parameters


When running your reports online or via a schedule having mandatory parameters helps you ensure more useful and focused results as well as ensure successful execution by placing constraints on what is executed.

Reporting: PBCS Data Sources


When using EPM Cloud 19.08 additional properties will be available for dimensions including the generation number, leaf indicator, member path and alias path and attribute dimensions.

Data & Security: Kerberos Authentication


Multiple new data sources are supported for use with Kerberos Authentication: Apache HIVE, Pivotal HD HIVE, MapR HIVE, Hortonworks HIVE, IBM BigInsights HIVE

Data & Security: Encrypted data sources


SSL encryption is now available for more data sources including: Apache HIVE, DB2, Hortonworks HIVE, IBM BigInsights HIVE, MapR HIVE, Pivotal HD HIVE, Spark, SQL Server

Data sources: Remote Data Gateway


Remote Data Gateway makes it easier for users to connect to sources they frequently use by leveraging their existing desktop connectivity. RDG is now available for Impala, Spark, Apache HIVE and MySQL.

Data sources: Data Replication


OCI Object Storage is now available for Data Replication

Administration: Safe Domains


A redesigned page makes it easier for you to register your safe domains.

June 2019 (Release 105.3)

Self-Service: Visualization Types


Language narratives bring your analyses to life, helping users who may be less familiar with your data understand the full scope and context of your analysis. New options allow you to control settings including language, level of detail, and type of narrative analysis such as trend or breakdown.

Self-Service: Tooltips Improvement


This enables you to see specific information pertaining to data points in your visualizations faster than before. Use the tooltips field to adjust the content for a visualization or to turn off tooltips. When you hover over a data point in a visualization, a tooltip displays specific information about that data point.

Self-Service: Refresh Embedded Data


Need the data in your HTML pages to be as current as possible? Make sure that the data in your visualization is relevant by configuring the refresh of underlying data embedded in an HTML page.

Self-Service: Select Alias Table


As part of advancing support for critical Oracle Essbase functionality, we’ve added the ability to choose your alias when creating a data set from Oracle Essbase. This allows you to take advantage of enriched or translated data for your members.

Self-Service: Configure Currency Symbols


You can dynamically populate a currency symbol in visualizations based on the configured currency. For example, if you set a canvas filter to display a European ledger, then the Euro symbol is displayed for each measure value that's associated with the custom currency property. The project data must contain a currency code column such as ledger currency. The currency code column enables the display of an appropriate currency symbol for the measure column, such as a profit column.

Self-Service: View Audit Data


You can enable or disable the audit of reports and catalog objects. Auditing helps you track important metrics such as report starts, executions, ends, downloads, job pauses, resumes, and cancellations as well as resource creations, modifications, copies, and deletions. Selecting Enable Monitor and Audit in the server configuration page allows you to log audit data.

Governed: More Options to Scale Services


On Oracle Cloud Infrastructure as a Service, you can now scale up or down within the range of Oracle compute units (OCPU) for your service—without experiencing the system downtime. Scale options aren't available if you have a fixed Oracle Analytics Cloud subscription.

Governed: Redesigned Console


Improved design that’s simple to navigate and easy to use.

Governed: Redesigned System Settings Page


A redesigned page with advanced, more user-friendly settings makes it much easier to navigate and update service-level settings. Through the system settings page, administrators can set more advanced service-level options such as performance and compatibility, analysis, dashboard, pixel-perfect reporting, usage tracking, prompt, format, view, connection, and security.

Governed: Scale Up and Down


This helps you plan your Oracle Analytics Cloud service, guiding you important considerations such as: Which edition do you need? Where you want to deploy your service? How many OCPUs will you need? And how many users do you expect to use the service? These are important questions because some thresholds and limits associated with publishing vary, depending on the size of your deployment.

Governed: Connect More Easily to On-Premises Data Sources Using Data Gateway


The data gateway makes connecting to on-premises data sources easier. To get started, install data gateway into your on-premises environment on Linux, MacOS, or Microsoft Windows. Configure your on-premises environment and register one or more data gateway agents.

May 2019 (Release 105.2.3)

Governed: Pause and Resume Services


Manage your Oracle Analytics Cloud instances according to your safety and security needs. Pause services as needed on Oracle Cloud Infrastructure to prevent users from accessing the service. This option is available if you subscribe to Oracle Analytics Cloud through Universal Credits.

March 2019 (Release 105.2)

Augmented: Upload Larger Data Files


It is now easier to upload larger data files to provide richer insights for machine learning and artificial intelligence capabilities. You can upload files with a maximum size of 250 MB. The number of data columns allowed in a single file is 250 columns. The ability to upload larger files eliminates the risk of duplicated data resulting from splitting larger files down into smaller files.

Augmented: Use Data Visualization Data Flows as Data Sources


Data flows create a collection of data derived from multiple different data sources to be used for visual analysis. Build your needed source data via data flows and draw insights from the pixel-perfect reports made within data flows from data visualization. Data flows created in the save model option and data flows with branched data sets are not supported.

Augmented: Data Flow Improvements


The data flow editor layout is easier to use. You can save a data flow as a database connection, which stores the data flow data into a database table. You can merge two or more columns in a data flow to display as one column.

Self-Service: Add Notes


Grab your audience’s attention by adding notes. Focus on key points of the analysis that you’d like to share by adding, editing, and adjusting notes on a canvas. Refer to specific spots or data points such as column in a table, a particular horizontal bar, or a cluster in a scatter plot.

Self-Service: Enhanced Column Operations


As more and more data and projects are added to your Oracle Analytics Cloud Service, it is necessary to organize your work. Now you can quickly reorganize items in the projects, data, and machine learning pages by sorting the items based on their attributes. For example, you can reorganize data sets on the data page based on their modification dates and times.

Self-Service: Map Improvements


Improved map visualization makes insights for location-based data easier to convey. Improvements include creating cluster layers on a map visualization, representing point data with custom icons, selecting points or an area on a map, and representing line data using size and color.

Self-Service: Specify Filters for Relative Time Periods


Easily answer all of your “when” questions. Historical trends in data provide a lot of insights for future decision-making. Display data for a specified time period, based on the current date and time, using the relative time filter on a date or a date/time column.

Self-Service: Generate Larger Reports


Bring in more source data than before. This update increases the maximum number of rows you can return from any data source query or export to various file formats to 2,200,000 rows of unformatted data and 50, 000 rows of formatted data. Data row limits are dependent on the size of your service deployment, so it’s important to plan your deployment options to take advantage of this update.

Self-Service: Modify Data in Tables


Personalize reporting in dashboards and analyses. Users of a dashboard page or an analysis can modify the data they see in a table view. (Also known as writeback.)

Share Files to LinkedIn


Now you can share your insights with a larger community on LinkedIn. Share one or more of your project's visualizations, canvases, or stories to LinkedIn as a file. Create a dialogue and gain further input on your findings by sharing socially

Governed: Scale Service Up and Down


You have freedom within a framework. For data visualization or business intelligence services deployed on Oracle Cloud Infrastructure, you can improve performance by scaling up the number of Oracle Compute units (OCPUs) allocated to your service. If your workload decreases or you need to reduce costs, you can easily scale down.

Governed: Additional Service-Level Configuration


Configure your enterprise architecture and security to the service-level needs of your organization. Within the console, you can specify whether to externalize any database connections that administrators have configured for data models in Oracle Analytics Cloud or specify how often it synchronizes the database connections.

Governed: Track Usage


Make your operations run smoother with usage tracking. Track user queries and generate reports and visualizations to analyze the usage data. Determine which user queries are creating performance bottlenecks based on query frequency and response time. Usage tracking is monitored at the detailed user query level.

Governed: Connection Improvements


Improved connections create a richer analysis as they allow more source data to be brought in. Answer more organizational questions with more connections to data sources. Create connections to the Snowflake Data Warehouse.

Governed: Connect to On-Premises Databases


Visualize data in on-premises databases using the use remote data connector option. To find out which supported data sources allow for remote connections for data sets as well as data models, click the Learn more link.

Governed: Connect to On-Premises Data Sources Much More Easily using Remote Data Connector


The remote data connector enables you to more easily connect to on-premises data to data sources. Providing remote access to more data sources improves every analytics experience. Install the remote data connector in your on-premises Linux environment using Oracle Universal Installer.

January 2019 (Release 105.1.0)

Governed: Multiple Identity Domains


Oracle Identity Cloud Service supports multiple identity domains. Administrators can manage the identities and their rights. When setting up Oracle Analytics Cloud, you can choose between multiple identity domains to manage users and roles, integration standards, external identities, secure application integration (SSO), and Oracle Analytics authorization administration.

Governed: Migrate Oracle Analytics Cloud Environments


Migrate content faster and more easily between Oracle Analytics Cloud environments using snapshots. It doesn’t matter whether Oracle Analytics Cloud is deployed on Oracle Cloud Infrastructure or Oracle Cloud Infrastructure Classic. Downloading and/or uploading saved snapshots allows you to migrate between the two different services, between development, test, and production environments, and service deployed on Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure.

Governed: Migrate from Oracle BI Enterprise Edition 11g


Additional menu options in the console make migration easier. You can download a utility that exports content from Oracle Business Intelligence Enterprise Edition 11g to a migration bundle (JAR file). After exporting your content, you can upload the migration bundle to Oracle Analytics Cloud using the console.

Governed: Snapshot Enhancements


You can capture much more when you take a snapshot. You can take a snapshot of your entire environment (everything) or specify content that you want to back up or migrate (custom). Similar options are available on restore, improving your backup, restore, and migration experience.

Governed: Data File Migration Utility


This utility moves data files from one Oracle Analytics Cloud environment to another. Sometimes connection issues between the source and target environment can interrupt data file migration during snapshot restore. This utility offers you an alternative way to move your data files.

Governed: Advanced Service-Level Configuration


You can set the configuration options required for advanced use cases through the console. Administrators can set more advanced, service-level options using the system-setting pane. Set your options to configure performance and compatibility settings between Oracle Business Intelligence Enterprise Edition and Oracle Analytics Cloud.

Governed: Autonomous Data Warehouse Connection Enhancements


You can more easily create a connection to Oracle Autonomous Data Warehouse because key connection details are prepopulated from the selected client credentials zip file. First, enable secure communication between Oracle Analytics Cloud and Oracle Autonomous Data Warehouse by uploading the trusted SSL certificates from Oracle Autonomous Data Warehouse to Oracle Analytics Cloud. Second, create a connection to Oracle Autonomous Data Warehouse.

Governed: Autonomous Transaction Processing Connections


You can create connections to Oracle Autonomous Transaction Processing to access data sources. First, to enable secure connections between Oracle Analytics Cloud and Oracle Autonomous Transaction Processing, you must upload trusted SSL certificates from Oracle Autonomous Transaction Processing to Oracle Analytics Cloud. Second, create a connection to Oracle Autonomous Transaction Processing.

Self-Service: POV Parameter in an MDX Query


View an Oracle Essbase cube and filter data for reports. You can search a dimension in a cube and include a POV parameter value in an MDX query. If you include a POV parameter in an MDX query of a data model, and if that POV parameter doesn’t exist in the data model, Oracle Business Intelligence Publisher creates that POV parameter in the data model when you save the query.

Self-Service: Snapshot Includes Pixel-Perfect Reporting


Easily pick up where you (or a colleague) left off in analysis. A snapshot is a backup file that enables you to restore your Oracle Analytics environment by capturing all or some components at a specific point in time. Migrate the credentials, configurations, and scheduled jobs of pixel-perfect reporting from one environment to another.