Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to not make Tables, Column and Data Available in Excel Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 4:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
Goal:
Not displaying the dimension table and its data in excel

Problem:
I was enable to deny access for the user roles in SSAS about denying access the data from the column but the next thing is that I do not know how dimension table and column not to be available in the excel.

Information:
*The datasource is SSAS
*I have made three user to have access to two tables only.


  Post Attachments 
picture4.png (4 views, 64.30 KB)
Post #1522631
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse