dbTalk Databases Forums  

Cube Roles

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


Discuss Cube Roles in the microsoft.public.sqlserver.olap forum.



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

Default Cube Roles - 03-05-2004 , 01:36 AM






Hi

We have a Cube Role called 'Emp' with some specific Cell and Dimension Security
We have added the active directory - User Group called 'Employees' as member of this Cube Role

Whenever a new employee joins our organization, he is automatically added to the 'Employees' User Group

But the problem is, the Cube is not able to recognize the User, unless and until we refresh the Database Roles / Cube Roles in the Analysis Manager

Please let us know if there is a fix for this issue. We are using Analysis Services 2000 (Enterprise edition) with SP3

Regards
Sanka

Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Cube Roles - 03-05-2004 , 02:45 PM






No, this is first time such an issue is reported. Please contact PSS about
it, and we will work towards resolution.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

Quote:
Hi,

We have a Cube Role called 'Emp' with some specific Cell and Dimension
Security.
We have added the active directory - User Group called 'Employees' as
member of this Cube Role.

Whenever a new employee joins our organization, he is automatically added
to the 'Employees' User Group.

But the problem is, the Cube is not able to recognize the User, unless and
until we refresh the Database Roles / Cube Roles in the Analysis Manager.

Please let us know if there is a fix for this issue. We are using Analysis
Services 2000 (Enterprise edition) with SP3.

Regards,
Sanka



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.