Hi there,
I am facing a very big problem related to the scorecard filter connection.
I have a dimension hierarchy in the rows of the scorecard and I have a Filter connected to that hierarchy. The filter contains 2 members: "All" and "Active".
"All" should show all the dimension hierarchy members in the scorecard
"Active" should show only the hierarchy members that have as True the "Active" member attribute.
This requirement is done, but the PROBLEM is that when I connect the filter to the scorecard, the scorecard is no more showing a hierarchy with the expand and collapse controls in the members, instead, the scorecard is showing a "flat" set of the hierarchy without levels and expand and collapse controls.
The filter connection in the scorecard has a connection formula as following:
IIF(<<SourceValue>>.Member_Name = 'Active', (([MyDimension].[MyDimHierarchy].Members,[MyDimension].[Active].&[1]), [MyDimension].[MyDimHierarchy].Members)
Is there any way to get the hierarchy filtered without loosing the hierarchy shape and behaviour? Maybe the connection formula above is not 100% correct for filtering a hierarchy...
Thanks and best regards,
Joss