Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bill_Pearson Stairway to MDX - STEP 1: Getting Started with MDX RE: Stairway to MDX - STEP 1: Getting Started with MDX

  • November 2, 2011 at 7:47 am

    #1402135

    SELECT

    {[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

    [Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

    [Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

    FROM [Adventure Works]

    where [Measures].[Reseller Sales Amount]

    and

    SELECT

    {[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

    [Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

    [Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

    FROM [Adventure Works]

    give me same result. Can somebody explain why ?