Skip navigation

October 2002 MDX Puzzle

Here’s a tricky puzzle that has a useful solution. Use the Foodmart 2000 Sales cube to display the quarterly Unit Sales in 1997 for every customer who has the last name Netz. No fair visually inspecting all 10,240 customers and listing them individually. I’ll give you two hints. First, I introduced the technique of string searching in a past column. Second, the answer includes five names.

TAGS: SQL
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