GoodData Cloud - December 15, 2022

New Features Support for More Databases (Beta) New ShowEmbeddButton Parameter for Iframes New Attributes for User and UseGroup Entities Future Features Custom Tooltips for Visualizations New FeaturesSupport for More Databases (Beta)You can now create a data source out of the following databases: Microsoft SQL Azure SQL Synapse SQL Please note that support for connecting to these databases is in its beta stage. We do not recommend using these data sources in a production environment yet.Learn More:Create an Azure SQL Data SourceCreate a Microsoft SQL Server Data SourceCreate a Synapse SQL Data SourceNew ShowEmbeddButton Parameter for IframesYou can now hide the Embed button option from your embedded dashboards by adding the ?showEmbedButton=false parameter to the URL.Learn more:
Embed Visualizations Using IframesNew Attributes for User and UseGroup EntitiesUser entities can now be assigned firstName, lastName and email attributes to provide them with a more human-readable information. Similarly, UserGroup entities can now be assigned a name attribute.Learn more:
User and UserGroup Entity InterfaceFuture FeaturesCustom Tooltips for VisualizationsIn an upcoming release, we will introduce the possibility for all users with Edit permissions to add explanatory tooltips to visualizations through the user interface.Tooltips will give you an opportunity to provide users with context for the visualizations, metrics used, or help you with fast orientation in the list of visualizations. You can display the tooltips on dashboards as well, or decide to edit or hide them.Tooltips will be enabled for all users in an upcoming release. If you want to postpone this feature for your organization, please, contact your Customer Success Manager.

Related products:GoodData Cloud

GoodData.CN 2.2.0

Released November 16th, 2022.New Features Export Dashboards and Visualizations into CSV and XLSX files Dedicated Data Sources Tab in the UI Support for Google BigQuery Impact Analysis Custom Layouts in Logical Data Models Support for CSP Configuration White Label Your Organization Changing Widget Background Color Change Display Language New MAQL Date Arithmetic Functions Snapshot Filtering in MAQL GoodData.UI 8.11 Version Available Web Components Library for GoodData.UI Updates & Changes Bug Fixes Get the Community Edition Upgrade Guides Upgrade GoodData.CN Community Edition to 2.2 Upgrade GoodData.CN to 2.2 New FeaturesExport Dashboards and Visualizations into CSV and XLSX filesDashboards and Analytical Designer now enable you to export individual visualizations to CSV and XLSX files.Exported XLSX files are formatted with merged or unmerged cells.Note: The export controller requires an S3 bucket setup. For details see Export Controller AWS Secret. Learn more:Export VisualizationsExport DashboardsDedicated Data Sources Tab in the UIWe are introducing a dedicated view for managing Data Sources connected to your organization. The view is accessible from the home page where you can now easily create, edit and delete data sources.The Data Source dialog continues to be available also from the LDM modeler, giving your users option to also make the changes without having to leave the active workspace. Support for Google BigQueryYou can now connect to a Google BigQuery data warehouse and create a Google BigQuery data source.Learn more:Connect to Google BigQueryImpact AnalysisUse the new Model changes tab to keep track of the changes you make to the logical data model and detect any visualizations, dashboards and metrics that may be end up being broken, before you actually break them. You can also now undo changes you have made to individual datasets.Learn more:Monitor Model ChangesCustom Layouts in Logical Data ModelsApart form the default view of logical data models with dimension datasets on the left and fact datasets on right, you can now update the layout of your logical data model to suit your needs.Drag the datasets to where you need them and save the model. The layout is saved with the model. Learn more:Create a Logical Data Model Manually In the LDM ModelerSupport for CSP ConfigurationControl hostname restrictions for your GoodData deployment with Content Security Policy (CSP). Your organization's CSP directives can be configured directly in the web UI under Developer settings on the home page, or by using the API endpoint /entities/cspDirectives. Learn more:Enable CSP for an OrganizationWhite Label Your OrganizationWith this release, we are expanding the possibility to adjust the look of GoodData Cloud to suit your needs.Especially useful when embedding dashboards and visualizations, you can now hide the links to GoodData with a single click in the Appearance section.You can also use API to upload new icons, such as the product icon, favicon, and Apple Touch icon.Note: This is a beta release. The full availability of this feature will be delivered in an upcoming release.Learn more:
White-Label Your OrganizationChanging Widget Background ColorWe have extended the possibility of customizing the appearance of Dashboards. You can now change the background color of individual widgets on your Dashboards. Learn more:Create Custom ThemesTheme PropertiesChange Display LanguageYou can now change the display language of Dashboards and Analytical Designer from the default English (US) to any of the following languages: Chinese, Dutch, French, German, Japanese, Portuguese (Brazil or Portugal), Russian, Spanish.The change is available via API for the whole organization, individual workspaces, or individual users.Learn more:Change Display LanguageNew MAQL Date Arithmetic FunctionsIn this release, we are introducing new time arithmetic functions - DATETIME_DIFF and DATETIME_ADD: DATETIME_DIFF calculates the difference between two timestamps or dates. You can use this function, for example, to calculate the duration of your business processes. DATETIME_ADD adds a specified number of intervals of timestamps or dates. You can use this function, for example, together with the MIN/MAX date function to derive borders of date filters from the last snapshot. Learn more:DATETIME_DIFFDATETIME_ADDSnapshot Filtering in MAQLWe have introduced new possibilities how to work with data in periodic snapshot fact tables - for instance, a daily snapshot of financial metrics or inventory numbers.You can now use the following MAQL functions: The FIRST_VALUE and LAST_VALUE functions return the first/last values of an ordered sequence. The MIN and MAX functions can be used with dates in filter conditions. Learn more:FIRST_VALUELAST_VALUEMINMAXGoodData.UI 8.11 Version AvailableWe have released Version 8.11 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.What's new in GoodData.UI Version 8.11 Improved custom attribute filters We added support for customization of the AttributeFilter and AttributeFilterButton components and new features, such as static and hidden elements. Dashboard plugins to customize attribute filters You can now customize the attribute filters with dashboard plugins. Added core API for attribute filter components
 These components now allow the implementation of custom attribute filters. Added SDK SPI ability for white-labeling 
