GoodData FAQs

A maintenance window is scheduled for Saturday, December 7th, 2019, at 1:00 AM Pacific Standard Time ( other time zones ). The maintenance window is planned to take up to 2 hours.

The maintenance is planned for the United States (US) datacenters (both Dallas and Chicago) and the Canada (CA) datacenter. The European Union (EU) datacenter will not be affected. For more information about the datacenters, click here.

What will it bring?

Improved core infrastructure performance

Software upgrade to the latest versions

System resilience improvements

How will it affect you?

The maintenance will affect you only if your data is stored in the US or CA datacenters. To find out what datacenter holds your data, click here.

1:00 AM - 2:00 AM: The GoodData platform and all applications will be unavailable. API calls to the GoodData platform will fail. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online.

2:00 AM - 3:00 AM: The GoodData platform will be online. However, data load tasks that are scheduled to run during this period may fail.

No action required!

There is no action required from you.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

A maintenance window is scheduled for Saturday, November 9th, 2019, at 1:00 AM Pacific Daylight Time ( other time zones ). The maintenance window is planned to take up to 2 hours.

The maintenance is planned only for the European Union (EU) datacenter. The other datacenters will not be affected.

What will it bring?

Improved core infrastructure performance

Software upgrade to the latest versions

System resilience improvements

How will it affect you?

The maintenance will affect you only if your data is stored in the EU datacenter. To find out what datacenter holds your data, click here.

1:00 AM - 2:00 AM: The GoodData platform and all applications will be unavailable. API calls to the GoodData platform will fail. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online.

2:00 AM - 3.00 AM: The GoodData platform will be online. However, data load tasks that are scheduled to run during this period may fail.

No action required!

There is no action required from you.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

Bug Fixes and Minor Improvements

In this release, we focused on fixing reported bugs and making improvements in the underlying processes.

We are working on new features, so please stay tuned for the next Release Notes!

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on January 16, 2020.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on January 16, 2020. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED! Before January 16, 2020, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.5.1:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect, upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see Deprecated Features.

REMINDER: Update the GoodData Public PGP Key in Your PGP SSO Implementation

For customers using the GoodData PGP SSO login implementation

The existing GoodData public PGP key that you use to encrypt your PGP login requests is going to expire on May 20, 2020.We have generated a new public PGP key that you can start using immediately instead of the expiring one.

ACTION REQUIRED! Download the new public PGP key and update the key on your side. We recommend that you do so as soon as possible.You can also download the new PGP key from our online help here (go to Step 3) or here (go to Step 3).

What will happen if you do not update the key?The old key will be working until May 20, 2020. After that date, if you do not update the key on your side, you will not be able to log in to the GoodData platform via SSO.

Learn more: GoodData PGP Single Sign-On How to Generate a Public-Private Key Pair

Hide the Axis Name in Analytical Designer

When creating insights in Analytical Designer, you can now select the position of any axis name.

How to Generate a Public-Private Key Pair

You can also hide the name by toggling the switch in the axis configuration settings.

Learn more: Configure Insights

ACTION REQUIRED: Update the GoodData Public PGP Key in Your PGP SSO Implementation

For customers using the GoodData PGP SSO login implementation

The existing GoodData public PGP key that you use to encrypt your PGP login requests is going to expire on May 20, 2020.We have generated a new public PGP key that you can start using immediately instead of the expiring one.

ACTION REQUIRED! Download the new public PGP key and update the key on your side. We recommend that you do so as soon as possible.You can also download the new PGP key from our online help here (go to Step 3) or here (go to Step 3).

What will happen if you do not update the key?The old key will be working until May 20, 2020. After that date, if you do not update the key on your side, you will not be able to log in to the GoodData platform via SSO.

Learn more: GoodData PGP Single Sign-On

Update 9:18 PM (central):

The issue was resolved and all of the projects on US1 datacenter are accessible again.

Please check your ETL for failures and restart failed ones, if there is no automatic retry set.

We deeply apologize for any inconvenience.

_____________________________________________

Original announcement:

We are currently experiencing issues on our US1 datacenter (Chicago), that are preventing users of GoodData system to access the platform and the projects located on this datacenter.

The whole problem started with unavailability of a shared storage which is now fixed, but one of the services still has issues with connectivity to the shared storage, which the reason why the issue still persists.

The issue started on 10/30 at 6:43 PM (central).

Export KPI Dashboards to PDF

KPI Dashboards now enable you to export a whole dashboard to a PDF file.

The exported PDF file includes all insights and KPIs together with the dashboard name, date of the export, and page numbers.

Deprecated Features

Learn more: Export KPI Dashboards

New API: Publish Logical Data Model to Project in One Step

We have introduced the API that allows you to publish a logical data model (LDM) to the project in one step. You do not need to separately generate a diff between the current and target LDMs, and then generate and execute MAQL DDLs to update the current LDM to make it equal to the target LDM. All you need to provide is the JSON representation of the target LDM, and the new API will take care of the rest.

https://secure.gooddata.com/gdc/projects/{project_id}/model/publish

For more details about the new API, see API: Publish a logical data model to the project.

Of course, you can still use the API for generating a diff and MAQL DDLs and for executing MAQL DDLs if you need to implement more complex publishing scenarios or debug the process.

Data Warehouse JDBC Driver 3.5.1 Available!

We have released version 3.5.1 of the Data Warehouse JDBC driver. Download it from the Downloads page at https://secure.gooddata.com/downloads.html. NOTE: If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html

What's new in this version?Version 3.5.1 introduces support for:

Java 11

The UUID data type

The fetchSize and maxRows settings in a Statement object

Learn more: Download the JDBC Driver

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on January 16, 2020.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on January 16, 2020. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED! Before January 16, 2020, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.5.1:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect, upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

Headers in KPI Dashboards

To enhance your KPI Dashboards, you can add titles and descriptive text to any section on your dashboard. Users then can get a better idea of what the dashboard displays.

deployed to the GoodData platform

Learn more: Set up a KPI Dashboard

New API: List Process Schedules for the Current User

You can now use the API to obtain a list of schedules fordata load processes owned by the currently logged-in user and filter out the schedules by their execution status (RUNNING, ERROR, CANCELED, ...) or state (ENABLED or DISABLED).

https://secure.gooddata.com/gdc/dataload/userSchedules/?scheduleState={STATE}&executionStatus={STATUS}

Learn more: API: List schedules for the current user

Salesforce and TLS 1.1: Upgrade Your CloudConnect

For CloudConnect users

Salesforce is in the process of disabling the TLS 1.1 encryption protocol.

Will this affect you?This change will affect you only in the following case:

You use CloudConnect to create and maintain your data load graphs, and

Your graphs contain the Salesforce Reader component that relies on TLS 1.1, and

You run these graphs locally.

In this case, these graphs will fail when run locally once Salesforce disables TLS 1.1.

How can you get prepared for this change?Upgrade your CloudConnect tothe latest version, 115.0.0:from the menu bar, click Help -> Check for Updates. The latest version of CloudConnect switches the Salesforce Reader component to TLS 1.2.Once the upgrade is complete, the Salesforce Reader component in your graphs will be automatically updated to use TLS 1.2.

What about the graphs deployed to the GoodData platform?The graphs that are already via the Data Integration Console will automatically be switched to TLS 1.2.No action is required from you for those graphs.

Custom Event Handlingin Embedded Analytical Designer andKPI Dashboards

You can now drill on measures and attributes from within embedded Analytical Designer and KPI dashboard into your parent application. This gives your business users a seamless workflow bridging both insights and the parent application.

Learn more: Setting up Events for Drilling in Embedded Analytical Designer and KPI Dashboards

New API: Project-Specific Metadata Storage

In addition to the API for storing user-specific metadata, you can now use the API for storing project-specific metadata.

Learn more: API: Project-specific data storage

Analytical Designer Links to a Specific Insight

When using Analytical Designer the URL now displays projectId or clientId and visualisation ID or identifier after"Load/Save/Save as" actions are performed. Thesecan be used when embedding Analytical Designer to link to a specific insight.

Learn more: Embed Analytical Designer

SSL Certificate Validation for EmbeddedContent

To increase GoodData platform security, we have tightenedSSL certificate validation for dashboard export to PDF.The validation takes place every timea dashboard is exported to PDF (such as, printing a dashboard, scheduling an email with attacheddashboards ), and may affect the embedded content on the dashboard.If your dashboard containsembedded content and the SSL certificate of the servershosting the contentis invalid, the embedded contentwill be displayed as agray rectangle in the resulted PDF document.

Action needed:For thedashboards that contain embedded content, verify thatthe SSL certificates of the servershosting that contentare always valid.

COPY FROM S3

Data Warehouse now supports new COPY FROM S3 command syntax. S3 credentials are stored through public REST API and can be later referenced in SQL statements. Exception and error info is stored in DB tables instead of local files as is in COPY FROM LOCAL.

Learn more: API COPY FROM S3 to Load Data

API Updates

The following API updates are implemented:

The REST API resource/gdc/md/$project_id/objects/query?category=projectDashboard&limit=$limitwill serialize values ofprojectDashboard/content/filters[]/filterItemContent/{universum,default}/{from,to}alwaysas JSON stringsif present; now, those two values areserialized either as JSON integers or as JSON strings based on the value oftype.Same resource as this is/gdc/md/$project_id/obj/$obj_id.And WebApp has an advanced version of this resource in/gdc/md/$project_id/obj/$obj_id/viewwhich is affected too.In case of/gdc/md/$project_id/obj/$obj_idwill be affectedexecutionContext/content/filters[]/filterItemContent/{universum,default} too.

Each object returned by REST API resources: /gdc/md/$project_id/objects/query?category=etlFile&limit=$limit/gdc/md/$project_id/obj/$etlFile_idwill not have parseParamkey in etlFile/contentsection anymore.

