Home Forums Data Warehousing Analysis Services Using MDX UNION (or append) attribute members from different dimensions RE: Using MDX UNION (or append) attribute members from different dimensions

  • Is it possible to "Union" data from different dimensions (same attribute)?

    No, that's a general rule of MDX, a set needs to have members that share the same dimensionality.

    Having said that, Chris Webb has shown a method of doing this (by using crossjoin) that may give the output you're looking for. The blog post is here.

    Steve.