You can enable white-labeling for your organization. Added the Mapbox token React provider Additional fixes and improvements Web Components Library for GoodData.UIWe are introducing a new Web Components library.This new library enables you to embed visualizations and dashboards into your application without the need to use React.js. It can also serve as a save and fast alternative to embedding dashboards with iFrame.Learn more:Introduction to GoodData Web ComponentsUpdates & Changes The scope of users who can use the API endpoint /api/v1/layout/workspaces/{workspaceId}/permissions has been changed. The only users who can use this API endpoint are users who have MANAGE permission in the organization or MANAGE hierarchyPermission in the workspace itself, or its parent workspace. Updated Apache Drill driver to version 1.20.2. Updated Vertica driver to version 11.1.1. Bug Fixes We have removed a redundant authentication callback after successful authentication. You will now get the correct error code, 401 (Unauthorized), when you make a declarative/entities API call and your authentication token is expired. Making a layout/workspaces PUT API call will no longer rewrite workspace data filters & settings. Fixed an issue where when GoodData.CN Community Edition runs out of memory, the Docker service fails to restart for up to hours, causing the application to be unusable for no obvious reason. Now the Docker service will restart itself right away to resolve the issue. You are now be able to make preflight requests to the GoodData.CN Community Edition API with the Access-Control-Request-Headers: Authorization and Access-Control-Request-Headers: PATCH headers. Get the Community EditionPull the GoodData.CN Community Edition to get started with the latest release:docker pull gooddata/gooddata-cn-ce:2.2.0Upgrade GuidesUpgrade GoodData.CN Community Edition to 2.2Suppose you are using a docker volume to store metadata from your GoodData.CN CE container. Download a new version of the GoodData.CN CE docker image and start it with your volume. All your metadata is migrated automatically.Upgrade GoodData.CN to 2.2To upgrade Helm chart, follow the general upgrade guide.

Related products:GoodData.CN

GoodData Cloud - November 16, 2022

