Improve capacity on relationship

[mourad1]

In Tabular SSAS model relationship is limited. Can we have the same or equivalent capacity for relationship on SSAS Tabular and Multidimensional. - Enable relationship on different granularities. - Enable multiple relationship. - Allow, Many to Many / One to Many / Many to One...

[administrator8]

For those with complex hierarchies, Tabular can be extremely complex to implement. I really hope that this comes to fruition!

[fbcideas_migusr]

If you are thinking of copying the SSAS-MD Designer's "Cube / Dimension Usage" tab (not a bad starting point), then please add functionality to copy and paste relationship definitions ("cells"). E.g. if I have defined a relationship between fact1.dimension2_key-> dimension2.dimension2_key, let us copy that and paste it into a different "cell" as: fact2.dimension2_key -> dimension2.dimension2_key.

[lenagry]

and enable the relationship on a combination of columns, not just a single column

[v-orbrad]

I have difficulties creating multiple relationships to one table, which does not happen in excel models. It would be great if this could be improved.