Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
MDX Puzzle - 15 Mar 2000
The April MDX Puzzle challenges you to use the FoodMart database to write an MDX query that shows unit sales for male and female customers for drink products sold in California.
Russ Whitney
March 15, 2000
1 Min Read
In the FoodMart Sales cube, the Name level of the Customers dimension has a member property called Gender. How would you write an MDX query that shows unit sales for male and female customers for drink products sold in California? The trick is to do this without creating a virtual dimension on the Gender property.
About the Author
You May Also Like