No changes are needed on your side.No impact on your API configuration is expected.

Upcoming Changes: Naming Date Filters

We are going to change the way how the date filters are named when added to a dashboard. GoodData Support

What exactly is going to change?Now, when you are adding a date filter to a dashboard, the filter is automatically named after thedate dimensionthat it is based on.When the planned change is made, the newly added date filter will be named after thedate datasetthat is it based on.

Nothing changes for existing date filters!This change willnotaffect the date filters that already exist on your dashboards. It will only be applied to the date filters that you will addafterthe change is made.

How can you get prepared for this change?Fromthe GoodData Portal, go toManage->Data->Data Sets, and check the names of thedate datasets in your project. Keeping in mind that the dataset names will be used as names for all newdate filters, decide whether you want to rename any dataset to make sense once their names are used as filter names.

NOTE:You can and will still be able to rename a date filter on your dashboard at any time.

Learn more: Filter for Dates

Reminder: Add Mandatory User-Agent Header to API Request

Starting fromMarch 31, 2018, the GoodData REST API will require every API request to contain theUser-Agentheader. Any API request without theUser-Agentheader made after March 31, 2018, will be rejected.

TheUser-Agentheader must be in the following format:product/version([email protected])

where:--productis your product name; can include your company name; must not contain spaces or slashes ( / )--versionis your product version; must not contain spaces or slashes ( / )[email protected] the email of the contact personresponsible for the product in your company. The email is optional if you have specified your company name inproduct.

Examples:Insights-Provisioner/1.0 ([email protected])Acme-Company-GDIntegration/0.9

Action needed:If you use a tool for handling API calls or a custom library for integrating with the GoodData REST API, update them to include theUser-Agentheader in every API request.Although the API change is planned for the next year, we strongly recommend that you do soas soon as possible.

If you have any question, please contact.

Direct Data Distribution from the Google BigQuery Data Warehouse

Automated Data Distribution can now load data directly from your Google BigQuery cloud data warehouse into one or multiple GoodData projects. With the provided tooling, you can simply connect GoodData to your Google BigQuery project, prepare tables and views that you want to use for reporting, generate a logical data model in your workspace, and configure data load and distribution frequency.

That's it! Starting today, you can use your Google BigQuery data and accelerate analytics for all your users.

Learn more: Direct Data Distribution from Data Warehouses

Organize Your Data Catalog in Analytical Designer

To help users find related items in Analytical Designer and group these visually, administrators can organize measures and attributes into groups.

Use the ADCatalogGrouping platform setting to group items by:

Folders which enables localization for the group names, or

Tags which enables you to have one item in multiple groups.

By default, the platform setting is set to Disabled and users will not see any changes in their Data Catalog.

Deprecated Features

Learn more: Data Catalog in Analytical Designer

Life Cycle Management: Release, Provisioning, Rollout Bricks Available

If you are managing projects via Life Cycle Management, you can now deploy and schedule the following bricks in addition to already available Users brick and User Filters brick:

Release brick, which creates master workspaces for segments based on a predefined template (see Release Brick )

Provisioning brick, which creates clients' workspaces under the appropriate segments, and deploys the reports, dashboards, filters, logical data model, ETL, and metadata from the master workspace to the clients' workspaces within a segment (see Provisioning Brick )

Rollout brick, which synchronizes a segment's master workspace and its clients' workspaces: the changes that you made in a master workspace (LDM, ETL, dashboards, and so on) are propagated to all the clients' workspaces within the corresponding segment (see Rollout Brick )

Learn more: Managing Projects via Life Cycle Management How to Use a Brick

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on January 16, 2020.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on January 16, 2020. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

Please note that the end-of-life date has changed and is now set to January 16, 2020.

ACTION REQUIRED! Before January 16, 2020, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect, upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

Custom Date Filters in KPI Dashboard

To enhance the functionality of date filtering, we are introducing an option to use API to configure the filters. You can now:

Select from static filter, floating filter, and presets

Configure the date filter in KPI Dashboards to show only selected date filters

Set which date granularities (day, month, quarter, year) are available in the date filter

Change the name of the date filter, make it read-only, and hide it for the end-user

Configure for the whole workspace or a specific dashboard

With the default date filter JSON structure, your date filter menu will look like this:

Deprecated Features

To postpone the official release and preserve the current date filter setupfor your users, set the enableKPIDashboardExtendedDateFilters platform setting to false. For more information about the platform settings, see Platform Settings.

Learn more:

Customize Date Filters

Date Filters in KPI Dashboards

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you?If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED!Before October 31, 2019, check the version of your JDBC driver.If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

Pivot Tables in Analytical Designer

To improve your experience with GoodData, we are releasing new pivot tables in Analytical Designer.

New pivot tables enable you to group items and add totals to your tables. All your current flat tables are automatically transformed to pivot tables - you are not required to do any steps.

Deprecated Features

Learn more: Pivot Tables

Direct Data Distribution from the Snowflake Data Warehouse

Automated Data Distribution can now load data directly from your Snowflake cloud data warehouse into one or multiple GoodData projects. With the provided tooling, you can simply connect GoodData to your Snowflake instance, prepare tables and views that you want to use for reporting, generate a logical data model in your workspace, and configure data load and distribution frequency.That's it! Starting today, you can use your Snowflake data and accelerate analytics for all your users.

Learn more: Direct Data Distribution from Data Warehouses

API: Multiple SSO Providers for a User

You can now specify more than one SSO provider for a user using the API.

To do so, update a user's information and set the ssoProvider property to a comma-separated list of SSO providers.

Example: {

"accountSetting": {

"firstName": "Jane",

"lastName": "Doe",

"ssoProvider": "sso_provider_1, sso_provider_2",

...

"language": "en-US"

}

}

NOTE: You must be a domain administrator to update thessoProvider property.

Learn more: API: User properties API: Update user information

New API Events for Embedded Dashboards: Embedded Content Started/Completed Loading

When you export to PDF a pixel-perfect dashboard that has an embedded dashboard, you can now make sure that the embedded content is completely loaded before the export starts and that the resulting PDF file is correct.

To do so, use the API events 'Dashboard export initiated - embedded content started loading' and 'Dashboard export initiated - embedded content completed loading'.

The API event 'Dashboard export initiated - embedded content started loading' is triggered when you choose to export the dashboard that hosts the embedded dashboard. The content of the embedded dashboard starts loading. The dashboard export is paused until the content load completes. { gdc: { name: 'embedded.init', type: 'app.ok' }}

The API event 'Dashboard export initiated - embedded content completed loading' is triggered when the content of the content load completes. The dashboard export resumes, and the resulting export file is generated. { gdc: { name: 'embedded.ready', type: 'app.ok' }}

Learn more: Embedded Dashboard Events Embedded Dashboard and Report API - Events and Methods

UPCOMING: Combo Charts in Analytical Designer

To improve your experience with GoodData, we are releasing a new type of insight in Analytical Designer - Combo charts. With combo charts, you can combine two types of charts (column, area, and line) into a single insight.

If you want to try a beta version of combo charts now, set the enableComboChart platform setting to true (for more information about the platform settings, see Platform Settings ).

Learn more: Combo Charts

UPCOMING: Data Warehouse Upgradeto Vertica 9.2.0

We areplanning to upgrade the Vertica software on our Data Warehouse to Version 9.2.0. Completing the upgrade will take a few weeks.

We will be posting separate announcementsto let you know the upgrade status.

Deprecation and End-of-life: Project Templates

The project templates are no longer supported and stopped working on May 15, 2019.

How does this affect you?If you are using the project templates, they stopped working on May 15, 2019. Any request to create a new project that includes a project template will fail.

ACTION REQUIRED!Make sure that you either adopted Life Cycle Management (LCM) or updated your solution to run without the project templates.

Learn more:

For more information about LCM, see Managing Projects via Life Cycle Management.

For more information about the project template deprecation, see Project Templates.

For information about all deprecated features, see Deprecated Features.

Deprecation and Upcoming End-of-life: Legacy Salesforce SSO Method

The legacy GoodData-proprietary Salesforce SSO method that is based on SessionID is deprecated and will stop working on March 30, 2020.

How will this affect you?If you are using the legacy Salesforce SSO method, it will stop working on March 30, 2020. Users will not be able to log in to the GoodData platform using the implemented legacy Salesforce SSO method.

ACTION REQUIRED!Migrate to Salesforce SAML SSO before the end-of-life, March 30, 2020. For more information, see Legacy Salesforce SSO Method.

Learn more:For information about all deprecated features, see .

Custom Layouts for KPI Dashboards

KPI Dashboards now allow you to create customized views of your data directly in the KPI Dashboard section of the GoodData Portal.

Drag and drop KPIs and insights to create a customized view of your data, adjust the size of the widgets, or rearrange them.

Users

Learn more: Edit KPI Dashboards Set Up a KPI Dashboard

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you?If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED!Before October 31, 2019, check the version of your JDBC driver.If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see Deprecated Features.

UPCOMING:Date Filter Configuration on the Dashboard Level via API

To enhance functionality of date filtering, we are introducing an option to use API to configure filters.

The feature will be rolled out to all customers on September 5, 2019, with the next planned release.

The new feature enables the following:

Configuring the date filter component in KPI Dashboards to show only selected date filters

Workspace level configuration for all KPI dashboards

Dashboard specific configuration

Selecting from the static filter, floating filter, and presets

Setting which date granularities (day, month, quarter, year) are available in the date filter

Changing the name of the date filter, making it read-only, and hiding it for the end-user

To enable before the final release, set the enableKPIDashboardExtendedDateFilters platform setting to true.To postpone the official release for your users, set the platform setting to false. For more information about the platform settings, see Platform Settings.

