• subscribe
June 01, 2001 12:00 AM

June MDX Puzzle

SQL Server Pro
InstantDoc ID #20989

The June puzzle doesn’t relate to calculated cells but is a common problem for companies that gather retail market data. These organizations need to show the leaders, typically for brands, and to show that information relative to the rest of the brands. If you can solve this puzzle, you can access such information. Using the FoodMart 2000 Sales cube, show the top products (at the product department level) that make up 80 percent of unit sales, then group the rest of the products in one sibling member labeled Other.



ARTICLE TOOLS

Comments
  • seethapathi
    6 years ago
    Aug 24, 2006

    nothing

You must log on before posting a comment.

Are you a new visitor? Register Here