MS SQL Data Warehousing - Security for Parent-child Hierarchies

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Security for Parent-child Hierarchies

2006-03-22, 9:23 am

We are having an issue with Parent-Child Hierarchies and security. We have
attached roles to the Employees dimension in Adventure Works. It all seems
to work fine with the exception of one issue. We have placed role1 to see
only "Racheal B. Valdez". This works fine except that it is showing totals
for all of the others as well. We have tried setting "Visual Totals" on the
Advanced Tab in Dimension Data but it throws a COM error when we attempt to
view the cube.

Thanks,

Al

Sponsored Links