Hi, I'm trying to create role definition for Emloyees dimension in HR cube, but I get error:
MDX object 'Derrick Whelply' not found in member '[Employees].[All Employees]'
My role definition in FoodMart.xml:
<Role name="HR Cube">
<SchemaGrant access="all">
<CubeGrant cube="HR" access="all">
<HierarchyGrant hierarchy="[Employees]" access="custom"
topLevel="[Employees].[Employee Id]">
<MemberGrant member="[Employees].[All Employees].[Derrick Whelply]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
What is wrong in my definition?
Thank's in advanced.
Peter