We have an SSAS role defined which can successfully execute a
drillthrough action, receiving a result set (header + records) SO LONG
AS no object level security is set. As soon as any object level
security is set on any dimension which contains an attribute to be
returned in the drillthrough, an empty set (header, no records) is
While executing drillthrough with Admin role. It is working fine and returning all the records but when same is executed with the role which is having limited access to data. (e.g. only filtered records access) instead of filtered data it is returning no records.
We are using SQL server 2008 R2.
we have not set any additional property in Role for drillthrough.
Do i need to set any addtional property?