Learn more: Customize Date Filters

Domain admin provisioning users can now specify multiple SSO providers

If you are a domain administrator, you can now specify multiple single-sign-on providers at the level of a particular user during a provisioning call.

Previously, the APIwas rejecting such requests.

Learn more:

Modify authentication settings for a user

Manage users

Generate Output Stage based on Existing Logical Data Model

You can now generate the Output Stage based on the logical data model (LDM) in your project when setting up direct data distribution from a data warehouse (for example, Snowflake or Amazon Redshift).

Generating the Output Stage based on an existing LDM can help you deploy the direct data distribution much faster in the situation when you already have a GoodData project with the LDM that meets your business requirements for data analysis and which you do not want to update. In this case, using the LDM as a basis for generating the Output Stage will help you save time and effort.

What other options are available? You can generate the Output Stage based on the Data Source and the database schema stored in it. Then, you would generate the LDM for your project based on the Output Stage.This approach works best when you do not yet have a GoodData project or want to generate/update the LDM to best fit the existing data structure in your data warehouse. For more information, see API: Generate the Output Stage based on the schema.

How can you generate the Output Stage based on the LDM? Use the following API to get SQL DDLs that you can then use to create GoodData-compatible views/tables:

https://secure.gooddata.com/gdc/dataload/projects/{project_id}/generateOutputStage

NOTE: If you are a white-labeled customer, replace secure.gooddata.com with your white-labeled domain.

For all the details about this API, see API: Generate the Output Stage based on the LDM.

Learn more: API: Generate the Output Stage based on the LDM Integrate Data Warehouses Directly to GoodData based on Your DW Schema

CSV Downloader: Certificate-Based Authentication for SFTP Locations

We have updated the way of how CSV Downloader authenticates to the SFTP server, from which you want to download data, when certification-based authentication mode is used.

If you use an SFTP location to store your source data and want to use certification-based authentication, set the auth_mode parameter to cert in the configuration file:

"csv": { "type": "sftp", "options": { "username": "{[email protected]}", "host": "{sftp_hostname}", "auth_mode": "cert" }}

When scheduling a process for CSV Downloader in the Data Integration Console, provide the private key (as the csv|options|cert_key secure parameter). If the private key is encrypted, also provide the passphrase to decrypt the private key (as the csv|options|cert_passphrase secure parameter).

Data Warehouse

Learn more: CSV Downloader

SQL Downloader: New Default Value for "fetch_size"

When you are usingSQL Downloader to download data from a PostgreSQL database, the fetch_size parameter now defaults to 50,000. Before, it did not have a default value (and this is still true for the other supported databases in SQL Downloader).

fetch_size is an optional parameter that allows you to customize the database connection by setting up the number of rows to fetch from the database when more rows are needed.

