SSAS union in MDX query

• kf-603404

  Old Hand

  Points: 321

  More actions

  September 21, 2011 at 3:44 am

  #257762

  Hi,

  Can anybody tell me how I can write an mdx query with union like in t-sql?

  I would like to collect data from 2 or more cubes for one report. The cube structures are the same. The first cube contains data for 2010, the second one for 2011.

  I can't create one cube for all data.

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  September 21, 2011 at 4:14 am

  #1384392

  If the cubes are in the same database then you can use the LOOKUPCUBE function.

  Or you could combine your datasets in SSRS by having adjacent tables with different datasets.