Post reply

mixed empty and non-empty dimensions in SSRS (from SSAS)

  • February 27, 2009 at 8:36 am

    #206348

    hi

    does anyone know how to mix empty and non-empty dimensions in SSRS? both are on my rows

    i assume it's possible in SSMS, but i don't know whether the MDX editor in SSRS will allow it???

  • February 27, 2009 at 2:39 pm

    #951395

    Anything you can do in SSMS you can do in the MDX Designer in SSRS. Take a look at the posting here and you will see you can go into the Design Mode of the MDX to modify it Using Reporting Services (SSRS) with SSAS data.

    If that does not work for you there is always the option to use the OLEDB provide for SSAS instead of using the Microsoft Analysis Services provider.

    If you are still uncertain as to how to do this post more information as to what you are trying to do exactly.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • March 10, 2009 at 12:07 pm

    #956993

    Dan English (2/27/2009)

    Anything you can do in SSMS you can do in the MDX Designer in SSRS. Take a look at the posting here and you will see you can go into the Design Mode of the MDX to modify it Using Reporting Services (SSRS) with SSAS data.

    If that does not work for you there is always the option to use the OLEDB provide for SSAS instead of using the Microsoft Analysis Services provider.

    If you are still uncertain as to how to do this post more information as to what you are trying to do exactly.

    hmmm not sure you can use column headers into the MDX builder in SSRS...

    but no matter, i solved it by getting rid of "NON EMPTY" and then doing a filter on the dimensions

    thanks anyways

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

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