Home Forums Data Warehousing Analysis Services Apply a label to the all member when querying allmembers from a hierarchy RE: Apply a label to the all member when querying allmembers from a hierarchy

  • June 17, 2016 at 7:56 am

    #1885617

    leehbi (6/17/2016)

    It was not an Excel thing - saw the same results with SSMS. I'm pretty sure it's related to the fact that ALL isn't a member name in strictest of sense.

    You can see this issue for yourself with Adventure Works.

    I've run this query against both the multimensional and tabular versions of the adventureworks samples and cannot reproduce the issue (the defined All Member name shows up each time). Strange.

    I'm on LinkedIn