April 2002 MDX Puzzle

Extend the example in this month's article to populate an ALL OTHER BRAND member that's a sibling to each group of brands in the Product dimension. This month's column shows how to sum all the suppressed values into one ALL OTHER BRAND level by adding a single record in the Product dimension table and creating a calculated measure to determine the record's value. A more useful analysis would sum ALL OTHER BRAND at each brand grouping within the product hierarchy. In other words, instead of having just one ALL OTHER BRAND for the entire product dimension, you'd have an ALL OTHER BRAND for each product subcategory. If an ALL OTHER BRAND record were added to each product subcategory in the Product dimension table, what would the MDX for the Suppressed Unit Sales calculated measure look like?

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