New GoodData Support Portal is Live!

We rolled out the new Support portal! The new portal serves as a single point of service for the GoodData Support and documentation and lets you navigate through helpful information faster and easier. The search functionality now searches through all our information resources, and returns results from the Support portal, the Developer portal, and the online help.Visit the Support portal.

Subscribe to Release Notes

Starting with the next release in January 2016, we will be posting the Release Notes as a separate article for each release. We will not be updating this Release Notes article anymore.To keep yourself notified about GoodData platform updates and improvements, subscribe to our upcoming Release Notes articles:

You will now be subscribed for updates in the Release Notes section. When we post a new Release Notes article, you will get an email notification.

December 5, 2015

End-of-Support of FQL (Facebook Query Language)

Due to the changes in the Facebook Platform API, we dropped the support of the FQL option in CloudConnect (the Facebook Reader). Only the Graph API option is available.Сheck your graphs in CloudConnect, and make sure that they are using Graph API.

New GoodData Support: Coming Soon!

In the coming weeks, GoodData will be rolling out the new-look Support portal home page. The new page will serve as a single point of service for the GoodData Support and documentation and will let you navigate through helpful information faster and easier.Stay tuned!

Bulk Client Update API

The bulk client update API allows you to update multiple clients at once as part of Life Cycle Management.

CSV Uploader: Add Data from File without Affecting Other Project Data

You can now upload a set of data to your GoodData project and analyze it on an ad hoc basis without affecting the rest of the data in your project.The data from a file is added as a separate dataset and does not affect the existing datasets. Once the data is added, you can immediately start analyzing it in Analytical Designer (if you have it enabled) or in the Report editor.

CSV Uploader is immediately available for Direct customers.If you are a Powered by GoodData customer and want to use CSV Uploader, contact the GoodData Support.

Life Cycle Management

Life Cycle management is a new feature for GoodData. Enabled for Powered by GoodData and Enterprise Data Monetization (PbG and EDM) customers, Life Cycle Management allows you to configure and control multiple customer projects through easily configurable single master projects. This allows you to carry out executions that propagate your data to your customers quickly and accurately.

API: New Parameter for Project Models and MAQL DDL Scripts

When creating a project model or generating a MAQL DDL script via API, you can now decide whether to include non-production datasets in the project model.Non-production datasets are the datasets that have been generated based on data from a file. Such datasets are stored separately and are not connected to the datasets in your project model (production data).

Example of the resource for creating a project model including non-production datasets:

Analytical Designer

With the introduction of CSV Uploader to the GoodData platform two concepts of data are now used:

Production data is the data processed by ETL.

Non-production data is data uploaded by users of the CSV uploader.

Integration with CSV Uploader

In order to improve your GoodData experience, you can access CSV Uploader directly from Analytical Designer by clicking either the Load tab or the Add data link.When using Analytical Designer with data from CSV Uploader, you can easily filter out any non-production data by checking the My data and Others’ data check boxes in the Production data tab.Learn More:

Usability Changes

Owing to changes in development processes, the order of lists in attribute filters may be different than before this release. Some filtered attributes that displayed in ascending order may now display in descending order.If you need to display your attribute filters other than the current behavior, please contact the GoodData Support.

Upgrade CloudConnect to the Latest Version

If you want to use CSV Uploader, verify what version of CloudConnect you are running. If you have older versions of CloudConnect in use, you may experience data consistency issues in your data model.

What can you do to prevent this?Check what version of CloudConnect you are using: click CloudConnect -> About CloudConnect.

Unit Conversion in Metric Formatting

New API Resource for Objects Listing

The objects/query API is used to get list of full metadata objects of given type (or "category"). (Each returned object is same as that object on /obj resource.) The resource allows you to easily return a group of objects in one request.

Upgrade CloudConnect to the Latest Version

With great new features planned to be released soon, we’re asking you to get ready for them in advance by verifying what version of CloudConnect you are using.When the new features go live, you may experience data consistency issues in your data model if you are using older versions of CloudConnect.

What can you do to get ready for the upcoming updates?Check what version of CloudConnect you are using: click CloudConnect -> About CloudConnect.

Don’t worry, when the new features are available, we will post a separate announcement to remind you to check your CloudConnect version if you can’t do it now.

October 26, 2015

