Best practices for filtering widgets from different cubes in InterSystems DeepSee
Hi!
Sometimes I need to filter the widget on a dashboard from a different cube. And I face the following problem:
Widget A refers to a query from Cube A and I want to filter Widget B from Widget B.
Widget's B pivot refers to Cube B, and which has different dimensions for the same data.
E.g. cube A has the dimension Author and the Cube B has the dimension Member for the same data. So there is no way to filter such a widget B from the widget A.
Actually, once we filter a given widget B with another widget A, we add the Filter Expression to the MDX query which looks like member's expression from Cube A, like:
[Outlet].[H1].[Region].&[Asia]
Is there any way to alter the filter expression for Widget B, just changing the value of the last part (Asia in this case) of the filter expression?