Apply dimension filter to dimension filter list to reduce list length

[fpieront]

I have ~ 150,000 rows distinct on dimension1 in my fact table (total ~ 1 million rows).

I can apply a filter on dimension2, drill down on dimension1 and reduce the result set to ~ 1,500 rows. This works for the results table, so I don't have to increase the row limit. (Dimension2 is hierarchiecally above dimension1).

But this doesn't work for the dimension filter: selecting the filter for dimension1 ALWAYS returns me the full list of records for dimension1 (~150,000), not applying other filters I have set (which would reduce the list of dimension1 values to ~ 1,500). Thus exceeding the row limit of 10k, and many values of dimension1 don't show up in the filter list.

I hope my description was understandable. Can this issue somehow be solved without increasing the row limit of the Cubes server?

[jjmontesl]

Perfectly understandable. Thanks for the feedback.

I have just checked and the $dimension/members method of Cubes accepts a cut filter. How awesome! I want this.

[jjmontesl]

Please test feature with latest version.

[jjmontesl]

Hello! That close/reopen.... any update?

[jjmontesl]

Note, seems to show repeated elements if there are more than one element filtered on a second dimension.

This seems to be caused by upstream: https://github.com/DataBrewery/cubes/issues/362 .

[fpieront]

Yes, I have noticed this as well if a drilldown is applied which splits up the individual filter elements. The filter elements will be repeated in the list.

Otherwise works as expected.

[jjmontesl]

Ok, great to confirm that. I'll keep this open for a while until I know about a possible resolution upstream (I could artificially remove duplicates in CV but I'd rather avoid hacking that). I might eventually close this before resolution, though.

Thanks for your valuable contributions.

[jjmontesl]

This has been fixed on Cubes master (https://github.com/DataBrewery/cubes/issues/362), so I'm closing this.