"sql": { "type": "PostgreSql", "options": { "connection": { "server": "{server_address}", "database": "{database_name}", "username": "{user_name}", "fetch_size": number_of_rows // optional, defaults to 50.000 } }}

Keeping fetch_size at its default helps you prevent out-of-memory or performance issues. If you want to use a different value, avoid setting fetch_size to a small number (for example, 50).

Learn more: SQL Downloader

Download Apache Parquet Files with COPY FROM S3 Command

You can now use the COPY FROM S3 command to download Apache Parquet files from an Amazon S3 bucket to your Data Warehouse instance.

COPY {table_name} FROM 's3://{bucket}/{file}.parquet' PARQUET;

Learn more: Use COPY FROM S3 to Load Data

Data Warehouse Upgradeto Vertica 9.2.1 Completed

We have completedupgrading the Vertica software on our Data Warehouse. It now runs on Vertica Version 9.2.1. You can find detailed information about Version 9.2.1 in Vertica's online documentation. We have updated the user documentation for our accordingly.

A maintenance window is scheduled for Saturday, August 17th, 2019, at 1:00 AM Pacific Daylight Time ( other time zones ). The maintenance window is planned to take up to 2 hours.

What will it bring?

Migration to the latest hardware

Software upgrade to the latest versions

System resilience improvements

How will it affect you?

1:00 AM - 2:30 AM: The GoodData platform and all applications will be unavailable. API calls to the GoodData platform will fail. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online.

2:30 AM - 3.00 AM: The GoodData platform will be online. However, data load tasks that are scheduled to run during this period may fail.

No action required!

There is no action required from you.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

A maintenance window is scheduled for Saturday, July 27th 2019 at 01:30 PM Pacific Daylight Time ( other time zones ).

The maintenance process is planned to take up to 1 hour and 30 minutes on NA and EU DataCenters.

What will it bring?

Upgrade of underlying ADS Vertica Databases to its latest version, security and major engine bug fixes followed by upgrade of underlying kernel OS

How will it affect you?

1:30 - 3:00 PM: The GoodData platform and all applications will be still available. You can expect delayed or postponed scheduled ETLs - data pipeline loads to the platform. Postponed ETLs will be run after we are finished with this activity.

Access to the platform and its workspaceswon'tbe affected by this maintenance and will be accessible all the time.

No action required!

There is no action required on your part.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

Direct Data Distribution from the Amazon Redshift Data Warehouse

Automated Data Distribution can now load data directly from your Amazon Redshift cloud data warehouse into one or multiple GoodData projects. With the provided tooling, you can simply connect GoodData to your Amazon Redshift instance, prepare tables and views that you want to use for reporting, generate a logical data model in your workspace, and configure data load and distribution frequency.

That's it! Starting today, you can use your Amazon Redshift data and accelerate analytics for all your users.

Learn more: Direct Data Distribution from Data Warehouses Setting up Direct Data Distribution from Data Warehouses

GoodData.UI Version 7.1 Available: Applied Filters in XLSX Export and Deprecation of config:stacking

We have released Version 7.1 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

What's new in GoodData.UI Version 7.1

Applied filters included in exported XLSX files When exporting a visualization to XLSX, you can now include the applied filters in the exported file. For more information, see theincludeFilterContext property in OnExportReady.

The config:stacking property deprecatedThe config:stacking property has been deprecated. It will still continue working in the existing visualizations until further announcement. We will post a separate announcement to let you know when this happens. Action required: Check your visualizations built on the Area Chart component, and replace the config:stacking property with config:stackMeasures. For more information, see Chart Config -> Configure stacking. Please do so as soon as possible.

Data Sources Migrated to the New API Structure

As we announced earlier, we updated the structure that the REST API uses for Data Sources.

All Data Sources that were created before July 11, 2019, are now migrated to the new structure. The old structure is deprecated and no longer supported. You can find all the details about the old and the new structure in the previous Release Notes.

Learn more: API: List or create Data Sources API: Manage a Data Source Setting up Direct Data Distribution from Data Warehouses

Add or Edit Data Sources Directly in Data Integration Console

You can now create new Data Sources or edit existing ones directly from the Data Integration Console, when deploying a process for Automated Data Distribution to the GoodData platform.

Deprecated Features

Data Sources describe how the GoodData platform connects to cloud data warehouses (Snowflake or Redshift).

Learn more: Direct Data Distribution from Data Warehouses Deploy a Process with the Data Integration Console

Data Warehouse Upgradeto Vertica 9.2.1: First Phase Completed

We have completed the first phase of upgrading the Vertica software on our Data Warehouse to Version 9.2.1. Completing the upgrade will take a few weeks.

We will be posting moreannouncementsto let you know the upgrade status.

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED! Before October 31, 2019, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

API Structure for Data Sources Updated

We have updated the structure that the REST API uses for Data Sources. A Data Source is an entity that holds information how to connect from the GoodData platform to a Data Warehouse (such as Snowflake ).

The structure is used when you are working with Data Sources using the API. For example, it is returned in the API call response when you are creating a Data Source or when you are retrieving information about a Data Source.

In the structure, a new keyword, authentication, was introduced. It lists authentication methods. The credentials (username and password) are now nested under the basic method.

Tutorial - Set up Direct Data Distribution from Data Warehouses

The old structure is deprecated but will continue working in the existing Data Sources until we migrate them to the new structure. We will post a separate announcement to let you know when this is completed. Any new Data Source will be created with the new structure.

Learn more: API: List or create Data Sources API: Manage a Data Source

SOC 2 Type II Report Received

We are thrilled to announce that GoodData completed its annual SOC 2 Type II attestation and received the new SOC 2 Type II attestation report.

If you would like to review the report, please get in touch with your GoodData contact person.

Bug Fixes and Minor Improvements

In this release, we focused on fixing reported bugs and making improvements in the underlying processes.

We are working on new features, so please stay tuned for the next Release Notes!

A maintenance window is scheduled for Saturday, July 13th 2019 at 01:30 PM Pacific Daylight Time ( other time zones ).

The maintenance process is planned to take up to 1 hour and 30 minutes on all DataCenters.

What will it bring?

Upgrade of underlying ADS Vertica Databases to its latest version, security and major engine bug fixes followed by upgrade of underlying kernel OS

How will it affect you?

1:30 - 3:00 PM: The GoodData platform and all applications will be still available. You can expect delayed or postponed scheduled ETLs - data pipeline loads to the platform. Postponed ETLs will be run after we are finished with this activity.

Access to the platform and its workspaceswon'tbe affected by this maintenance and will be accessible all the time.

No action required!

There is no action required on your part.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

A maintenance of ADS Vertica Databases (not affecting access to workspaces) is scheduled for Thursday, July 18th 2019 at 01:30 PM Pacific Daylight Time ( other time zones ).

The maintenance process is planned to take up to 1 hour only on EU DataCenter.

What will it bring?

Improving stability of ADS Vertica Databases by installing a different kernel version

How will it affect you?

1:30 - 2:30 PM: The GoodData platform and all applications will be still available. You can expect delayed or postponed scheduled ETLs - data pipeline loads to the platform. Postponed ETLs will be run after we are finished with this activity.

Access to the platform and its workspaceswon'tbe affected by this maintenance and will be accessible all the time.

No action required!

There is no action required on your part.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

Export Individual Insights from KPI Dashboards

KPI Dashboards now enable you to export individual insights to:

a CSV file with unformatted data

an XLSX file with formatted data, merged or unmerged cells, and active filters

Deprecated Features

Learn more: Export KPI Dashboards

Subtotals in Pivot Tables in Analytical Designer

To enhance your pivot tables in Analytical Designer, you can add subtotals to aggregate groups of attribute rows.

When selecting an aggregation function now, you can enable it not only for all rows (grand total) but also for individual attribute values in a row (subtotals).

Learn more: Pivot Tables

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED! Before October 31, 2019, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page at https://secure.gooddata.com/downloads.html. If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain: https://my.domain.com/downloads.html.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

Data Warehouse Upgradeto Vertica 9.2.1

As we announced earlier, we are going to start upgrading the Vertica software on our Data Warehouse to Version 9.2.1. Completing the upgrade will take a few weeks.The upgrade requires no action on your side.

We will be posting separate announcements to update you on the upgrade status.

UPCOMING: Subtotals in Pivot Tables in Analytical Designer

To enhance the functionality of pivot tables in Analytical Designer, we are introducing subtotals in pivot tables. Subtotals show sums for individual attributes in rows.

If you want to try a beta version of subtotals, set the enablePivotSubtotal platform setting to true (for more information about the platform settings, see Platform Settings ).

Learn more: Pivot Tables

Deprecation and Upcoming End-of-life: SFTP for Loading Data to GoodData Platform

SFTP as a method of loading data to the GoodData platform is deprecated. The existing implementations will continue working until further announcement. New implementations will be using WebDAV or other means of uploading data.

For information about all deprecated features, see Deprecated Features.

Bug Fixes and Minor Improvements

In this release, we focused on fixing reported bugs and making improvements in the underlying processes.

We are working on new features, so please stay tuned for the next Release Notes!

A maintenance window is scheduled for Thursday, May 29th, 2019, at 05:30 PM Pacific Daylight Time ( other time zones ).

The maintenance window is planned to take up to 5 minutes on US-1 (Chicago) DataCenter only.

What will it bring?

Replacement of our Network Edge Device - Firewall with a more powerful device with higher throughput

How will it affect you?

05:30 - 05:35 PM: The GoodData platform and all applications might be unavailable for a very short time. External API calls to the GoodData platform might fail or will be delayed. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online. If you experience connection issues after the specified time window, please notify our Support team.

Action required

There might be short hiccups visible for external traffic to and from the US-1 DC. Data ETLs thatdon'tuse retry mechanism have to be manually reloaded if process fails. All ETLs that are monitored by GoodData Services will be restarted by us and therefore no action is required there.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

Hello,

We are currently experiencing issues in one of our Data Centers, US1. Engineers are currently working on a fix. We greatly appreciate your patience in the matter, and will keep you posted with updates as they become available.

Combo Charts in Analytical Designer

Analytical Designer offers a new type of insight - combo charts.

Combo charts combine two types of charts - column, area, or line - into a single insight.

You can, for example, check if your actual sales meet your target sales defined by another measure, or save canvas space in KPI Dashboards.

Deprecated Features

Learn more: Combo Charts

GoodData.UI Version 7.0 Available: Combo Chart and Subtotals in Pivot Tables

We have released Version 7.0 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

What's new in GoodData.UI Version 7.0

Combo Chart component addedCombo charts combine two types of charts - column, area, or line - into a singlevisualization to display your data. For more information, see Combo Chart.

Pivot tables: turning subtotals on and off via the menuYou can now turn subtotals on and off in pivot tables using the totals menu directly in the pivot tables. For more information, see Pivot Table Component --> Totals.

New Roles Introduced, Existing Roles Renamed in All Projects

As we announced earlier, we had made changes to the user roles on the GoodData platform. These changes were made to the projects that were created on February 21, 2019, or later.

Now, we have implemented these changes in all the remaining projects (that is, the projects that were created before February 21, 2019).

What has changed?

The two existing roles have been renamed:

Embedded Only Explorer --> Explorer (embedded only)

Embedded Dashboard Only --> Viewer (embedded only)

The following new roles were introduced:

Editor + User Admin: Editor with a permission to invite users to the project, to manage relations between data permissions and users, and to manage variables

Editor + Invitations: Editor with a permission to invite users to the project

Viewer (disabled exports): Viewer with a restricted permission to export reports

For more information, see User Roles and User Roles Permissions.

Action needed:Renaming the two existing user roles may affect you in the following cases:

If you are usingthe Users brick, which is a part of Life Cycle Management

If you have implemented custom API-based user provisioning processes

In these cases, make sure that you are using the internal role identifiers and not the names of the user roles that are going to be renamed. The internal role identifiers have not changed. Using the user role names instead of the internal role identifiers will cause user provisioning processes to fail.

Use explorerOnlyRole for the 'Embedded Only Explorer' user role.

Use dashboardOnlyRole for the 'Embedded Dashboard Only' role.

REMINDER: Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you?If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED!Before October 31, 2019, check the version of your JDBC driver.If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

A maintenance window is scheduled for Saturday, May 25th, 2019, at 1:00 AM Pacific Daylight Time ( other time zones ). The maintenance window is planned to take up to 1.5 hours.

What will it bring?

Migration to the latest hardware

Upgrade of the physical network edge device

Software upgrade to the latest versions

System resilience improvements

How will it affect you?

1:00 - 1:30 AM: The GoodData platform and all applications will be unavailable. API calls to the GoodData platform will fail. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online.

1:30 AM - 2.30 AM: The GoodData platform will be online. However, data load tasks that are scheduled to run during this period may fail.

No action required!

There is no action required from you.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any questions or concerns, please contact GoodData Support.

We have recently noticed an error on the platform and our Engineers are currently working diligently to correct this. We greatly appreciate your patience in this matter and apologize for any inconvenience caused.

As always, you can reach out to us at [email protected] to follow up accordingly. We will continue to keep you posted with the progress.

Stacking Measures in Insights

If you want to display how each product contributes to the overall revenue in totals or percentages, Analytical Designer now allows you to stack multiple measures on top of each other to understand their individual contributions. You can also slice your data with up to two attributes.

Deprecated Features

Learn more: Stack Measures

GoodData.UI Version 6.3 Available: Pivot Table Enhancements, Export to CSV/XLSX, Stacking, and Attribute Filters by Attribute Element Values

We have released Version 6.3 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

What's new in GoodData.UI Version 6.3

Pivot tables: grouping of attribute cells The same values in column attributes are now grouped across the rows, which helps improve data readability in pivot tables. For more information, see Pivot Table Component --> Grouping.

Pivot tables: a menu for turning totals on and off You can now turn totals on and off in pivot tables using the totals menu directly in the pivot tables. For more information, see Pivot Table Component --> Totals.

Export to CSV/XLSXYou can now export your insights to CSV or XLSX using the onExportReady parameter. For more information, see onExportReady.

Stacking in insights For some types of insights, you can now configure stacking. For each measure, you can choose to display the total contribution or the percentage contribution. For more information, see Chart Config --> Configure stacking.

Attribute filters by attribute element values In addition to attribute elements' URIs, you can now define attribute filters to match attribute elements by their values. To do so, use the textFilter property. For more information, see Filter Visual Components --> Attribute filter and Set Up an AFM Query --> Filter.

UPCOMING: Pivot Tables in Analytical Designer

To improve your experience with GoodData, we are releasing new pivot tables in Analytical Designer in one of the future releases.

New pivot tables will enable you to group items and add totals to your tables. All your current flat tables will be automatically transformed to pivot tables - you are not required to do any steps.

If you want to try a beta version of pivot tables now, set the enablePivot platform setting to true (for more information about the platform settings, see Platform Settings ).

UPCOMING: Direct Data Distribution from the Snowflake Data Warehouse

This is an early access feature that is going to be officially released soon. If you consider trying this feature, please submit any feedback to GoodData Support. Thank you!

Automated Data Distribution can now load data directly from your Snowflake cloud data warehouse into one or multiple GoodData projects without any additional processing. The data structure in your Snowflake schema (views or tables) must align with the logical data model in your project.

How can you start using this feature? To enable the integration with Snowflake, set the enableDataDistribution platform setting to true (for more information about the platform settings, see Platform Settings ).

Learn more: Direct Data Distribution from Data Warehouses

Additional Password Complexity Options

GoodData provides additional options to increase password security: you can now define password strength and also the option to limit the reuse and force the expiration of passwords.

Learn more: Password Policy

LAST REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you? If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.

How can you get prepared? Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED! Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:

For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager.

For more information about the project template deprecation, see Project Templates.

For information about all deprecated features, see Deprecated Features.

Deprecation and Upcoming End-of-life: JDBC Driver Version 3.0.2 through 3.1.2

The JDBC driver version 3.0.2 through 3.1.2 is deprecated and will stop working on October 31, 2019.

How will this affect you? If you are using version 3.0.2 through 3.1.2 of the JDBC driver, it will stop working on October 31, 2019. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

ACTION REQUIRED! Before October 31, 2019, check the version of your JDBC driver. If your version is 3.0.2 through 3.1.2, upgrade to the latest version, 3.3.0:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:

For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

For more information about the deprecation of the JDBC driver version 3.0.2 through 3.1.2, see JDBC Driver Version 3.0.2 through 3.1.2.

For information about all deprecated features, see .

New API - Check Project Compatibility in Different XAE Version

GoodData's XAE version 3 handles complex data relationships including many-to-many support. To enable this capability you can upgrade to XAE via GoodData's Platform Settings and in order to make the upgrade easier we've added a new API endpoint (also accessible via GrayPages) that verifies if report definitions in a given project will change after migration to the new XAE version. The returned report list splits report definitions into four groups 1) reports which will return the same result 2) reports which will return different result 3) reports which will fail with the new XAE version 4) reports which are failing with the current XAE version.

Learn more: Platform Settings XAE Version 3 Prerequisites API - Check Report Compatibility

Custom Layouts in KPI Dashboards - developer preview

You can now update your existing KPI Dashboards with a new layout. Edit the JSON structure of the dashboard metadata object, for example, to add multiple insights to a single row.

The current developer preview enables you to add or edit the layout through gray pages.

For details about the JSON structure and examples, see Custom Layouts for KPI Dashboards.

Java SDK versions 2.32.0 and Older

GoodData Java SDK versions 2.32.0+api1 and older are deprecated and will stop working on Monday 30th March 2020.

ACTION REQUIRED!In order to continue using the SDK, please update to version 2.33.0+api1 or newer.

Find more about GoodData Java SDK: https://github.com/gooddata/gooddata-java or on https://sdk.gooddata.com/.

Learn more:For information about all deprecated features, see Deprecated Features.

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you? If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.

How can you get prepared? Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED! Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:

For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager.

For more information about the project template deprecation, see Project Templates.

For information about all deprecated features, see Deprecated Features.

Create Calculated Measures using Arithmetic Functions

Analytical Designer now allows you to create new calculated measures directly in your insights.

Use items from the Measures section and basic arithmetic functions to create new measures for your current insight.

For example, you can create measures to display:

Your total revenue over the last two years (revenue this year + revenue last year)

Increase of your revenue since last year (revenue this year - revenue last year)

Your gross margin (gross profit / net sales)

Revenue from one product (price per unit x volume sold)

Change in your revenue (% change year over year)

Deprecated Features

Learn more: Create Calculated Measures in Insights

Export Insights from Analytical Designer

If you need to analyze data from you insights in other applications, you can now export insights from Analytical Designer to XLSX files (with merged or unmerged cells) or CSV files.

Learn more: Export insights

Updated Lists of U.S. States and U.S. Counties for Geo Charts

We have updated the CSV files listing the U.S. states and the U.S. counties that are used for configuring data for geo regions in GoodData geo charts.

The list of U.S. states now includes territories such as Puerto Rico, American Samoa, Virgin Islands, and others. The list of U.S. counties has been updated accordingly to include the counties of the newly added territories, if available.

Learn more: Setting up Data for Geo Charts

Login in User Details for Data Warehouse Users

When retrieving a list of users for a Data Warehouse instance via the API or the gray pages, you can now see the login information for each user.

{

"users": {

"items": [

{

"user": {

"role": "admin",

"profile": "/gdc/account/profile/jqv...w0z", "login": "[email protected]", "links": { "self": "/gdc/datawarehouse/instances/wfc...047/users/jqv...w0z", "parent": "/gdc/datawarehouse/instances/wfc...047/users" } } } ], "paging": { }, "links": { "self" : "/gdc/datawarehouse/instances/wfc...047/users", "parent" : "/gdc/datawarehouse/instances/wfc...047" } } }

This helps you easily identify a user without navigating to their profile and back.

Learn more: API for listing users for a Data Warehouse instance List users for a Data Warehouse instance via the gray pages

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you? If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.

How can you get prepared? Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED! Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:

For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager.

For more information about the project template deprecation, see Project Templates.

For information about all deprecated features, see .

Changes in User Roles: New Roles Introduced, Existing Roles Renamed

For the projects created on February 21, 2019, or later

We have made changes to the user roles on the GoodData platform. Currently, these changes apply to the projects that were created on February 21, 2019, or later.

What has changed?

The two existing roles have been renamed:

Embedded Only Explorer --> Explorer (embedded only)

Embedded Dashboard Only --> Viewer (embedded only)

The following new roles were introduced:

Editor + User Admin: Editor with a permission to invite users to the project, to manage relations between data permissions and users, and to manage variables

Editor + Invitations: Editor with a permission to invite users to the project

Viewer (disabled exports): Viewer with a restricted permission to export reports

For more information, see User Roles and User Roles Permissions.

Action needed:Renaming the two existing user roles may affect you in the following cases:

If you are usingthe Users brick, which is a part of Life Cycle Management

If you have implemented custom API-based user provisioning processes

In these cases, make sure that you are using the internal role identifiers and not the names of the user roles that are going to be renamed. The internal role identifiers have not changed. Using the user role names instead of the internal role identifiers will cause user provisioning processes to fail.

Use explorerOnlyRole for the 'Embedded Only Explorer' user role.

Use dashboardOnlyRole for the 'Embedded Dashboard Only' role.

What about the other projects?Currently, these changes apply only to the projects that were created on February 21, 2019, or later. The projects that were created before February 21, 2019, still use the old names (Embedded Only Explorer and Embedded Dashboard Only) and do not offer the new user roles.

We are working on propagating these changes to all the remaining projects. We will post a separate announcement when the changes in the remaining projects are implemented.

Max Amount of Data to Upload to Projects in Full Mode Increased

We have increased the maximum amount of data that you can upload to a project in a single load transaction in full mode from 25 GB to 50 GB.

Now, the limits are as follows:

50 GB for full+incremental+delete mode

25 GB for incremental+delete mode

Learn more: Platform Limits - Workspace Loading (log in to the GoodData Support portal to see this article)

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you? If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.

How can you get prepared? Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED! Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more: For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager. For more information about the project template deprecation, see Project Templates.

GoodData.UI Version 6.2 Available: Arithmetic Measures, Model Helpers, and More

We have released Version 6.2 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

What's new in GoodData.UI Version 6.2?

Arithmetic measuresYou can now create arithmetic measures that allow you to perform simple calculations with measures in a visualization (addition, subtraction, multiplication, and so on). For more information, see Arithmetic Measure.

Model helpersThe model helpers allow you to easily create various objects for your visualizations, such as measures, measure filters, attributes, and sort items. For more information, see Model Helpers.

Drilling using function predicatesYou can now implement drilling for measures (including arithmetic measures ) and attributes using predicate functions. For more information, see DrillableItems.NOTE: While the previous method of implementing drilling (using a list of drillableItems with the URI or identifier of a measure/attribute) is still supported, we do not recommend that you use this method anymore. It will be removed in one of future versions. Use the function predicates instead.

Request cachingThe Visualization component now uses cache for getting some static information from the GoodData platform to minimize the number of redundant requests.Clear the cache from time to time (for example, after logging out, or when leaving a page with visualizations using the GoodData.UI components). To clear the cache, call clearSdkCache from the sdkCache module.

New GoodData Platform Language - Simplified Chinese

The GoodData Platform UI is now available in an additional language - Simplified Chinese. You can configure this language via API and then select from the drop down menu in the platform.

Learn more: GoodData API

New API - Preserve Variables Option During Release and Rollout on Data Product and Segment Level

GoodData adds new API for Data Product, Client and Segment configuration for Life Cycle Management.This API allows you to set the option on the data product and segment levels whether variables in the target project should be preserved or not.

Learn more: Configuring LCM via API GoodData API

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you?If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.

How can you get prepared?Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED!Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager. For more information about the project template deprecation, see Project Templates.

Enable third party cookies to access embedded GoodData dashboards

Issue Overview

Some modern browsers are now blocking third-party cookies by default. Many web services like GoodData rely on third-party cookies for authentication purposes when offerings are embedded in other sites. Disabling third party cookiesmay keep you from accessing the GoodData Portal if you or your customersare accessing GoodData through a window embedded in another application. In such cases, dashboards cannot be displayed until third-party cookies are enabled in your browser.

This issue is known to affect the following browsers:

Firefox 22 and later

Safari

Note:Customers using white-labeled versions of GoodData may not be impacted if the domain of the GoodData solution matches the domain of the embedding application. For example, if your white-labeled solutions domain is analytics.yourcompany.com and your web site is hosted as yourcompany.com, then you may not be impacted.

To Fix

If you are experiencing issues accessing an embedded version of GoodData after updating your browser, the solution may be to disable blocking of third-party cookies. Follow the steps outlined below for your browser/platform:

Safari for OS X

Firefox for OS X

Safari for Windows

Firefox for Windows

Safari for OS X Disable Blocking of Third Party Cookies

Safari has moved away from their "Block Cookies" section. In order to make it work with the current version of Safari, you must have both"Prevent cross-site tracking" and "Block all cookies" checkboxes unchecked.

Firefox for OS X Disable Blocking of Third Party Cookies

Steps:

1. Open the Firefox menu and select Preferences.

2. Select Privacy.

3. Set the value of the "Firefox will" setting to: Use custom settings for history.

our related article

4. Additional settings are displayed. Check Accept third-party cookies.

5. Close the Preferences window.6.Refresh your GoodData dashboard.

For more information from Mozilla, see Disable Third Party Cookies (OS X).

Firefox for Windows Disable Blocking of Third Party Cookies

Steps:

1. Open the Firefox menu and select Options.

2. Select Privacy.

3. Set the value of the "Firefox will" setting to: Use custom settings for history.

4. Additional settings are displayed. Check Accept third-party cookies.

5. Close the Preferences window.

6. Refresh your GoodData dashboard.

For more information from Mozilla, see Disable Third Party Cookies (Windows).

For more information on GoodData system requirements, see on the subject.

Change Measure and Attribute Colors in Analytical Designer

In Analytical Designer, you can now adjust any color that represents measures and attributes in the insight.

You can select from a predefined set of colors from the color palette (default or custom), select a new color in the color picker, or enter a hexadecimal code to use your custom color. If the insight is used on a KPI Dashboard, the new colors are displayed there as well.

The new setting is a part of the insight configuration section.

Project Templates

Learn more: Change Insight Configuration

Dual Axes in Analytical Designer

You can now compare measures with different units or scales in Analytical Designer.

In bar charts, column charts, and line charts, you can select any measure to be displayed on a secondary right (line and column charts) or top axis (bar charts).

You can configure the secondary axis in the Configuration section of the insight.

Learn more: Bar Charts Column Charts Line Charts Change Insight Configuration

Preloading Embedded Analytical Designer in a Hidden iframe

To shorten the loading times when creating or editing embedded insights, you can define a postMessage that preloads Analytical Designer with data catalog in a hidden iframe.

When you then open an embedded insight, Analytical Designer loads only the insight configuration.

Learn more: Embed Analytical Designer

LAST REMINDER: Deprecation and Upcoming End-of-life: GET Method for PGP SSO Login

SSO GET method will reach end-of-life on February 15, 2019 and is being replaced by the more secure POST method. The GET method is now disabled by default.

ACTION REQUIRED!Check your current PGP SSO login implementation to ensure you are using the POST methodbefore the end-of-life, February 15, 2019.

Learn more: PGP Single Sign-on

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you?If you are using the project templates, they will stop working on May 15, 2019. Any request to the GoodData platform that includes a project template will fail.

How can you get prepared?Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED!Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager. For more information about the project template deprecation, see .

A maintenance window is scheduled for Saturday, February 16th, 2019, at 1:00 AM Pacific Daylight Time ( other time zones ). The maintenance window is planned to take up to 2 hours.

What will it bring?

Streamlining and automation of processes related to GDPR and security enhancements

System resilience improvements

How will it affect you?

1:00 - 3:00 AM: The GoodData platform and all applications will be unavailable. API calls to the GoodData platform will fail. Tasks that are scheduled to run during that time will be pending and will resume when the GoodData platform is back online.

No action required!

There is no action required from you.

We will be posting updates to this announcement to inform you about the maintenance window status. To get a notification email, subscribe to updates in this announcement.

We appreciate your patience and thank you for your understanding. If you have any question or concern, please contact GoodData Support.

Monday as First Day of Week in Date Filters for User Account

Only for the dashboards available via the 'Dashboards' option in the top menu

By default, the calendar in a date filter displays Sunday as the first day of the week. Now, you can change it to Monday for your user account on the GoodData platform. For more information, see Set First Day of Week in Date Filters to Monday.

Project Templates <==>

To set the first day of the week to Monday at the level of the domain, project group, or project, set the platform setting weekStartOnMondayEnabled to true. For more information about the platform settings, see Platform Settings.

NOTE: This setting does not affect the date filters in Analytical Designer or KPI Dashboards.

COPY FROM S3 Works Normally

COPY FROM S3 is operational again, and you can use it for loading data from Amazon S3 buckets.

What has changed:

For you to be able to use COPY FROM S3, GoodData Support must first enable it on your Data Warehouse instance.

Instead of using API, you have to provide the credentials directly in SQL commands. The API resource for setting the credentials (https://secure.gooddata.com/gdc/datawarehouse/instances/{instance_id}/s3) was removed.

Learn more: Use COPY FROM S3 to Load Data Release Notes: Why COPY FROM S3 was temporarily disabled

WITHOUT PF EXCEPT for Numeric Range Filters Improvement

The behavior of the WITHOUT PF EXCEPT clause in MAQL has been updated. The behavior is now less restrictive and more intuitive.In cases where WITHOUT PF EXCEPT was used with a numeric range filter in a MAQL metric, the report filter was not applied in the numeric range filter. With this update, the numeric range filter is filtered by the report filter as expected.

Learn more: PARENT Filters

REMINDER: Deprecation and Upcoming End-of-life: GET Method for PGP SSO Login

SSO GET method will reach end-of-life on February 15, 2019 and is being replaced by the more secure POST method. The GET method is now disabled by default.

ACTION REQUIRED!Check your current PGP SSO login implementation to ensure you are using the POST methodbefore the end-of-life, February 15, 2019.

Learn more: PGP Single Sign-on

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you?If you are using the project templates, they will stop working on May 15, 2019. Any request to the GoodData platform that includes a project template will fail.

How can you get prepared?Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED!Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager. For more information about the project template deprecation, see .

GoodData.UI Version 6.1 Available: Secondary Axis

We have released Version 6.1 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

New in this version: A secondary axis in line charts, bar charts, and column chartsIn line charts, bar charts, and column charts, you can now show measures on a secondary axis. The secondary axis can have a different scale and configuration than the primary axis. For more information, see Chart Config.

Project Templates

Ability to Set Strict Access Rights for Links to Dashboard

You can now set strict access rights when sharing dashboards with other users.

Learn more: Manage Object Visibility - Hide and Share Objects API Documentation

Table Reports: Adjust and Preserve Column Width per Measure Across Attribute Values

When resizing columns in a table report, you can now adjust and preserve the column width for any columns with the same measure that may be added to the report in the future.

For example, you have a column with a product sliced down by multiple measures (price, number of sold items, and so on). In the beginning, you may have just a few products, but with time you add more. If you preserve the column width while resizing, then whenever another product is added to the report, the columns with the measures are automatically resized to the width that you have set before.

<==>

Learn more: Adjust Column Width

Data Warehouse Upgradeto Vertica 9.1.1 Completed

We have completedupgrading the Vertica software on our Data Warehouse. It now runs on Vertica Version 9.1.1. You can find detailed information about Version 9.1.1 in Vertica's online documentation. We have updated the user documentation for our Data Warehouse accordingly.

NOTE: COPY FROM S3 is still out of order. We are currently working on making it operational again. We apologize for the inconvenience, and we will post a separate announcement whenCOPY FROM S3 is back in order.

REMINDER: Deprecation and Upcoming End-of-life: GET Method for PGP SSO Login

SSO GET method will reach end-of-life on February 15, 2019 and is being replaced by the more secure POST method. The GET method is now disabled by default.

ACTION REQUIRED!Check your current PGP SSO login implementation to ensure you are using the POST methodbefore the end-of-life, February 15, 2019.

Learn more: PGP Single Sign-on

REMINDER: Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you?If you are using the project templates, they will stop working on May 15, 2019. Any request to the GoodData platform that includes a project template will fail.

How can you get prepared?Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED!Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager. For more information about the project template deprecation, see .

User Settings API

New API endpoint that allows you to perform operations over user settings (create, read, update, delete).

Learn more: GoodData API

XLSX Options in Scheduled Emails

When scheduling emails for sending reports in XLSX, you can now select if you want to send data with merged or unmerged cells. You can also include active filters in the XLSX file.

Share Reports and Dashboards with Scheduled Emails

Learn more:

A scheduled maintenancewill take place on Saturday, December 8th, 2018 from 1:00am to 5:00am Pacific Daylight time ( other time zones )

During these 4hours, the GoodData platform and all applications will be unavailable.

New Data Integration Pipeline for Large-scale Analytical Data Products

We are proud to present you a brand new comprehensive data integration pipeline.

This pipeline covers extracting data from data sources, transforming the data according to predefined rules, and distributing it to your workspaces, where you can immediately start consuming it to create reports, insights, and dashboards.

The new pipeline is available immediately to all GoodData customers and is free of charge.

What benefits can you get from the new data integration pipeline?

A fault-tolerant, high performance and scalable system intended for large analytical data products that grows together with your business

A metadata-driven, modular, plug and play architecture, which lets you add another data source whenever you need it, without rebuilding the whole pipeline

Managing Projects via Life Cycle Management

How does it work?

Connect your data sources Scheduledata pipeline building blocks called bricks to pull data from file/object storage, relational databases, or third-party services such as Salesforce or Google Analytics.

Prepare your data

Run initial deduplication and enrichment with computed fields.

Manage how downloaded data is merged into persistent tables.

Set up a flow of SQL transformations with reusable templates to pre-aggregate, de-normalize, process time-series data, build snapshots, consolidate multiple data sources, and much more.

Distribute data to your customers Organize your customers' prepared data into customer-specific workspaces using the Automated Data Distribution (ADD) component.

Schedule and monitor

Schedule and set up dependencies between data loading tasks.

Get alerts via email or integrate alerts with third-party services (for example, PagerDuty).

See the task execution history, access log files including possible failure detail.

Learn more about the new data integration pipeline:

High-level overview

Technical documentation

If you have any question, contact your Account Manager.

Custom Colors in Analytical Designer and KPI Dashboards

You can upload your own color palette via API and Analytical Designer and KPI Dashboards will automatically use your colors from the imported palette instead of the default ones.

If you have already uploaded custom colors for the Reports and Dashboards sections in your workspace, your insights will now use these custom colors as well.

Learn more: Change Insight Configuration

Data Warehouse JDBC Driver 3.3.0 Available!

We have released version 3.3.0 of the Data Warehouse JDBC driver. Download it from the Downloads page at https://secure.gooddata.com/downloads.html.NOTE: If you are a white-labeled customer, log in to the Downloads page from your white-labeled domain:https://my.domain.com/downloads.html

What's new in this release?We improved usability and integration of the Data Warehouse JDBC Driver with visual SQL client tools (for example, DBeaver).We implemented the following:

The getDate, getTime and getTimestamp method overrides with Calendar

The getMetaData method in the PreparedStatement class

For more information, see JDBC Driver Limitations.

Learn more: Download the JDBC Driver

Data Warehouse Upgradeto Vertica 9.1.1: First Phase Completed

We have completed the first stage of upgrading the Vertica software on our Data Warehouse to Version 9.1.1.Completing the upgrade will take a few weeks.

NOTE: COPY FROM S3 is not working while the upgrade to Version 9.1.1 is in progress. It will be operational again when the upgrade is complete. For more information, see the previous Release Notes.

We will be posting moreannouncementsto let you know the upgrade status.

Deprecation and Upcoming End-of-life: GET Method for PGP SSO Login

SSO GET method will reach end-of-life on February 15, 2019 and is being replaced by the more secure POST method. The GET method is now disabled by default.

ACTION REQUIRED!Check your current PGP SSO login implementation to ensure you are using the POST methodbefore the end-of-life, February 15, 2019.

Learn more: PGP Single Sign-on

Deprecation and Upcoming End-of-life: Project Templates

The project templates are deprecated and will stop working on May 15, 2019.

How will this affect you?If you are using the project templates, they will stop working on May 15, 2019. Any request to the GoodData platform that includes a project template will fail.

How can you get prepared?Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.

ACTION REQUIRED!Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.

Learn more:For more information about LCM, see or contact your Account Manager.

GoodData.UI Version 6.0.0 Available: Pivot Table, React 16, and Others

We have released Version 6.0.0 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

What's new in GoodData.UI Version 6.0.0?

Pivot Table component addedIn contrast to the standard (flat) table, the pivot table allows you to break measures into columns by setting attributes in the columns prop. You can use the Pivot Table component to create both pivot and standard tables. For more information, see Pivot Table. have announced earlier Action needed: Use the Pivot Table component for creating both pivot and flat tables.

Support for React 16 added; React 15 deprecatedGooddata.UI now supports React 16. Support for React 15 has been dropped.Action needed: Update your application to use React 16 to avoid a package duplicity issue and other potential issues. In addition, update all your packages with the React dependency, such as 'react-dom', 'react-router', and others.

AFM components deprecatedThe AFM components have been deprecated and will be removed by the end of September 2019.Action needed: For new insights, use the corresponding visual components listed under 'Visual Components' (for example, Area Chart, Bar Chart, Column Chart, and so on). If you have any insights based on the AFM components, re-create them using the corresponding visual components.

Heatmap properties renamed, Area Chart properties changedIn the Heatmap component, the segmentBy and trendByproperties have been renamed. In the Area Chart component, the type of the stackBy and viewBy properties has been changed.Action needed: Review the Migration Guide, and update the corresponding properties in your application. For additional information, see Heatmap and Area Chart.

More options in ChartConfig availableWhen configuring an insight's options via Chart Config, you can now change a separator in the number format, configure the axes and data labels, and set colors in the hexadecimal format (#ff0000) in addition to RGB values (rgb(255, 0, 0)).

GoodData.UI license updatedGoodData.UI is now dual-licensed. This allows us to better integrate third-party libraries. You can review the updated license here.

Monday as First Day of Week in Date Filters

Only for the dashboards available via the 'Dashboards' option in the top menu

By default, the calendar in a date filter displays Sunday as the first day of the week. Now, you can change it to Monday.

<==>

How can you do this?To set the first day of the week to Monday, set the platform setting weekStartOnMondayEnabled to true. For more information about the platform settings, see Platform Settings.

NOTE: This setting does not affect the date filters in Analytical Designer or KPI Dashboards.

Data Warehouse Upgradeto Vertica 9.1.1 Started

As we, we have started upgrading the Vertica software on our Data Warehouse to Version 9.1.1.Completing the upgrade will take a few weeks.

We will be posting moreannouncementsto let you know the upgrade status.

COPY FROM S3 Temporarily Not Working

In Version 9.1.1, Vertica has changed the way how the COPY FROM S3 command works and handles credentials for S3 buckets. COPY FROM S3 is not working while the upgrade to Version 9.1.1 is in progress (see the article above).

When the upgrade is complete, COPY FROM S3 will be operational again, but the way of providing the credentials will change:

Before, you had to set the credentials via the REST API.

With Vertica Version 9.1.1 in place, you will provide the credentials directly in SQL commands.

The API resource for setting the credentials (https://secure.gooddata.com/gdc/datawarehouse/instances/{instance_id}/s3) has been removed.

How does it affect you?

If you do not use COPY FROM S3, your work is not affected. There are no action needed.

If you need to use COPY FROM S3, copy files from the S3 bucket to a local client, and use COPY FROM LOCAL instead.

A scheduled maintenancewill take place on Saturday, November 10th, 2018 from 1:00am to 5:00am Pacific Daylight time ( other time zones )

During these 4hours, the GoodData platform and all applications will be unavailable.

Date Filters with Multiple Date Dimensions in Analytical Designer

When filtering your data by date, you can now use different date dimensions for each measure in your insight in Analytical Designer.

For example, you can display opportunities that were created in the current quarter and slice them by month in which they were closed.

API for listing all S3 credentials

This feature is available upon request.

Learn more: Filter Measures by Date

New API Event for Embedded Dashboards: Report Loaded Successfully

If you have embedded dashboards, you can now be notified when a report successfully loaded.

To do so, use the API event 'The report successfully loaded':

{ gdc: { name: 'report.info', type: 'app.ok' }}

Learn more: Embedded Dashboard Events Embedded Dashboard and Report API - Events and Methods

Default XAE Version in New Domains

As of this release, the default XAE version in new domains will be set to 3. If you create a new domain in GoodData, the default XAE version unlocks access to the latest capabilities such as Many-to-Many support.

All existing domains and customers are not impacted by this and remain on XAE version 1. We encourage you toconsider upgrading to XAE version 3 to benefit from the latest capabilities. For more details, check XAE Version 3 Prerequisites.

Learn more: Many-to-Many Reporting

Announcement: Upcoming Data Warehouse Upgradeto Vertica 9.1.1

We areplanning to upgrade the Vertica software on our Data Warehouse to Version 9.1.1. Completing the upgrade will take a few weeks.

We will be posting separate announcementsto let you know the upgrade status.

Announcement: Handling Credentials in COPY FROM S3 Will Change

In Version 9.1.1, Vertica has changed the way how the COPY FROM S3 command works and handles credentials for S3 buckets. Because the upgrade on Data Warehouse will take a few weeks to complete, COPY FROM S3 will not be working during the upgrade.

When the upgrade is completed, COPY FROM S3 will be operational again, but the way of providing the credentials will change.Currently, you set the credentials via the REST API. With Vertica version 9.1.1, you will provide the credentials directly in SQL commands.

How does it affect you?

If you do not use COPY FROM S3, your work will not be affected. There are no action items.

If you use COPY FROM S3, you may need to take some actions:

Upcoming change: The COPY FROM S3 command will stop working when the Data Warehouse upgrade starts.Action needed: Copy files from the S3 bucket to a local client. While COPY FROM S3 is not working, use COPY FROM LOCAL.

Upcoming change: Setting the credentials via REST API will become obsolete, and the corresponding resource at https://secure.gooddata.com/gdc/datawarehouse/instances/{instance_id}/s3 will be removed. Any S3 credentials that have been saved this way will be dropped.Action needed: Check whether you have S3 credentials stored in your Data Warehouse instance (see the ).

Time Over Time Comparison - Previous Period

In Analytical Designer, you can now compare any item in the Measures section to the previous time period.

For example, if you filter your data to a 10-day period, 21-30 of March, Analytical Designer compares it to the previous 10 days, 11-20 March. Or, if you filter data to this month (October 2018), Analytical Designer compares it to the previous month (September 2018).

As with the comparison to the same period of the previous year released earlier, you set this comparison in the date filter, and Analytical Designer creates new items in the Measures section.

User Roles

Learn more: Time over Time Comparison in Analytical Designer

Change Insight Configuration

Analytical Designer now lets you change the properties of individual insights. You can show/hide axes, change the position of the legend, show/hide data labels, and so on.

Learn more: Change Insight Configuration

JDBC Driver: End-of-Life of Version 2.8.0 through 2.9.0

Starting from October 4, 2018, the JDBC driver version 2.8.0 through 2.9.0 is no longer supported.

Action needed: Check the version of your JDBC driver. If your version is 2.8.0 through 2.9.0, upgrade to the latest version, 3.1.2:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

Learn more:For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

Improvement in Period-Over-Period Behavior

Improvements to period-over-period calculations now result in more accurate reports afterfixing inconsistent behaviour, especially those that involve leap years. For more information how to create period over period using MAQL functions please follow the link below.

Learn more: Build a Period-Over-Period Report

Announcement: Default XAE Version in New Domains

In GoodData's mid-October 2018 release, the default XAE version in new domains will be set to 3. If you create a new domain in GoodData, the default XAE version will unlock access to the latest capabilities such as Many-to-Many support.

All existing domains and customers will not be impacted by this and will remain on XAE version 1. We encourage you toconsider upgrading to XAE version 3 to benefit from the latest capabilities. For more details check XAE Version 3 Prerequisites.

Learn more: Many-to-Many Reporting

Announcement: Planned Changes in User Roles

We are planning to make changes in the user roles that are available on the GoodData platform.

What is going to change?

The two existing roles will be renamed:

'Embedded Only Explorer' will become 'Explorer (embedded only)'.

'Embedded Dashboard Only' will become 'Viewer (embedded only)'.

The following new roles will be introduced:

Editor with a permission to invite users to the project

Editor with a permission to invite users to the project, to manage relations between data permissions and users, and to manage variables

Viewer with a restricted permission to export reports

Action needed:Renaming the two existing user roles may affect you in the following cases:

If you are usingthe Users brick, which is a part of Life Cycle Management.

If you have implemented custom API-based user provisioning processes.

In these cases, make sure that you are using the internal role identifiers and not the names of the user roles that are going to be renamed. The internal role identifiers will not change. Using the user role names instead of the internal role identifiers will cause user provisioning processes to fail after the planned changes are implemented.

Use explorerOnlyRole for the 'Embedded Only Explorer' user role.

Use dashboardOnlyRole for the 'Embedded Dashboard Only' role.

We will post a separate announcement when the changes in the user roles are implemented.

Learn more:

A scheduled maintenancewill take place on Saturday, October 20th, 2018 from 1:00am to 5:00am Pacific Daylight time ( other time zones )

During these 4hours, the GoodData platform and all applications will be unavailable.

A scheduled maintenancewill take place on Saturday, September 8th, 2018 from 1:00am to 3:00am Pacific time ( other time zones )

During these2 hours, the GoodData platform and all applications will be unavailable.

Dates Are Exported to XLSX as Date Data Types

Previously, all dates in your reports were transformed into strings during the export to XLSX.

From this release, the dates are exported as date data types so that you can further analyze all the data.

If you are using, for example, any custom macros based on strings, make sure to update them.

New Version of GoodData Ruby SDK

A new version of the GoodData Ruby SDK is available. The current version is now 1.3.1

Learn more: GoodData Ruby SDK Changelog

REMINDER: Upcoming End-of-life of JDBC Driver Version 2.8.0 through 2.9.0

On October 4, 2018, the JDBC driver version 2.8.0 through 2.9.0 will stop working.

How will this affect you?If you are using version 2.8.0 through 2.9.0 of the JDBC driver, it will stop working on October 4, 2018. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

Action needed:Before October 4, 2018, check the version of your JDBC driver.If your version is 2.8.0 through 2.9.0, upgrade to the latest version, 3.1.2:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

We will post a separate announcement when the end-of-life happens for the JDBC driver version 2.8.0 through 2.9.0.

Learn more:For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

Heatmap - New Insight Type in Analytical Designer and KPI Dashboards

In Analytical Designer, you can now create heatmaps.

Heatmaps display data as a matrix where individual values are represented as colors. You can use heatmaps to discover trends and understand complex datasets.

Data Warehouse Driver Version

Learn more: Heatmaps Insight Types in Analytical Designer

New Load Mode in Automated Data Distribution

When uploading data to projects using Automated Data Distribution (ADD), you can now use UNRESTRICTED load mode in the executed data load process. UNRESTRICTED load mode allows you to customize your data loading strategy, to make it even more flexible, and to decrease data latency in your projects.UNRESTRICTED mode is available for executing ADD data load processes via the API.

When can you benefit from UNRESTRICTED mode?With UNRESTRICTED mode, you can split a data load increment into multiple tasks and upload the data in portions in a specific order so that the most relevant data is available in your projects as soon as possible. UNRESTRICTED mode lets you prioritize data to upload.

For example, you may want to first upload the data about your premium customers so that you can analyze it first, and then you can proceed with the rest of the data. Or, you may want your end users to first see the most recent data (let's say, for the last month), and you can load the older data later.

How does UNRESTRICTED mode work?In addition to specifying load mode per dataset (as CUSTOM load mode already allows), you can also specify additional parameters. For example, the condition parameter lets you define a condition to enrich the SQL fetch query and narrow down the data selected from the ADD output stage:"condition": "a__company=ACME""condition": "d__date BETWEEN '2018-12-01' AND '2018-11-01'"

Are there any access rights required?To be able to use UNRESTRICTED mode, you must have access to the Data Warehouse instance that is set in the ADD output stage for the project.

WARNING: UNRESTRICTED mode is intended only for experienced users. You should use UNRESTRICTED mode only if you are confident in executing the schedule via the API and have a deep understanding of your data. Using UNRESTRICTED mode incorrectly or with wrong parameters may result in data inconsistency in your projects. If you are not sure whether to use UNRESTRICTED mode, we recommend that you use DEFAULT or CUSTOM mode.

Learn more: Automated Data Distribution API: Execute a schedule

New API and Introducing API Versioning

List user projects and roles now allows paging and with this GoodData's public API is introducing versioning. This allows GoodData to release new API without breaking existing clients for the purposes of deprecation and end-of-life of old API. GoodData API versioning will not break existing clients without giving you a chance to adapt the newer API.

Learn more: API Versioning information and Changelog GoodData API - List user projects and roles

Data Preparation and Data Evaluation Functions Available in Data Warehouse

Data Warehouse now supports preprocessing and postprocessing functions to simplify data transformations for Machine Learning.

You can use the following Vertica functions in Data Warehouse:

Data preparation functions

APPLY_NORMALIZE - Applies the normalization parameters saved in a model to a set of specified columns in the input table or view.

BALANCE - Balances the data.

DETECT_OUTLIERS - Removes the outliers from the data.

IMPUTE - Imputes missing valueswith either the mean or the mode, based on observed values for a variable.

NORMALIZE - Runs a normalization algorithm on an input table or view.

NORMALIZE_FIT - Computes normalization parameters for specific columns in an input table.

REVERSE_NORMALIZE - Reverses the normalization transformation.

Data evaluation functions

CONFUSION_MATRIX - Returns a confusion matrix based on both predicted and observed values.

ERROR_RATE - Returns a table that calculates the rate of incorrect classifications.

LIFT_TABLE - Returns a table that compares the predictive quality of a binary classifier model.

MSE - Returns a table that displays the mean squared error.

ROC - Returns a table that displays the points on a receiver operating characteristic curve.

RSQUARED - Returns a table with the R-squared value of the predictions in a linear regression model.

Learn more: Data Preparation and Data Evaluation Functions

Set Fixed Headers and Include Filter Context in Excel Exports

Admins may set a fixed customer headers for Excel exports. Each sheet may contain up to five top rows with text or using macros (date, time, project id etc.)

Also when exporting to XLSX, you can include active filters in the exported file for each exported report.

Learn more: Export File Types Configure Custom Headers for XLSX Report Exports API reference

UPCOMING: Dates Are Exported to XLSX as Date Data Types

Previously, all dates in your reports were transformed into strings during the export to XLSX.

With the next release, the dates will be exported as date data types so that you can further analyze all the data.

If you are using, for example, any custom macros based on strings, make sure to update them for the next release.

REMINDER: Upcoming End-of-life of JDBC Driver Version 2.8.0 through 2.9.0

On October 4, 2018, the JDBC driver version 2.8.0 through 2.9.0 will stop working.

Please note that we have postponed the date from September 20, 2018, to October 4, 2018. However, If you are using version 2.8.0 through 2.9.0 of the JDBC driver, we strongly recommend that youupgrade to the latest version, 3.1.2, as soon as possible.

How will this affect you?If you are using version 2.8.0 through 2.9.0 of the JDBC driver, it will stop working on October 4, 2018. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

Action needed:Before October 4, 2018, check the version of your JDBC driver.If your version is 2.8.0 through 2.9.0, upgrade to the latest version, 3.1.2:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

We will post a separate announcement when the end-of-life happens for the JDBC driver version 2.8.0 through 2.9.0.

Learn more:For more information about the end-of-life rules for the JDBC driver, see .

A scheduled maintenancewill take place on Saturday, July 7th, 2018 from 1:00am to 5:00am Pacific Daylight time ( other time zones )

During these 4hours, the GoodData platform and all applications will be unavailable.

A scheduled maintenancewill take place on Saturday, September 15th, 2018 from 1:00am to 5:00am Pacific Daylight time ( other time zones )

During these 4hours, the GoodData platform and all applications will be unavailable.

GoodData.UI Version 5.3 Available: Heatmap

We have released Version 5.3 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.

New in this version: Heatmap componentHeatmap displays data as a matrix where individual values are represented as colors. Heatmaps can help you discover trends and understand complex datasets. For more information, see Heatmap.

Data Loading and IP Whitelisting

Treemap - New Insight Type in Analytical Designer and KPI Dashboards

In Analytical Designer, you can now create treemaps.

Treemaps display your data hierarchically as nested rectangles and you can use them to compare proportions within the hierarchy.

Learn more: Insight Types in Analytical Designer Treemaps

Setting Time Zone for Scheduled Emails

When setting up automatic emailing of dashboards and reports from the Manage page, you can now set up a time zone for a scheduled email.

Learn more: Share Reports and Dashboards with Scheduled Emails

Custom Calendars - Date Range Changes

Custom Date Dimension is extending support to cover ranges between 1.1.1900 to 31.12.2100. For more information follow the link below.

Learn more: Custom Calendar - Self Service

Upcoming End-of-life: JDBC Driver Version 2.8.0 through 2.9.0

On September 20, 2018, the JDBC driver version 2.8.0 through 2.9.0 will stop working.

How will this affect you?If you are using version 2.8.0 through 2.9.0 of the JDBC driver, it will stop working on September 20, 2018. You will receive the following error message:

You are using an unsupported version of the JDBC driver.

Download and install the latest version of the driver itself or

CloudConnect from https://secure.gooddata.com/downloads.html.

Action needed:Before September 20, 2018, check the version of your JDBC driver.If your version is 2.8.0 through 2.9.0, upgrade to the latest version, 3.1.2:

If you are using the driver directly, download and install the latest version of the driver from the Downloads page.

If you are using the driver via CloudConnect,upgrade your CloudConnect tothe latest version:from the menu bar, click Help -> Check for Updates.

We will post a separate announcement when the end-of-life happens for the JDBC driver version 2.8.0 through 2.9.0.

Learn more:For more information about the end-of-life rules for the JDBC driver, see Data Warehouse Driver Version.

ACTION NEEDED: Whitelist SecuredProxy IP Addresses

The GoodData datacenters are configured with multiple secured proxies. If a secured proxy is unavailable, traffic is served by any other available proxy within the pool.

To prevent data load failures, the IP addresses of all proxies must be whitelisted on your firewall.

Action needed:Check whether all secured proxy IP addresses are added to your firewall. If they are not, please add them.

United States datacenter: 108.171.171.238 and 23.253.9.202

European Union datacenter: 78.136.2.250 and 134.213.186.151

Canada datacenter: 209.151.86.53 and 209.151.86.60

Learn more: