Inline many to many relationships in Microstrategy
#inline #manytomany #manytomanyinline
In-line M-M Relationships:
Explanation | An in-line many-to-many relationship involves an attribute with at least one parent and one child. Its relationships with them are many-to-many. These relationships can be direct or indirect. |
Problem | Double counting, ignored filters. |
Recommendation | MicroStrategy does not recommend or support this type of schema. |
Workaround / Solution | Modify table structures, remove M-M relationship. Create compound key attributes to use as one to many children of the attributes in question |
Comments
Post a Comment