Click here to Skip to main content
12,821,670 members (35,229 online)
Rate this:
Please Sign up or sign in to vote.

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?

Posted 3-May-12 22:11pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 4 May 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100