Question

Hello,

First, I would like to say that you have an excellent product here. It's poised to make our lives much easier at my job. I do have a question: are there any plans in the near future to support more complex filters, such as nested "or" conditions? Especially cross-dimension?

Thanks in advance

Answer 1

just for the sake of documentation i'll answer it here as well:

Are you familiar with OLAP? It works set based, that means such a filtering isn't that easily possible

your filter would look like that in MDX:

SELECT ........
WHERE
Union(
    [Gender].[M] * [Customer].[All States]
,   [Gender].[All Gender] * [Customer].[Texas])

Which is a bit different than people are used to SQL etc. I have plans to support that at some point, but there are so many things i need to do first :/ Usually people would want to include only data for Male AND Texas, which is much easier to do than such an OR based join. (would be something like:

WHERE (Gender.M, Customer.Texas) )

You can file a feature request and keep track of it that way.

Support for Complex Filters

Follow this question

Related questions