O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing logical OR on members from different hierarchies

The nature of a multidimensional database and its underlying structures has a direct consequence on how we should write combinations of members. Some combinations are there by design, others require a bit of imagination.

For example, a set of two members of the same hierarchy (colors black and white) placed in a slicer automatically applies OR logic on the result. This means that the result will have data where the first, the second or both of the members (or at least one of their descendants to be precise) occurred in the underlying fact table. In other words, where the product sold was either black or white. The emphasis is on two things: the set and the OR word. In other words, OR ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required