Upcoming End-of-Support of FQL (Facebook Query Language)

Due to the changes in the Facebook Platform API, we are going to drop the support of the FQL option in CloudConnect (the Facebook Reader). Only the Graph API option will be available.Сheck your graphs in CloudConnect, and make sure that they are using Graph API.

CloudConnect: Microsoft JDBC Driver for SQL Server Driver Updated

For the customers using Microsoft SQL Server

We updated CloudConnect with the latest version of Microsoft JDBC Driver for SQL Server: sqljdbc41-4.2.6420.If you use Microsoft SQL Server for data loading, we recommend that you update your CloudConnect to the latest version from the GoodData Developer portal.

Projections Automatically Refreshed at Creation

When you create a projection, the anchor table is automatically refreshed, and the projection gets updated.

September 24, 2015

New MAQL Statement - Specify Rolling Window

The ROWS BETWEEN statement specifies a rolling window over which running total functions (for example RUNAVG) are computed. Running total functions such as RUNSUM, RUNAVG, RUNMIN and RUNMAX can be specified with rolling window or a shifted boundary.This statement can be used to display a moving average that can plot and display long term trends in your data.Learn More:Rolling Window

Analytical Designer

Improvements to Analytical Designer searchability. Any unrelated data that cannot be added to your visualization is now hidden, allowing you to display only the data relevant to your report.

Handle Drilling Report Requests via Your Own System

For Powered by GoodData customers

You can set up the GoodData platform so that you can manage users’ requests to drill into reports yourself instead of relying on the platform.

This means, when a user clicks a value within an embedded report, or in a report in the embedded dashboard, your web application catches the drilling request, analyzes it, and sends back the drilling data from your system.

Upcoming End-of-Life

To keep providing our customers with a best-in-class platform, we are announcing the end-of-life of some features and components on September 30, 2015. This will allow us to focus on high value features and components that enhance your experience using the GoodData platform.

Starting on September 30, 2015, these features will no longer be available in the platform:

GoodData iPad AppFeature: The GoodData iPad app will be removed from the Apple App Store and will no longer be supported. We are moving towards an HTML5 strategy which will focus on the mobile experience.Alternatives: You can currently view the dashboards at secure.gooddata.com in Chrome and Safari browsers on an iPad.

Search

Feature: Search will no longer be available in the GoodData Portal. It will be removed from the top navigation.Alternatives: Use standard search on reports/metrics/attributes pages in the browser (Command-F on Mac OS, or Ctrl-F on Windows/Linux).

PulseFeature: The Pulse tab will no longer be available in the Manage page in the GoodData Portal.Alternatives: Author and change time can be found under Reports, Metrics, and Attributes sections of the GoodData Portal.

Upcoming WebDAV Upgrade

We are going to upgrade WebDAV on the NA datacenter on October 10, 2015.When the new version is deployed, the /gdc resource will be returning a different URI for user staging.

How will this affect you?

If you access WebDAV programmatically, use the returned URI exactly as is.

If you use Ruby SDK, CloudConnect, or the CL tool, update the tool that you are using to the latest version from the GoodData Developer portal.

September 12, 2015

Ruby SDK 2.0 Available!

GoodData Ruby SDK version 2.0 is now available for you!

How does it affect you?

You can script these (and many other!) tasks:

Creating multiple projects with the same logical model, metrics, reports, and dashboards

Performing changes on multiple dashboards, reports, or metrics

Migrating new versions of dashboards, reports, or metrics to multiple projects

Deploying and scheduling ETL processes in multiple projects

Investigating many metrics at once

Finding out the number of rows in each project's dataset

Provisioning multiple users to multiple projects

We've also added many new useful capabilities into the GoodData automation framework version 2.0, such as:

Support for LDM folders, datatypes, and date formats

Reports and dashboards scripting

Loading data into multiple datasets at the same time

Switching an existing date dimension for a different (for example, fiscal) date dimension

We've improved the framework's performance and quality, as well as documentation.

August 29, 2015

Analytical Designer available for all Direct Customers

The Analytical Designer is now available for all direct customers without limitation. Just click the Analyze tab on your GoodData project to try it for yourself.

The Analytical Designer is a tool for data discovery and visualization creation where you can quickly answer business questions as they arise. Drag-and-drop data onto interactive drop zones and the visualization canvas will dynamically adjust (charts, graphs, and tables). With only a few clicks you can create a visualization, add or remove data from it, slice it, filter it, and change the way it is visualized.

As you create a visualization, the Analytical Designer recommends best practices and next steps. These recommendations leverage the collective intelligence of GoodData’s cloud platform, helping you discover new ways to visualize your data and get value from it.

Data Warehouse Upgraded to HP Vertica 7.1

In our continuous effort to deliver the best service, we have upgraded Agile Data Warehouse Service (ADS) to HP Vertica 7.1.

All changes have been applied to your ADS instances automatically. No action is needed.

Analytical Designer - Filter Improvements

New usability refinements have been added to improve search and selection of filters.

Search - search for filters by entering your desired search text.

Only - tick the ‘only’ check box to select that filter only.

Reminder - MAQL Function Deprecation

All remaining projects (including old-format time macros) have now been automatically migrated when deployed to production.

August 15, 2015

New GoodData Help Available!

The new GoodData documentation site is now live. Check out https://help.gooddata.com for a new documentation experience with improved navigation and look-and-feel.

How will this affect you?GoodData Help still lives at help.gooddata.com but due to architectural changes, your saved bookmarks and links will change. Update any saved links or bookmarks if you have them.We’ll continue to improve the documentation experience in the coming months, so stay tuned for further enhancements as we roll them out.

MAQL Function Deprecation

MAQL time macros in braces such as {This}, {Previous}, {Next}, {ThisYear}, {LastWeek} and so on have been deprecated and been replaced by the THIS, PREVIOUS, and NEXT keywords.Notes:

Using the braces format will no longer be supported in MAQL. Ensure that you use the keyword format for MAQL time macros from now on. Any existing metrics and reports that use this format will be migrated to the new format automatically.

Projects created from templates may still contain old-format time macros (in braces). These will still work when executed.

If you must manually edit a metric with the old-format time macros (in braces) please contact support at https://support.gooddata.com/home.

After the next release (scheduled August 29) all remaining projects (including old-format time macros) will be automatically migrated when deployed to production. All new projects from templates will contain new-format time macros (without braces).

Pagination for Listing Data Warehouse Instances and Users via API

When listing data warehouse instances or users via GoodData API, the results are now returned broken into pages. By default, one page has 100 records.

Two new optional parameters have been introduced:

limit specifies the maximum number of records per page.

offset defines the offset of the first record on a page. You can reuse the value of the offset parameter, which is an element of the link in the next parameter from the previous response from this resource.

File Size Limit Raised to 5 MB for the Process Deployment

We raised the ZIP file size limit for processes (CloudConnect graphs or Ruby scripts) that you deploy in your project. You can now upload a ZIP file to the limit of 5 MB.This size limit is applied regardless of where you initiate the process deployments from: via the GoodData Portal, CloudConnect, or GoodData API.

User Provisioning via Login

Analytical Designer

Private Measure Visibility - to unify Analytical Designer behavior with the rest of the GoodData platform, all private, user-created measures are visible only to that user.

Scatter Explorer

All entries in the Scatter Explorer list now display properly.

Reports Saved from Analytical Designer

We have fixed an issue with saving reports in Analytical Designer.If you have saved any reports that you created in Analytical Designer, be sure to check these reports. Due to the issue, they may not be computable, and you see the following message:

Report not computable due to improper metric definition

In this case, correct the measures (metrics) that you created for these reports.All newly created reports will work correctly.

August 1, 2015

Analytical Designer

Custom Measure Building

Measures can now be customized with the custom measure feature. Expand any of your displayed measures and apply a calculation from the drop down menu including currently:

Sum

Average

Minimum

Maximum

Median

Running sum

Custom Date Support

Analytical Designer now supports custom fiscal dates for the following time periods:

Week (Sun-Sat)

Month

Quarter

Year

Note: To improve your experience with Analytical Designer this release introduces the concept of measures and calculated measures (formerly facts and metrics respectively).

Analytical Designer Documentation Updates

The following documentation has been updated for this release. Changes in documentation will be reflected when the new GoodData documentation portal is launched.

The Analytical Designer is an environment for data discovery and visualization. Drag-and-drop data onto interactive drop zones and the Analytical Designer creates visualizations (charts, graphs, and tables). With only a few clicks you can create a visualization, add or remove data from it, slice it, filter it, and change the way it is visualized. The visualization changes dynamically with each click, enabling you to play with your data and discover business insights.

