To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles9 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData13
AnalyticsDashboards and Reports161 Metrics and MAQL107
Data modeling & IntegrationData models35 Data sources69
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by Martin Burian

47 Replies

Newest first

Oldest first

itzzyaseenNew Participant

posted in Data sources

Failed to obtain JDBC Connection

Closing for inactivity.

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Closing for inactivity.

ZafarNew Participant

asked in Dashboards and Reports

Login page when sharing dashboard or using Embedded Dashboards

GoodData Platform, GoodData Cloud, GoodData.CN require you to be logged in to see dashboards including embedded dashboards. Seamless experience without login screen is possible to achieve via SSO (Single Sign-On). It would be probably possible to skip login for GoodData.CN by using the same user and skip the login completely, but I have no direct experience.

SimonNew Participant

"Show zeroes" optionReceived

Hello @Simon,It is possible to workaround it on the GoodData Platform by following syntax for the metrics you slice by date:SELECT IFNULL(XYZ,0)+0It will left join date dimension with the data and you will see the “0” in the reports.This workaround is available only on GoodData Platform.Martin

SimonNew Participant

"Show zeroes" optionReceived

Updated idea statusNew→Received

hpatskanNew Participant

Pass callback function into chart config to customize chart labels and datapointsReceived

Updated idea statusNew→Received

EthanNew Participant

asked in Administration

GoodData.CN Installation on M1 Mac

New update. There is an unofficial docker image (Development version) built for M1 - https://hub.docker.com/r/mouchar/gooddata-cn-ce-unofficial.

plaubeKnown Participant

asked in SDKs and APIs

API error - GDC::Exception::NotFound

Dear @plaube.I am afraid this thread went beyond what community around GoodData products can provide. It seems it is rather for an implementation package from GoodData.Best regards.Martin

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Hi @Yuriy Balakhonov, @Vasiliy Ostrovsky, @NickK.I would like to review if you were able to resolve the issue or it still exists. If the issue still exists could you please provide:pg_stat_activity physicalModel usage patternWe could also organize a call to check it online with you.Please let us know.Thank you.Martin

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Hello @Yuriy Balakhonov, @Vasiliy Ostrovsky, @NickK.Unfortunately we were not able to find the root cause of the issue based on the error message.We would need following information to be able to investigate further:pg_stat_activity physicalModel usage patternCould you please share the information?What we could also do to organize a call with our engineering to check the issue online. Please let us know.Thank you.Best regards,Martin

nuranNew Participant

asked in Solution architecture

Getting 401 when I embed gooddata within docker-compose

If the application works fine outside the docker container and there are some issues once it is deployed to docker, then the issue will be somewhere in the configuration of the deployment which impacts the application.Reason of the 401 is that the user is not authenticated. I recommend to check from where you get the 401. In case it is from GoodData, please check if the authentication itself fails or what is the request. This could help in investigation what is wrong and impacting the docker deployment.

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Hello @Yuriy Balakhonov @Vasiliy Ostrovsky @NickK.We have released a performance optimization in 1.4, which should resolve the issue with the 5s timeouts. If you still see the timeouts in 1.4, please provide the information requested in previous post by @David Kubecka .Thank you.Martin

Rafael CruzNew Participant

asked in Metrics and MAQL

Age of employees

Tks!! Welcome :-)

Rafael CruzNew Participant

asked in Metrics and MAQL

Age of employees

