Hi Team, I'm not able to create charts in reports using name attribute from Table "Option" and Cgwp 100 atrribute from table EnvData although both tables are connected with primary key as option_id from "option" table to "EnvData" table Can you please help me with this?

Hi Naveen, this is likely caused by the relationships in those tables and how they are connected in the LDM. There are some good tips in the following article to help with this here: https://university.gooddata.com/tutorials/data-modeling/

Hi Michael, I am following the documentation and simplified the modeling f but still not able to show attribute "name" from Option Table and the fact c_gwp_100 from EnvData Table IT is giving me same error

Hi Naveen, the error indicates that it cannot find the column

c_gwp_100_kgco2_per_tonne_of_product

in the physical table. So the problem seems to be the column either doesn’t exist in the source table. Or it’s not properly mapped in the Logical Data Model (LDM), or the dataset was not re-deployed after adding the column? Please double-check the actual schema in your data source (e.g, Redshift, Snowflake, BigQuery) and confirm that the column exists and has the correct name. In the Logical Data Model check “Cgwp 100” is present and mapped correctly, etc. Thank you!

👍