As you create a visualization, the Analytical Designer recommends best practices and next steps. These recommendations leverage the collective intelligence of GoodData’s cloud platform, helping you discover new ways to visualize your data and get value from it.

Currently, the Analytical Designer is enabled for Direct customers with projects that contain less than 5 GB of data. Steps:

1. Click Analyze on the project toolbar to open the Analytical Designer.2. Begin building the visualization:

Drag a measure () from the list onto any active drop zone to visualize its data. You can add up to three measures.

3. Add detail to the visualization. You can interact with any of the following tools:

Measures - Select an option in the Measures drop zone to show measure values in percents or generate a year over year comparison.

View by - Drag a date () or attribute () onto the View by drop zone to slice your visualization.

Stack by/Segment by - Drag an attribute onto the Stack by drop zone to split the display into a stacked bar chart.

Recommended Next Steps - Apply one of these options to let the Analytical Designer create useful visualizations for you.

The recommendations that appear when you add a measure are based on actions GoodData users typically perform in similar analytical scenarios. They help you quickly create a visualization that provides business value.

4. Tune the visualization. After you have selected the measures, dates, and attributes for your visualization, you can optionally tune the visualization in the following ways:

Customize measures:Filter measures by attribute:Add filters to chart/table:You can also filter whole charts and tables by dragging a date or attribute:Change Date granularity:Change the visualization type:

5. Click Open as Report to open the visualization in the Report Editor.6. Optionally modify the visualization, then save it.

Your visualization is saved as a report and ready to add to dashboards.

You must open a visualization in the Report Editor to save it so that you can add it to dashboards. You cannot save a visualization in the Analytical Designer at this time.

FAQs:

Can the Analytical Designer be used on any project?Not yet. Currently the Analytical Designer is turned only only for Direct customers whose projects contain less than 5 GB of data.

Can I create calculated measures in the Analytical Designer?

Measures can now be customized with the custom measure feature. Expand any of your displayed measures and apply a calculation from the drop down menu including currently:

Sum

Average

Minimum

Maximum

Median

Running sum.

New MAQL Functions

Two new MAQL functions have been added. The functions GREATEST and LEAST select the highest and lowest values from facts or metrics within a row respectively.

New MAQL Functions Documentation

The following documentation has been updated for this release. Changes in documentation will be reflected when the new GoodData documentation portal is launched.

GREATEST

DescriptionIdentifies the highest value from a selection of facts or metrics within one row.

ExamplesThe LEAST of the Direct Sales, Channel Sales, and Custom Services metrics is a volume of the smallest selling segment.

Reminder: Updates to GoodData Help Coming Soon!

The GoodData documentation team is still working on improving your experience using help.gooddata.com. In the coming weeks, we will roll out a more navigable version of GoodData Help with improved look-and-feel.

How will this affect you?

GoodData Help will remain at help.gooddata.com but links to individual articles will change. You will need to update any saved links or bookmarks.

July 18, 2015

Number Format Editor

The number format editor has been expanded to allow better visualization of custom number formats including the following features:

Preview of number format displays as you create.

Predefined use templates to quickly apply the most common formats.

ADS Security Barriers

A new schema, catalog, has been introduced in Agile Data Warehousing Service (ADS). The v_monitor and v_catalog schemas have been transparently rewritten.

You can now create tables with system names (for example, users).

NOTE: For security reasons, the v_internal schema, and some tables and columns are not accessible.

Setting of an Environment for an ADS Instance

You can now define an environment when creating an ADS instance via the GoodData API. The environment is set up during the instance creation, and cannot be updated later.

The environment value can be:

PRODUCTION

DEVELOPMENT

TESTING

The default value is PRODUCTION.

PRODUCTION and DEVELOPMENT instances are backed up and archived. TESTING instances are not backed up and archived.

Unless you need the instance backup and archive, we recommend that you set up the instance environment to TESTING.

Reminder: Updates to GoodData Help Coming Soon!

The GoodData documentation team is working on improving your experience using help.gooddata.com. In the coming weeks, we will roll out a more navigable version of GoodData Help with improved look-and-feel.

How will this affect you?

