Another problem: I have added a measure based filter to display rows that have Email Volume >0, but the filter is not working. If i remove a column called as “Subject” then it works. The measure was created using attribute from the same table as Subject. There’s just one more table which is involved here, but there’s a primary key relation between the two tables.

Hi Rishi, the issue here is caused by the 2 products having different default limits. For GoodData Cloud, Maximum dimension size of a query result = 100,000: https://support.gooddata.com/hc/en-us/articles/9703853324179-GoodData-Cloud-Limits While GoodData C.N Default is set to: 10,000: The

platform_limits.max_dimension_size

property sets the limit for dimensions that are NOT using the

measureGroup

property. The following endpoint is affected by this limit:

/api/v1/actions/workspaces/{workspaceId}/execution/afm/execute

Helm Chart::

platform_limits.max_dimension_size

Default is set to: 10,000 You can increase the default limit in GoodData C.N - Please see the following documentation for more details: https://www.gooddata.com/docs/cloud-native/3.0/deploy-and-install/cloud-native/helm-chart-options/ https://www.gooddata.com/docs/cloud-native/3.8/deploy-and-install/cloud-native/execution-limits/

We increased the limit and the error is no longer there, but the filter still doesn’t work

Hi Rishi, my apologies for the delay in getting back to you. So if I understand correctly, you’re trying filter rows where

Email Volume > 0

. This filter works unless you add a column called “Subject”. When “Subject” is included in the visualization, the filter fails, and rows with

Email Volume = 0

are incorrectly shown. My initial thinking that this may relate to a granularity mismatch, and when adding “Subject” may introduce more rows or change the granularity, affecting how the

Email Volume

filter is applied. Or The filter might not apply properly once “Subject” is added, possibly due to changes in how data is grouped in the visualization. Your metric is currently: SELECT IFNULL(SUM(Sent),0) + 0 - but adding +`0` to the result doesn’t change the value, so this operation is redundant. So I think this can be removed. Perhaps this is causing the issue. If this isn’t the case, I would like to suggest that you add the filter directly in the measure itself, to display rows where

Email Volume > 0

Removing 0 worked. However, do note that it worked correctly on the Cloud version and the measure itself was created based on suggestion on one of the forum. Still thank you very much

Thanks for this feedback - And I am happy to hear that this worked 🙂