Post reply

Multiple Dimensions in a single named set is it possible?

  • May 15, 2011 at 9:40 pm

    #250182

    Hi all,

    I am wanting to put multiple dimensions in a named set, eg: a record has to match 2 different dimension filters.

    I was thinking i could just use two named sets for each dimension, but is there a way to include multiple dimensions in the one named set?

    I am currently using exists to filter on one dimension.

  • May 17, 2011 at 3:33 pm

    #1326157

    Technically you can use more than 1 dimension in a named set. The problem is usually how you access it.

    Many client tools do not expose named sets at all while others do, some support the multi-hierarchy sets (Pyramid), but most only support a single hierarchy in the set (Excel, Proclarity and Panorama).

  • May 17, 2011 at 3:35 pm

    #1326158

    Thanks for this info, i am using MDX queries with SSRS to query the cubes and sets, so this should not be an issue.

    I was trying to use crossjoin, is this a good start?

  • May 25, 2011 at 12:18 am

    #1329490

    yep. although MDX is supported in a somewhat weird way in SSRS. You should tread carefully there.;-)

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

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