New Features Web Components Library for GoodData.UI New MAQL Date Arithmetic Functions Dedicated Data Sources Tab in the UI Custom Layouts in Logical Data Models UI Support for CSP Configuration Added Support for Greenplum Changing Widget Background Color Bug FixesNew FeaturesWeb Components Library for GoodData.UIWe are introducing a new Web Components library.This new library enables you to embed visualizations and dashboards into your application without the need to use React.js. It can also serve as a save and fast alternative to embedding dashboards with iFrame.Learn more:Introduction to GoodData Web ComponentsNew MAQL Date Arithmetic FunctionsIn this release, we are introducing new time arithmetic functions - DATETIME_DIFF and DATETIME_ADD: DATETIME_DIFF calculates the difference between two timestamps or dates. You can use this function, for example, to calculate the duration of your business processes. DATETIME_ADD adds a specified number of intervals of timestamps or dates. You can use this function, for example, together with the MIN/MAX date function to derive borders of date filters from the last snapshot. Learn more:DATETIME_DIFFDATETIME_ADDDedicated Data Sources Tab in the UIWe are introducing a dedicated view for managing Data Sources connected to your organization. The view is accessible from the home page where you can now easily create, edit and delete data sources.The Data Source dialog continues to be available also from the LDM modeler, giving your users option to also make the changes without having to leave the active workspace.Custom Layouts in Logical Data ModelsApart form the default view of logical data models with dimension datasets on the left and fact datasets on right, you can now update the layout of your logical data model to suit your needs.Drag the datasets to where you need them and save the model. The layout is saved with the model. Learn more:Create a Logical Data Model Manually In the LDM ModelerUI Support for CSP ConfigurationConveniently manage your organization’s content security policy (CSP) configuration directly in the web UI. You can find CSP settings under Developer settings. Learn more:Enable CSP for an OrganizationAdded Support for GreenplumYou can now connect to a Greenplum database and create a Greenplum data source. Learn more:Connect to GreenplumChanging Widget Background ColorWe have extended the possibility of customizing the appearance of Dashboards. You can now change the background color of individual widgets on your Dashboards. Learn more:Create Custom ThemesTheme PropertiesBug Fixes Fixed an issue where when GoodData.CN Community Edition runs out of memory, the Docker service fails to restart for up to hours, causing the application to be unusable for no obvious reason. Now the Docker service will restart itself right away to resolve the issue.

Related products:GoodData Cloud

GoodData Cloud - October 20, 2022

New features Export to CSV Files White-Label Your Organization Change Display Language GoodData.UI 8.11 Version Available Invitations Undo Changes in the Logical Data Model Bug FixesNew features Export to CSV FilesDashboards and Analytical Designer now enable you to export individual visualizations to CSV files. You can then, for example, process the raw data in more detail in another application.Learn more:Export VisualizationsExport Dashboards White-Label Your OrganizationWhen embedding your visualizations and dashboards, you can take advantage of the new white-labeling options in GoodData Cloud.You can: Hide links to the GoodData documentation (via the user interface or API). Upload your logo to use in GoodData Cloud and as a favicon and Apple Touch icon (via API). Learn more:White-Label Your Organization Change Display LanguageGoodData Cloud now enables you to change the display language of Dashboards and Analytical Designer from the default English (US) to any of the following languages: Chinese, Dutch, French, German, Japanese, Portuguese (Brazil or Portugal), Russian, Spanish.The change is available via API for the whole organization, individual workspaces, or individual users.Learn more:Change Display Language GoodData.UI 8.11 Version AvailableWe have released Version 8.11 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.What's new in GoodData.UI Version 8.11 Improved custom attribute filters We added support for customization of the AttributeFilter and AttributeFilterButton components and new features, such as static and hidden elements. Dashboard plugins to customize attribute filters You can now customize the attribute filters with dashboard plugins. Added core API for attribute filter components These components now allow the implementation of custom attribute filters. Added SDK SPI ability for white-labeling You can enable white-labeling for your organization. Added the Mapbox token React provider Additional fixes and improvements  InvitationsAs a GoodData Cloud Trial user you can now invite other people as new users to collaborate with. Use the Invite button located in the top right corner of the UI.This feature is also available via the API endpoint actions/invite.Learn more:Invitations Undo Changes in the Logical Data ModelIn the Model changes tab you can now undo changes you have made to individual datasets in your logical data model.Learn more:Monitor Model Changes Bug Fixes We have removed a redundant authentication callback after successful authentication. You will now get the correct error code, 401 (Unauthorized), when you make a declarative/entities API call and your authentication token is expired. Making a layout/workspaces PUT API call will no longer rewrite workspace data filters & settings.

Related products:GoodData Cloud

GoodData.CN 2.1.0

Released September 8th, 2022.New FeaturesCustomizable AppearanceYou can now customize the color schemes of your GoodData.CN deployment using the newly added Appearance settings. You can create custom themes for your dashboard and analytical designer, as well as color palettes for your visualization.The color schemes are applied to the organization as a whole by default, but you can use different themes for different workspaces via API.Please note that this feature is currently not available in GoodData.CN Community Edition.Learn more:Customize AppearanceSupport for Filtering of Empty Attribute ValuesIn GoodData.CN, attribute filters now support the empty (NULL) values.You can now include or exclude these empty values from your filters in MAQL definitions or directly in Analytical Designer or Dashboards.Learn more:Filter Visualizations by Attributes and DatesRelational OperatorsSupport for Time ZonesYou can now configure time zones for your whole organization, or individual workspaces or users via API.If not specifically configured, users inherit time zone settings from their workspace; workspaces inherit the time zone settings from their parent workspace or organization.With correct time zones, your users can always see relevant data when they filter to, for example, Today or Last hour.Notes:If you use the TIMESTAMPTZ data type and you are a current GoodData.CN user, scan your data sources again to detect the columns with the time zone information. We recommend configuring the time zone for the organization or workspace, so that you always see relevant data (the default is UTC)Learn more:Manage Time ZonesOrder of Items in Stacked ChartsTo improve the readability of charts with stacked items, we have reversed the order of the items displayed.In bar charts, column charts, and stacked area charts, the order of the items now corresponds with the left-to-right order in the legend.New Entitlements APIWe have expanded the previously introduced API endpoint /actions/resolveEntitlements.Organization administrators can now get information about the current number of used workspaces and users from in license.We have also introduced a new API endpoint /actions/collectUsage that displays how many workspaces and users currently exist in your organization. Learn more:View EntitlementsView UsageNew API Filter EntityYou can now filter workspace entities using the origin=ALL|PARENTS|NATIVE filter to get only the workspace itself, or only its parent workspaces, or both. Learn more:OriginConfigurable CSP For OrganizationsControl hostname restrictions for your GoodData deployment with Content Security Policy (CSP). Your organization's CSP directives can be configured using the new API endpoint /entities/cspDirectives.Learn more:Enable CSP for an OrganizationEnd of Beta For Permissions After months of testing we now consider permissions to be a fully tested feature and no longer in beta. Our thanks goes to all the early adopters.Learn more:Manage PermissionsFixes and UpdatesYou can now set a custom Timeout duration when connecting to Google BigQuery, allowing you to increase the duration past the 10 second default. We fixed an issue where queries that return large amounts of data, on the order of millions of rows, would fail due to cache memory issues. GoodData.CN now uses Redshift driver version 2.1.0.9 and Snowflake driver version 3.13.21. GoodData.CN now uses Apache Pulsar 2.9.3. Please note that this will require you to update customized-values-pulsar.yaml when upgrading to GoodData.CN 2.1, for more information, see Upgrade GoodData.CN to 2.1 below.Get the Community EditionPull the GoodData.CN Community Edition to get started with the latest release:docker pull gooddata/gooddata-cn-ce:2.1.0Upgrade GuidesUpgrade GoodData.CN Community Edition to 2.1Suppose you are using a docker volume to store metadata from your GoodData.CN CE container. Download a new version of the GoodData.CN CE docker image and start it with your volume. All your metadata is migrated automatically.Upgrade GoodData.CN to 2.1Preload updated Custom Resource Definition (CRD) for Organization resources. Due to the helm command limitation, it is impossible to update CRD automatically by Helm. Therefore it is necessary to update this CRD manually by following this procedure: Download and extract gooddata-cn helm chart to an empty directory on local disk. helm pull gooddata/gooddata-cn --version 2.1.0 --untar Update modified CRD in the cluster where the older GoodData.CN release is deployed: kubectl apply -f gooddata-cn/crds/organization-crd.yaml You can clean local extracted helm chart rm-r gooddata-cn The new version of Apache Pulsar in GoodData.CN 2.1 requires you update the customized-values-pulsar.yaml. The following two lines need to be added to the Pulsar broker configuration: systemTopicEnabled: "true" topicLevelPoliciesEnabled: "true" Note that you may need to restart the broker pod after making this change, or just uncomment the restartPodsOnConfigMapChange: true line. See Use Customized values.yaml for Pulsar that contains the updated version of customized-values-pulsar.yaml with these changes already integrated. If you are using embedded PostgreSQL database, refer to the following Upgrade Postgresql-ha Helm Chart section for instructions on how to upgrade it. Perform a rescan of your data source with replace mode, to create an up-to-date version of the physical data model and to avoid any unwanted errors when regenerating the logical data model.Upgrade Postgresql-ha Helm ChartIf you’re using external PostgreSQL database (when you deployed gooddata-cn helm chart with option deployPostgresHA: false), you can skip this step because it is not relevant for your deployment.If you’re using embedded PostgreSQL database (with deployPostgresHA: true set in values.yaml), you will need to perform the following process to upgrade postgresql-ha helm chart from version 8.6.13 to 9.1.5:Follow the steps in this article to upgrade your helm chart for GoodData.CN 2.1.0.