Hi @Rafael Cruz. Please see example.Data: Model: Metric (days):For result in daysMetric (months): For result in monthsMetric (years):For results in yearsReport (days): Report (months):Report (months with formatting): Format:{{{12||[>1]# years ;[=1]# year ;#}}}{{{|12|[>1]# months;[=1]# month;#}}} Report (years):

NickKKnown Participant

asked in Administration

Can I use my own domain name with GoodData.CN (evaluation)

Please see the description of the various versions/plans: https://www.gooddata.com/developers/cloud-native/#plans

NickKKnown Participant

asked in Administration

Can I use my own domain name with GoodData.CN (evaluation)

Hi @NickK.Changing of hostname is currently not supported in GoodData.CN Community Edition and it is unknown, if it will be ever supported. The purpose of the Community Edition is to try GoodData.CN on your workstation or for developers to develop on their workstation for production version.You can use any hostname of your choice in the GoodData.CN Free, Growth, Enterprise. They are versions for production use cases. These versions will be released soon. Please stay tuned for updates!API documentation is available here: https://www.gooddata.com/developers/cloud-native/doc/latest/api/api_reference_all/Best.Martin

sugyanNew Participant

asked in Administration

I am Getting the Issues GoodData.CN installation on Centos7 Instance

Hi @sugyan.The right steps are:1.docker pull gooddata/gooddata-cn-ceIt will pull the latest version.2.docker run --name some-gooddata -i -t -p 3000:3000 -p 5432:5432 gooddata/gooddata-cn-ceIt will need to interactively accept license and privacy policy. If you would like to accept it from command line you can do that by adding following parameter to the docker run command:-e LICENSE_AND_PRIVACY_POLICY_ACCEPTED=YESIt takes some time to start the container.The main thing is that this version of GoodData.CN the community edition is intended to run on your local workstation for evaluation and developing purposes. It is not designed to run in the cloud.Have you tried to run in on your local workstation? Based on the first screenshot you share, it seems you run it on VM on Google Cloud, it would not work there anyway, because we force access via localhost hostname.Could you please try to run it on your local workstation? If it won’t work please share what OS you have, what version of Docker

Konstantin KomissarchikNew Participant

asked in Dashboards and Reports

Funnel charts

GoodData provides SDK called GoodData.UI and you can connect to visualization library of your choice and use any even exotic visualizations. https://sdk.gooddata.com/gooddata-ui/

sugyanNew Participant

asked in Administration

I am Getting the Issues GoodData.CN installation on Centos7 Instance

Hi @sugyan.Thank you for your question and welcome to the GoodData community.Could you please provide exact steps of your actions and what you would like to achieve and on what environment?From the screenshot it seems that you try to run it on a VM in Google Cloud. If my assumption is correct, you would have issues to use it even if the error would not occur, because the GoodData CN Community Edition is designed to run on workstations for evaluation and development purposes.I recommend to install Docker to your workstation and run docker pull and docker run from there.Best.Martin

Rick FlaggNew Participant

asked in Data sources

Reviewing Data After CSV Import

Hi Rick.The whole input data goes through a validation against the model, so only input data in the expected format are loaded otherwise the data load fails. So there is no need to validate data after import of CSV. The preview is there just for the first time when you also create dataset for your model based on the CSV file. The preview allows you to choose right type of fields for the dataset based on data in the CSV. There you choose if the dataset field will be attribute or fact or something else based on the first couple of lines you see in the preview.There are couple of advanced situation for which a validation would be useful and it is e.g. check of referential integrity between dataset. We have a functionality for that. It can do multiple validation checks of the project. The functionality is described in the following article: https://help.gooddata.com/doc/free/en/workspace-and-user-administration/administrating-workspaces-and-workspace-objects/validate-a-workspaceBest regard

Rick FlaggNew Participant

asked in Data sources

Creating a New Data Field

Hi Rick.Please share you data model and description of what you would like to calculate. Then it will be possible to provide a better advice.Best,Martin

Elly BryanNew Participant

asked in Solution architecture

Working with time in workspace

Hello Elly.It is very good question. If you have timestamps in your source data, it is possible to use it in analytics, but usually it means some preparations in ETL.By timestamp I understand Date and Time or Epoch time. You cannot directly use it for slicing by hour > minute > second, you have to prepare the time dimension:Time dimensionIt will allow you to slice by the time, but think about if you need second granularity. If not you can just extract hour and add it directly into the fact dataset:See the “Call Start Hour”How to calculate the duration? You have 2 options, calculate it in your ETL and have duration as fact or you can add start time epoch and end time epoch as facts and then use just subtract start from end and you will get duration in seconds. Then you can calculate averages etc.Couple of examples of reports:Simple count by hour with filter to date and call type (incoming/outgoing)Call duration from start and end epochResult of the calculation is seconds, so how c

Simone HaasNew Participant

asked in Metrics and MAQL

Calculating how many days are invoices past due

Hello Simone. It is very good question. It is possible to calculate it from the “Due Date” using date arithmetic and “THIS” macro. To create such calculation you have to create custom Calculated Measure (also called MAQL Metric). To do it go to Manage/Metrics and click to “Create Metric” button. Let’s say you have “Invoices” dataset with list of invoices and each of them has a “Due Date”. To calculate how many days the invoices are past due the metric will look as follows: The “THIS” macro references the current value for the specified attribute of the Date dimension.“By Invoice Id” defines dimensionality of the calculation. “Invoice Id” is primary key of the “Invoices” dataset. Then I can use the Calculated Measure in the Analytic Designer (name of the Measure is “Days due”): The reference date is today which is 2021-01-18. So we have the calculation! What next? We can adjust format of the Calculated Measure to make it look better. It is possible to set the format when you open the M

alegarciNew Participant

asked in Data sources - KB articles

Extract metadata from a dbexecute component?

Output parameters of stored procedure or result set of query are sent to the first output port of the DBExecute component. You will need to fill Query output parameters and/or Result set output fields properties of the DBExecute component, based on what the stored procedure returns. Of course that you sill have to connect the DBExecute with a Write component via a Metadata. Complete documentation of the DBExecute component is available here: https://help.gooddata.com/cloudconnect/manual/dbexecute.html. But I do not recommend to use CloudConnect for a new development, it is a legacy tool which will be discontinued. I recommend use the GoodData data pipeline as described in Data Preparation and Distribution.

Keith FinnNew Participant

asked in Administration

Working with gray pages

We have made it easier for you by using our Chrome Extension - gooddata extension tool for chrome for easier navigation between the most useful pages.

1
2

Page 1 / 2

Powered by Gainsight

Welcome to the GoodData Community!Cookie settings

Sign up

Already have an account? Login

Social Login

or

Username (also your display name - please use John Doe rather than john.doe) *

E-mail address (if you already use GoodData, we encourage you to use the same e-mail address you use for the GoodData platform) *

Full Name

(Private)

Only you and moderators can see this information

*

Company

(Private)

Only you and moderators can see this information

*

I use the following GoodData products

(Private)

Only you and moderators can see this information

GoodData Platform GoodData Cloud GoodData.CN

Password *

I have read and agree to the GoodData Community and University Terms of Use and Privacy Policy.

loginBox.register.email_repeat

Login to the community

Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK