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

SSAS Security Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 4:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 27, 2013 5:33 PM
Points: 198, Visits: 310
Hey I’ve a cube where I’d like to implement security access on different measures and calculated members

I've a calculation named profit which is derived from [Measures].[sales] - [Measures].[Cost]

Profit = [Measures].[sale] - [Measures].[Cost]

Question 1: How do I get the calculation named profit displayed in the Dimension Data cell security access so I can disable the Profit
cell.

Question 2: If I disable the calculation named profit which uses the 2 measures sales and cost will this impact of the sales & cost cells from displaying

From reading up does enable read –contingent on a cell security get me around this problem ?

Will the below MDX work for this example

( Measures.CurrentMember IS [Measures].[Sales]) and ( Measures.CurrentMember IS [Measures].[Cost]



Thanks
Post #1424463
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse