| Author |
Virtual Cubes in AS 2005
|
|
|
| Hi All
I have a virtual cube in AS 2000 that implements some aspects from the
Dynamic Security.
And we have a solution with Reporting services that uses MDX queries
filtered by the permissions cube.
In AS 2005 we don't have virtual cubes. Would I rewrite all my MDX queries
in AS 2005 to resolve the Dynamic Security?
Thanks a lot for any help or sugestion
Alexandre Calderaro
| |
| Dave Wickert [MSFT] 2006-01-26, 4:58 pm |
| If you look at the way the migration wizard works you will see how you need
to structure this. What the migration wizard does is that it creates a
physical cube for the virtual cube and then uses a linked measure group to
tie back against the base cube. Run the wizard against your AS2K cube and
you will see what I mean. You will need to use the same approach in your
dynamic security (using virtual cube) approach.
--
Dave Wickert [MSFT]
dwickert@online.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.
"Alex" <Alex@discussions.microsoft.com> wrote in message
news:AFEE5AA7-1DD9-41FE-B651- F3F1F2C7DFCA@microso
ft.com...
> Hi All
> I have a virtual cube in AS 2000 that implements some aspects from the
> Dynamic Security.
> And we have a solution with Reporting services that uses MDX queries
> filtered by the permissions cube.
> In AS 2005 we don't have virtual cubes. Would I rewrite all my MDX queries
> in AS 2005 to resolve the Dynamic Security?
>
> Thanks a lot for any help or sugestion
>
> Alexandre Calderaro
>
| |
|
| Thanks a lot Dave,
I will try the wizard.
Alexandre
"Dave Wickert [MSFT]" wrote:
> If you look at the way the migration wizard works you will see how you need
> to structure this. What the migration wizard does is that it creates a
> physical cube for the virtual cube and then uses a linked measure group to
> tie back against the base cube. Run the wizard against your AS2K cube and
> you will see what I mean. You will need to use the same approach in your
> dynamic security (using virtual cube) approach.
> --
> Dave Wickert [MSFT]
> dwickert@online.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.
>
>
> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:AFEE5AA7-1DD9-41FE-B651- F3F1F2C7DFCA@microso
ft.com...
>
>
>
|
|
|
|