none
Named Set Exclude does not work RRS feed

  • Question

  • Here is an Analytical Grid's MDX:

    SELECT

    { [Report School Actions] } * { [Measures].[YTD Infraction Count], [Measures].[Infraction Rate] }

    ON

     

    COLUMNS
    {SchoolStudentList.AllMembers}

    FROM

     

    [KAPSDW DEV]

    The [Report School Actions] is a named set.  I use it in an Analytical Grid and it lists the very things that I want to exclude.  It works perfect in the SSMS MDX Query winder, but not in PPS.

    Monday, August 10, 2009 8:35 PM

Answers

  • Never mind....  The problem was a difference in the cube between two environments.

    Grrrrrrrrrrrrrrrr!
    • Marked as answer by BShaw Monday, August 10, 2009 11:05 PM
    Monday, August 10, 2009 11:05 PM