If the data preview can see the data, why can't the chart preview get the data?
F
Fathia Jama
started a topic
over 2 years ago
I have a couple of dashboard charts, both on the same table. Both of the queries behind them will produce data no problem in the Query Data Preview. In the chart preview, with charts are set up the same as other entities that DO work, both the charts for this entity I get a popup that says "Unable to retrieve data from the server"...I also get "Unable to display the chart. Some validation have failed" on the preview window. So if the data preview can see the data, why can't the chart preview get the data? (since I have almost identical queries and charts that work with other entities...the only difference is that the tables are different).
Best Answer
F
Fathia Jama
said
over 2 years ago
When queries are run for charts they are embedded into another query like this :
select x, y from (select x,y) group by <your_chart_categories_and_series>
This means that if your query contains a semicolumn ";" in the end, it won't make your chart appear, but will make you Query Data Preview appear.
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
When queries are run for charts they are embedded into another query like this :
select x, y from (select x,y) group by <your_chart_categories_and_series>
This means that if your query contains a semicolumn ";" in the end, it won't make your chart appear, but will make you Query Data Preview appear.
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.
Fathia Jama
I have a couple of dashboard charts, both on the same table. Both of the queries behind them will produce data no problem in the Query Data Preview. In the chart preview, with charts are set up the same as other entities that DO work, both the charts for this entity I get a popup that says "Unable to retrieve data from the server"...I also get "Unable to display the chart. Some validation have failed" on the preview window. So if the data preview can see the data, why can't the chart preview get the data? (since I have almost identical queries and charts that work with other entities...the only difference is that the tables are different).
When queries are run for charts they are embedded into another query like this :
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.Fathia Jama
When queries are run for charts they are embedded into another query like this :
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.-
4 levels treemap in Dashboard Builder
-
How to setup multiple roles for a Dashboard?
-
Can Snowflake Be Used a Data Source for Semarchy Dashboards?
-
Is it possible to make a master-detail relation between two charts ?
-
Dashboards disappeared during migration of Semarchy database to RDS
-
The Data Location Variable (V_DATALOCATION) Doesn't Appear to Work in Dashboard
-
Set a default width for columns in pivot tables in the dashboards
-
Migrating a Dashboard to Production
-
xDM - Dashboard Advice
See all 16 topics