Implementing the logical OR on members from different hierarchies
If we need to slice the data by only black color for products, we would put the Black member in the where clause, such as this:
WHERE ( [Product].[Color].&[Black] )
In the Adventure Works DW 2012 database, putting Reseller Order Quantity and Count on the columns, we would get this result:
|
Reseller Order Quantity |
Reseller Order Count | |
|---|---|---|
|
All Products |
72,013 |
2,970 |
|
Cranksets |
1,107 |
261 |
|
Gloves |
11,553 |
991 |
|
Helmets |
4,447 |
922 |
|
Mountain Bikes |
12,771 |
1,119 |
|
Mountain Frames |
5,604 |
736 |
|
Road Bikes |
14,304 |
1,237 |
|
Road Frames |
3,456 |
769 |
|
Shorts |
8,946 |
758 |
|
Tights |
4,562 |
470 |
|
Wheels |
5,263 |
716 |
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 member with the XL member. Simply by putting...
