MDX+SSRS #33 - Retrieve manager's key and fully-qualified member name
User Rating: / 0
Written by Sherry Li   
Friday, 08 November 2013 20:00

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:



Tags: mdx, ssrs

Pyramid Analytics