MDX+SSRS #33 - Retrieve manager's key and fully-qualified member name
A co-worker recently worked on a SSRS report and wanted to use a specific manager's team for testing. The Manager is a filter for the SSRS report and can take a fully-qualified member name as the default value. Using the Employee dimension in Adventure Works cube as an example, a fully-qualified member name can take two forms, key-based and name-based:
Read more...