O'Reilly logo

Business Intelligence with MicroStrategy Cookbook by Davide Moraschi

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

Restricting rows – compare an attribute to another attribute

Most of the time, we filter attributes based on values, be it an element or a list of elements, always belonging to the same attribute (Year = 2007; Product in list….). There are cases when we want to look at two separate attributes to see if they match or not. The classic example being the order date and the ship date (order date = ship date), to control if our warehouse is preparing the orders during the same day they are processed. That example is way too common, so we'll complicate the things a bit. Our Sales Manager wants to know which orders from the resellers were originated by employees outside the sales territory where they belong (???). In other words, who are those employees ...

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