Tag: MDX

  • SQL Server BI Quiz – 2011- Display "Breadcrumbs" for members of a user hierarchy

    Recently, I’ve been provided with a generous offer to participate in the SQL Server BI Quiz – 2011 hosted on beyondrelational.com. The task was to fill in the MDX expression for a calculated measure ‘Parent Breadcrumbs’ that should display a string consisting of all parent names separated by a ‘ –> ’ for a user hierarchy. So for example for product member “Fender Set – Mountain” (user hierarchy [Product].[Product Categories]) the measure value should be the following string “All Products -> Accessories -> Bottles and Cages”. In this blog post I’ll provide the comments on the proposed solution as well as my own solution to the puzzle. These MDX functions were used in the solution: Generate, Hierarchize and Ascendants.