Unfortunately, no. A role must have either a username or a group as members.
The system cannot do automatic mapping -- as an admnistrator you must do it
by-hand. However, there are ways you can script out and then create roles
from the command line -- but you must implement this. Look at using the
DSO/XML tool with it's ability to import/export objects from xml files.
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jermaine Chan" <j43chan (AT) uwaterloo (DOT) ca> wrote
Quote:
I'm currently trying to make information available to users over the
internet and have set up the olap report on iis.
I have defined Cube roles which retricts a certain dimension. is it
possible to make a login system that will match the user with a
certain cube role? Thanks a lot. |