Implementing the logical OR on members from different hierarchies
If we need to slice the data by only the black color for products, we would put the Black member in the WHERE clause, like this:
WHERE ( [Product].[Color].&[Black] )
In the Adventure Works DW 2016 database, by putting Reseller Order Quantity and Reseller Order Count on the columns, we would get this result:
Similarly, to get only the products whose size is XL, we can put the member XL in the slicer as:
WHERE ( [Product].[Size Range].&[XL] )
What if we want to get the products whose size is XL in the same result set as the result set for black only?
Somehow, we need to combine the black ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
