Post reply

MDX member names in RS

  • October 13, 2005 at 5:35 pm

    #111006

    I'm baffled with this problem. If you type this MDX query in the MDX Sample Solution app. you will see a nice resultset with columns 1,2 3.. for each of the months.

    select

    {[Time].[Month].Members

    }on columns,

    {

    [Product].[All Products].[Drink]

    }

    on rows

    from [Warehouse and Sales]

    But if you enter the same MDX query on Reporting Services, the "field names" for the months get converted to something like [Time].[1997].[Q1].[1]

    How can you fix this?.

  • October 13, 2005 at 5:47 pm

    #597233

    One of the things learnt about using MDX with RS2000 is to use only measures in the columns of your query.  Also you should look for Bill Pearsons articles on using MDX with RS, and possibly prior to these read the Msft document/whitepaper on using RS with Analysis Services (found here).

    HTH,

    Steve.

  • October 13, 2005 at 5:50 pm

    #597234

    Forgot to mention you should download these samples too, helps with passing parms etc.

    cheers,

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply