We added dimension security rules to some hierarchical dimensions in
our cube. It works great, however, when viewing measures with one of
these hierarchies using the CellSetGrid, we get an error when trying to
expand a node. The error occurs in the method GetMemberChildCount in
the CubeSchema.cs file on the following call:
tableMbr = oCon.GetSchemaDataSet(adomdp.AdomdSchemaGuid.Membe rs,
restMbr).Tables[0]

Error Message: Errors in the OLAP storage engine: Either you do not
have permission to access the specified member, or the specified member
does not exist.

Anyone have any insight? Is there a way to implement those kind of
permissions and still be able to allow the code to execute those kind
of calls under a restricted user context?

The hierarchy rule implements MDX that maps the user to nodes on each
hierarchy where we want to restrict the scope of what the user can see.
Again, this appears to work perfectly once we applied latest hot fixes
and checked the Enable Visual Totals options on each.