# Data dimension not working on tableau
**URL:** https://community.dremio.com/t/data-dimension-not-working-on-tableau/1112
**Category:** Uncategorized
**Created:** [May 10, 2018, 8:48pm UTC](https://community.dremio.com/t/data-dimension-not-working-on-tableau/1112 "2018-05-10T20:48:40Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Deepak\_Gattala](https://community.dremio.com/u/Deepak_Gattala)
#### Post date: [May 10, 2018, 8:48pm UTC](https://community.dremio.com/t/data-dimension-not-working-on-tableau/1112/1 "2018-05-10T20:48:40Z")
when i drag date on row/columns tableau it throws error saying error communicating with data source.
SELECT CAST({fn TRUNCATE(EXTRACT(YEAR FROM “HCI\_Terminated\_Employees”.“AS\_OF\_DATE”),0)} AS INTEGER) AS “yr\_AS\_OF\_DATE\_ok”
FROM “Demo”.“HCI\_Terminated\_Employees” “HCI\_Terminated\_Employees”
GROUP BY CAST({fn TRUNCATE(EXTRACT(YEAR FROM “HCI\_Terminated\_Employees”.“AS\_OF\_DATE”),0)} AS INTEGER)
---
### Author:  [@kelly](https://community.dremio.com/u/kelly)
#### Post date: [May 11, 2018, 3:13am UTC](https://community.dremio.com/t/data-dimension-not-working-on-tableau/1112/2 "2018-05-11T03:13:17Z")
Hi, could you uploaded a query profile?
> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.
---
### Author:  [@Deepak\_Gattala](https://community.dremio.com/u/Deepak_Gattala)
#### Post date: [May 11, 2018, 3:30am UTC](https://community.dremio.com/t/data-dimension-not-working-on-tableau/1112/3 "2018-05-11T03:30:42Z")
dont worry about that i got that resolved its not problem with the product it was more how we defined the datatype.