dbTalk Databases Forums  

Re: hide members in parent-child

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: hide members in parent-child in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Deepak Puri
 
Posts: n/a

Default Re: hide members in parent-child - 12-05-2005 , 10:42 AM






How about just using custom dimension security, in "Dney Only" mode -
the denied members will still contibute to higher level aggregations,
unless VisualTotals are enabled?

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agsecurity_3xbt.asp
Quote:
Custom Rules in Dimension Security

In a database role or cube role, by defining a custom rule for a
dimension, you can specify which dimension members can be accessed by
end users in the role. To do this, you can select the accessible levels,
or specify the accessible members, or use these methods in combination.
You can also specify options for visual totals and select a default
member.
...
Deny Only (Member Specifications)

The members you explicitly deny access to and their descendants cannot
be accessed. Nondescendants can be accessed unless they are above the
top level or below the bottom level.
...
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: hide members in parent-child - 12-05-2005 , 02:42 PM






The issue in your example is that [Employees] as an "All" member, which
does not have a Gender property. If you exclude it, then Filter() should
work:

Quote:
Filter(Except([Employees].Members,
{[Employees].[All Employees]}),
[Employees].Properties("Gender") = "M")
Quote:
- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.