No results found

Your search did not match any results.

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.

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.