Unable to utilize DATE_TRUNC function on time dimensions

**Failed SQL**
SELECT CAST(date_add('day', CAST(1 - EXTRACT(DAY FROM CAST(\"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\" AS DATE)) AS INTEGER), CAST(\"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\" AS DATE)) AS TIMESTAMP) AS \"tmn:commercial_received_date:ok\"\nFROM \"public\".\"sales_marketing_sales_volume_test_lod\" \"sales_marketing_sales_volume_test_lod\"\nGROUP BY 1

**Logical Plan**
Rewrite Error: Can't detect Cube query and it may be not supported yet.

**Tool**
Tableau Generated Query via cube

**Version:**
E.g., v1.7.3.

**Additional context**
When i try to add a DATE_TRUNC on the dimensions which i defined as time in cube, it is not working for month quarter or year, where are it is working as expected for week
example for week
{"component":"host-runtime","message":"Tableau date trunc SQL rewritten","rewrite_count":1,"original_sql":"SELECT CAST((DATE_TRUNC( 'day', CAST(\"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\" AS DATE) ) + (-EXTRACT(DOW FROM \"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\") * INTERVAL '1 DAY')) AS DATE) AS \"twk:commercial_received_date:ok\"\nFROM \"public\".\"sales_marketing_sales_volume_test_lod\" \"sales_marketing_sales_volume_test_lod\"\nGROUP BY 1","rewritten_sql":"SELECT CAST((CAST(CAST(CAST(\"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\" AS DATE) AS DATE) AS TIMESTAMP) + (-EXTRACT(DOW FROM \"sales_marketing_sales_volume_test_lod\".\"commercial_received_date\") * INTERVAL '1 DAY')) AS DATE) AS \"twk:commercial_received_date:ok\"\nFROM \"public\".\"sales_marketing_sales_volume_test_lod\" \"sales_marketing_sales_volume_test_lod\"\nGROUP BY 1"}