Related products:GoodData.CN

GoodData Platform - August 11, 2022

GoodData.UI Version 8.10 Available User Group Dashboard Permissions Propagate with the LCM Bricks New Default Behavior for Synchronizing User Groups New Default Behavior for Responsive and Pixel Perfect Shared Dashboards Users can now be Removed from User Groups GoodData.UI Version 8.10 AvailableWe have released Version 8.10 of GoodData.UI, our powerful library for building analytical applications powered by GoodData.What's new in GoodData.UI Version 8.10Support for Gooddata Cloud GoodData Cloud is now fully supported by GoodData.UI from version 8.10 Dashboard selectors are public now The filterContext, user, and permission selectors are now public. Execution definition by slices/series can be used without React You can use the @alpha version of DataViewLoader from @gooddata/sdk-ui Additional fixes and improvementsUser Group Dashboard Permissions Propagate with the LCM BricksThe release brick, provisioning brick, and the rollout brick now support User Group Dashboard Permissions. They have been expanded with additional parameters and new default behaviors.New Default Behavior for Synchronizing User GroupsThe provisioning and rollout brick now synchronize user groups from master workspaces to client workspaces. Only the user groups are synchronized. The members of the user group are not included. The release brick already had this support.New Default Behavior for Responsive and Pixel Perfect Shared DashboardsIn a segment's master workspace, dashboards can be private or shared with all or some users/user groups.At release, rollout, and provisioning, sharing permissions are now propagated in the following way:Dashboards set as private in the master workspace remain private in the client workspaces. Dashboards shared with all users in the master workspace become dashboards shared with all users in the client workspaces. Dashboards shared with some users/user groups in the master workspace become dashboards shared with some user groups in the client workspaces.The same logic applies for development workspaces and master workspaces.To disable the propagation of the user group permissions for shared dashboards, specify the following new parameters in the release, provision, and rollot bricks according to your dashboard type:disable_kd_dashboard_permission true if your dashboards are built in the Responsive disable_pp_dashboard_permission trueif your dashboards are built in the Pixel-perfect UI.Users can now be Removed from User GroupsUsers can now be removed from user groups through the Users Brick. To remove a user from a user group, the user_group input must be blank or null for a user.Learn More:Use Groups to Share Dashboards with Multiple UsersShare DashboardsRelease BrickProvisioning BrickRollout BrickUsers Brick

Related products:GoodData Platform