Different cube view for different Studios

[Bark]

Hi Cognoisers,

I have a requirement for a cube to have different levels in the hierarchies when it runs in a report or in Analysis Studio. The report has drill-up/down but they want to skip some levels; whereas when it comes to Analysis studio they'd like to have them all.

I thought about creating a different view and applying some sort of security so depending on the capability one view is selected over the other but it seems more complicated than I thought because if the user has access to AS, they will see the same view in RS...

Is there (or can you think of) any way of achiving this?

Thanks for your help,

Bark

[bdbits]

You could create separate cubes. Or within the same cube, create alternate drill paths and include "(Report Studio)" and "(Analysis Studio)" in the descriptions.

In terms of one cube displaying differently depending on studio, nothing comes to mind.