negative cuts

[jbothma]

It'd be nice to be able to exclude specific values in cuts (blacklist).

for example, there's a special programme in out budget data that should generally be excluded from aggregates. To dynamically exclude it and include all other possible names, I'd need to do a members query, then remove the blacklisted item from the list, then cut with the remaining values as a whitelist.

Cubes does this with invert=True in their Python interface https://pythonhosted.org/cubes/reference/browser.html#slicing-and-dicing and looks like the do it with `!dimension:value in their HTTP interface https://github.com/DataBrewery/cubes/blob/master/cubes/query/cells.py#L796

I suggest something like cut=financial_year.year:2018|!programme.name:"Direct Charges against the National Revenue Fund" would return everything for 2018 excluding Direct Charges.

[jbothma]

Another workaround is to disaggregate by the relevant dimension filter and aggregate on the client-side.