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.

[PavoGa]

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

What is it you are trying to accomplish exactly?

Also, the example could be confusing. From the coversation, it is assumed that a and c are separate hierarchies within the same dimension and if so, why is children used? Or are a and c consolidations within the same dimension?

Is it:

UNION( [dim1].[consolidation_a].children, [dim2].[consolidation_c].children) (not possible)

or

UNION( [dim1].[alt_hier_a].[some consol].children, [dim1].[alt_hier_c].[some aconsol].children) (pretty sure not possible either)

or

UNION( [dim1].[consolidation_a].children, [dim1].[consolidation_c].children) (yes possible)

If separate dimensions or hierarchies, you could (maybe) generate an INTERSECTION of the two sets, but not a UNION as mentioned.

NOTE; an intersection could not be created using the INTERSECTION function, but GENERATE and StrToMember nonsense and it would be tricky if possible.