dbTalk Databases Forums  

The username function in SSAS 2000

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


Discuss The username function in SSAS 2000 in the microsoft.public.sqlserver.olap forum.



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

Default The username function in SSAS 2000 - 08-16-2006 , 02:01 PM






I implemented dimension security and got it to work successfully in the test
environment. However, when I implemented the same solution in the production
environment it fails, I receive this error message when testing the role:

User-generated error - the dimension "Employees" has no valid member.

The difference between these two environments, they are both on a separate
network. I can't determine why it works in the test and not production. The
only thing I can think of is that the domain/username that UserName function
is not matching the domain/username that I have in the table but it is the
same as in the test environment.

Is there a way to verify what the Username function is returning so I can
check the comparison?

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.