GoodData Help will remain at help.gooddata.com but links to individual articles will change. You will need to update any saved links or bookmarks.

July 7, 2015

Upcoming Deprecation

To keep providing our customers with a best-in-class platform, we are announcing the deprecation of some features and components. This will allow us to focus on high value features and components that enhance your experience using the GoodData platform.

The deprecation date is the date when GoodData will stop investing in improvements of that feature. We suggest that you do the same and make steps to adopt the alternative when available.

The end of life date is the date when the feature will no longer be available in the platform.

GoodData iPad App

Feature: The GoodData iPad app will be removed from the Apple App Store and will no longer be supported. We are moving towards an HTML5 strategy which will focus on the mobile experience.Alternatives: You can currently view the dashboards at secure.gooddata.com in Chrome and Safari browsers on an iPad.Deprecation Date: July 1, 2015End of Life Date: September 30, 2015

IE 9 and 10 Support

Feature: Internet Explorer versions 9 and 10 will no longer be a supported browser for the GoodData platform. Microsoft is discontinuing their support of IE versions older than 10 for most of their operating systems (Windows 7 and newer) and encouraging customers to migrate before January 12, 2016.Alternatives: Supported browsers are Chrome, Safari, Firefox, IE 11.Deprecation Date: July 2, 2015End of Life Date: January 15, 2016

Search

Feature: Search will no longer be available in the GoodData Portal. It will be removed from the top navigation.Alternatives: Use standard search on reports/metrics/attributes pages in the browser (Command-F on Mac OS, or Ctrl-F on Windows/Linux).Deprecation Date: July 2, 2015End of Life Date: September 30, 2015

Pulse

Feature: The Pulse tab will no longer be available in the Manage page in the GoodData Portal.Alternatives: Author and change time can be found under Reports, Metrics, and Attributes sections of the GoodData Portal.Deprecation Date: July 2, 2015End of Life Date: September 30, 2015

White Labeled and Partner Documentation

Feature: White label and partner specific documentation will no longer be available.Alternatives: Copy-Paste documentation information from documentation at help.gooddata.com.Deprecation: ImmediatelyEnd of Life: July 7, 2015

GoodData-provided FTPS and SFTP Server for Customer Uploads

Feature: GoodData will no longer be providing FTPS and SFTP server interface for data uploads.Alternatives: You can use WebDAV at secure.gooddata.com/gdc/uploads using our standard platform authentication (HTTP-Basic or cookie-based). WebDAV is secure and unlike FTP supports SST-based authentication.Note: Only the uploads to GoodData using FTP will be deprecated. Data download from other FTP servers using CloudConnect will continue to be supported.Deprecation Date: July 2, 2015End of Life Date: January 1, 2016

Java 6 Support

Feature: Components in the GoodData platform that rely on Java will no longer work with Java 6. Oracle has stopped supporting and updating Java 6.Alternative: Upgrade to Java 7. Latest CloudConnect releases already include Java 7.Deprecation Date: ImmediateEnd of Life Date: July 2, 2015

GoodData SSO PGP Key Expiring

If you use GoodData single sign-on, be aware that the PGP key used for GoodData PGP-based SSO will expire on August 16, 2015. The key is used on your side to encrypt the information needed for PGP SSO login handshake.

To ensure that the single sign-on remains working properly, GoodData SSO administrators will need to rotate their PGP key before the expiration date.

GoodData Support has contacted all relevant customers about the steps needed to adjust their settings. Perform these steps to ensure that your PGP-based SSO keeps working after August 16, 2015.

Allowed Functions in ADS

Data Limits

Data limits have been introduced to reduce the amount of report result data loading to the GoodData client.These limits are dependent on the browser:

Browser

Chart Limit

Table Limit

< IE 10

375

2000

IE 10+

1125

5000

iOS

500

1000

Android

500

1000

Chrome (default)

1125

5000

Enabling this can lead to crashes of mobile devices. Contact support in case you need to disable the limit.

Updates to GoodData Help Coming Soon!

The GoodData documentation team is working on improving your experience using help.gooddata.com. In the coming weeks, we will roll out a more navigable version of GoodData Help with improved look-and-feel.

How will this affect you?

GoodData Help will remain at help.gooddata.com but links to individual articles will change. You will need to update any saved links or bookmarks.