How do you create an MDX query that filters the result, based on attribute of dimension members other than a measure? For example, let's assume the products in the Foodmart Sales cube have an attribute called color. How do you ask for the top 10 yellow products based on Store Sales? Here's a hint: You'll want to use member properties. Microsoft added support for member properties late in the OLAP Services beta cycle, so many people don't know much about them. We'll explain them in an upcoming issue. Until then, if you have ideas or questions for future columns, please send us an email. You can reach us at [email protected].
0 comments
Hide comments