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 ...