.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Understanding the Denied Member Set (MDX)

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

There is something that I need a basic explanation on concerning the use of the DeniedSet Property to restrict access to cube data. According to Books Online explanation The DeniedSet property uses an MDX expression to determine the attribute members to which a database role is explicitly denied access (the denied set)” (http://msdn.microsoft.com/en-us/library/ms175366.aspx).  In addition, once the denied set is specified, Books Online mention that The denied set that is specified for the attribute does not limit the visibility of newly added members … through the EXISTS key word” (http://msdn.microsoft.com/en-us/library/ms175586.aspx). It is the second quote that I need clarification on using basic terms to explain it. Please consider the following MDX expression which is working well to address my need but I wonder what will happen if new data is loaded as we do data loads on a monthly basis. We haven’t added new data yet since I created this expression.

View Complete Post

More Related Resource Links

Access Denied for when creating workspace for Contribute Member

Hey guys,

I'm new to sharepoint so please go easy on me. 

Everything on the site works fine with my account. My account is assigned full control for permissions.

I have a member that is given contribute permissions and he can access everything on the site as well (like he should be able to). However, he found a problem tonight in our testing and I've been able to trouble shoot it a bit.

When he tries to create a new workspace, he gets an access denied error. I logged into his account and verified that his account is unable to create the new workspace. My account can create it with no problems. I gave his account full access (instead of contribute) but still he was not able to create a new workspace.


Mukesh Ajmera

Intermittent Access Denied to Users with Member Permission Levels


Hello Community,


I have another tough SharePoint mystery I am trying to solve.  Essentially, users with Member permission levels are experiencing issues accessing a sub-site of a Site Collection intermittently. Users will Full Control, Site or Farm Collection Administrator access do not experience this issue. When the Site Owner with Full Control permission levels opens the site in the morning then the users with Member permission levels are able to access and navigate the sub-site without issue.  Does anyone have any thoughts on what this type of problem may be related to?





Tom Molskow SharePoint Architect - If I solved the issue please propose my reply as the answer - Thanks!

Truly Understanding View State

This article provides a detailed understanding of the ViewState.

Get Member from LDAP using C# 2.0


I'm currently writing a process where I need to determine if an User on my LDAP string is an Admin.

How can I accomplish this?  What would be the easy and quickest way?

I've been trying to use the code below..... Any feedback is greately appreciated. Tks



Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


CLR Inside Out: Understanding The CLR Binder


In this article, we cover some of the best practices for assembly binding and loading using the CLR.

Aarthi Ramamurthy and Mark Miller

MSDN Magazine May 2009

Access Control: Understanding Windows File And Registry Permissions


Understanding the ACLs that govern permissions and rights before an operation is allowed to proceed is critical to enhancing security.

John R. Michener

MSDN Magazine November 2008

Advanced WPF: Understanding Routed Events And Commands In WPF


See how routed events and routed commands in Windows Presentation Foundation form the basis for communication between the parts of your UI.

Brian Noyes

MSDN Magazine September 2008

CLR Debugging: Improve Your Understanding of .NET Internals by Building a Debugger for Managed Code


With the release of .NET, the Microsoft scripting strategy has evolved. Script engines can now compile or interpret code for the Microsoft common language runtime (CLR) instead of integrating debugging capabilities directly into apps through Active Scripting. With that change comes a new set of published services for including debugging functionality in a custom host application. You'll see how to use the debugging services published in the .NET Framework to create a full-featured CLR debugger that allows you to set breakpoints, view call stacks, browse variables, view processes, enumerate threads, and perform other important debugging tasks.

Mike Pellegrino

MSDN Magazine November 2002

Apparently missing something in my understanding of session handler...


 It was doing exactly what I expected until I added more than 1 property to it.   It seems if I set the value of a property this, in turn, sets every property in the handler to the same value.  It's blatantly obvious I didn't have the understanding I thought I did on this.  :-)

Could someone point out what I'm missing?  I figured it had something to do with the "shared" but if it's not shared then I would have to declare an instance on my page which would kinda ruin the state of my variables (otherwise, I'd just put them all in my class), right??

Private Shared _strStudentName As String
Private Shared _strSchoolID As String

    Public Shared Property StudentName() As String


            If (HttpContext.Current.Session(SessionHandler._strStudentName) Is Nothing) Then
                Return String.Empty
                Return HttpContext.Current.Session(SessionHandler._strStudentName).ToString()
            End If

        End Get

        Set(ByVal value As String)
            HttpContext.Current.Session(SessionHandler._strStudentName) = value
        End Set

    End Property

    Public Shared Property SchoolID() As String


            If (HttpContext.Current.Session(SessionHandler._strSchoo

"Access is denied. Check that the Default Content Access Account has access to this content"


Our search is not working. The crawl log indicates following error: "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.)".


If I check the event viewer, it indicates following error: "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]"


My default content access account is another one than this NT AUTHORITY\NETWORK SERVICE account. The content access account password is correct. Apparently this content access account is translated to the NETWORK SERVICE account upon a crawl. And this network service account doesn't has the appropriate rights on database level. How can I fix this?


Access Denied with SPControlMode.New and RunWithElevatedPriviliges


I am trying to add MultipleLookupField to a webpart I am developing. It works fine as long as the user has Add permission on the list it points to: here is the code:

private MultipleLookupField _multiplelookupKeywords = new MultipleLookupField();
protected override void CreateChildControls()
Guid guidSite = SPContext.Current.Site.ID;
Guid guidWeb = SPContext.Current.Web.ID;
    using (SPSite site = new SPSite(guidSite))
        using (SPWeb web = site.OpenWeb(guidWeb))
  SPList listTest;   
  listTest = web.Lists[ListName]; 
  _multiplelookupKeywords.ListId = listTest.ID;
                _multiplelookupKeywords.ControlMode = SPControlMode.New; //Changing this to SPControlMode.Display works fine
                _multiplelookupKeywords.RenderContext = SPContext.GetContext(web);

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend