Hi all,

I am setting up a brand new DW where the cubes and structures are very
different from the existing one. I therefore need to re-create all the
existing roles in the new DW too. I can not import them since structure
is different but a kind of report from the current roles with role name
and restriction rules would be great.

Can this be done?

Thank you.
AC

Look at DSO/XML and then use a style sheet to examine just the roles.
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<adybdahl (AT) hotmail (DOT) com> wrote