Can MDX work across alt hierarchies from one dim?

[macsir]

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )

[Wim Gielis]

That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?

[lotsaram]

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )

This can't work by definition. The hierarchies are separate entities. No C elements are shared.

You could use Generate to loop a set on one hierarchy and return the set of leaves (or even the set of C elements sharing the same name) existing in the other hierarchy.

[macsir]

That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?

No, just want to see if it is possible in a MDX set.

[macsir]

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )

This can't work by definition. The hierarchies are separate entities. No C elements are shared.

You could use Generate to loop a set on one hierarchy and return the set of leaves (or even the set of C elements sharing the same name) existing in the other hierarchy.

Haven't used Generate function a lot but good to know.

[Wim Gielis]

That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?

No, just want to see if it is possible in a MDX set.

Then the answer is no, as what Lotsa also replied.

[ardi]

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )

Not possible, different hierarchies of a dimension are treated the same as 2 separate dimensions.