多對多基數(shù)關(guān)系
The many-to-many cardinality relationships have been available since Analysis Services 2019. However, the relationship editor in Visual Studio does not provide the ability to change the filter direction. The default is “Both”, which is seldom the appropriate choice. The filter direction can be modified in Power BI Desktop.
One of our customers (Jürgen Fa?bender, Orbit Gmbh) wanted to use Visual Studio to control this setting, but he was not able to do so: “We opened a support ticket as you suggested, but Microsoft closed the issue without delivering a fix. The workaround provided is editing the model.bim manually, or use a different editor like Tabular Editor."
多對多基數(shù)關(guān)系自 Analysis Services 2019 起就可用。但是寂纪,Visual Studio 中的關(guān)系編輯器不提供更改篩選器方向的功能刷袍。默認(rèn)為“Both”,這很少是合適的選擇店枣。可以在 Power BI Desktop 中修改篩選器方向红竭。
我們的一位客戶(Jürgen Fa?bender潦刃,Orbit Gmbh)想要使用 Visual Studio 來控制此設(shè)置,但他無法這樣做:“我們按照您的建議打開了ticket右遭,但 Microsoft 關(guān)閉了該問題做盅,但沒有提供修復(fù)程序缤削。提供的解決方法是手動編輯 model.bim,或使用不同的編輯器吹榴,如表格編輯器亭敢。“