I've got a dimension in the OWC11 that comes already filtered (using MDX, 3
of 5 items). Is there any way to don't let the user change the filter?, I
mean, deactivate the OWC dimension.

In article <C9E865AD-4CCE-4BCE-B90B-DB997AEFA829 (AT) microsoft (DOT) com>,
lumina (AT) nospam (DOT) com says...
One possible solution, which would not scale very well, but would work
if this is a once off, is to create a virtual cube. In that virtual cube
you can include all the dimensions from the base cube, but set your
filtering dimensions visible property to false in the virtual cube. Then
you can override that dimensions All Member formula in the virtual cube
to be something like "SUM({<member 1>,<member 2>,<member 3>})"

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

Thankyou Darren, but i need to dynamically do this, that is according to the
user who this viewing the page, therefore I cannot generate a cube to the
flight.


"Darren Gosbell" wrote:

Have you looked into using dimensional security? Or are you trying to
just set a preferred default rather than enforcing a strict restriction.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <DD23E887-470B-4D73-B97F-62F4926E019C (AT) microsoft (DOT) com>,
lumina (AT) nospam (DOT) com says...