MDX Puzzle - 01 Jul 1999

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]

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish