Additionally, I can drillthrough becuase i am an admin, but my users cannot.
If I set the drillthrough permissions via the role in Analysis Services,
they can connect via Excel and are able to 'Show Details'. However, when the
cube gets rebuilt every night by PWA, these permissions are lost and they can
no longer drillthrough. Is there a way to tell PWA to enable this when the
cube is built?
Thank you,
Greg