Improve capacity on relationship
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...
Orla Brady commented
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.
and enable the relationship on a combination of columns, not just a single column
For those with complex hierarchies, Tabular can be extremely complex to implement. I really hope that this comes to fruition!
Mike Honey commented
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.