Multiple Dimensions in a single named set is it possible?

• adzymcfadzy

  Right there with Babe

  Points: 794

  More actions

  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.

• snap254

  Ten Centuries

  Points: 1022

  More actions

  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).

• adzymcfadzy

  Right there with Babe

  Points: 794

  More actions

  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?

• snap254

  Ten Centuries

  Points: 1022

  More actions

  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.;-)