I have a PPS implemntation with several filters designed. I have several dashboards that make use of cascading filters. Most of these work, however, some exhibit some odd behavior.
For example, I have one cascading filter that is based on a SUPERVISOR - EMPLOYEE hierarchy. There are several Supervisors ni the organization, and each supervisor can have one or more employees under them. When browsing my Analysis Services dimensions and cubes, the supervisors and their respective employees appear just fine. See the screen shot below:
However, when the same hierarchy is viewed in my dashboard, I yield the following results:
As you can see, there are two names missing from the list. I've created the two filters fine. The first filter is SUPREVISOR which is of type MDX query:
[Employee].[SUPERVISOR - EMPLOYEE].[Supervisor Name].ALLMEMBERS
The second filter is EMPLOYEE BY SUPERVISOR which is also of type MDX query:
[Employee].[SUPERVISOR - EMPLOYEE].[Employee Full Name].ALLMEMBERS
I placed the two filters into the dashboard and created a connection between Supervisor and Employee using the Unique Name attribute of Supervisor in the Employee filter.
I have also included the following as the connection formula in the Employee filter:
DESCENDANTS(<<SourceValue>>, [Employee].[SUPERVISOR - EMPLOYEE].[Employee Full Name], SELF_AND_BEFORE)
I'm not sure why the filter isn't displaying all the proper values.
Any insight would be greatly appreciated!!!