Apply Filter for Dimension without Dropping into OWC PivotTable a

[RAGHAVAN JAYARAMAN]

I need to apply an persistent Filter without actually dropping the Filter
into any
Pivot table areas. When i apply Filter into FilterAxis and haven't used
isIncluded to false, the Filter gets applied but if set to false, the filter
doesn't get applied.
Also i tried Calculated Members from Non-Measures to resolve this issue ,
but i have read from forum it's not supported on OWC , PTS etc for Non
Measures.
Is there a way i can restrict user from Filter for a particular dimension ,
instead of
setting AllowFiltering to False. I want the Filter to applied for particular
dimension
so that i'm restricting access to user for data. I found a way to disable a
particular dimension from the FieldList ( DisplayInFieldList to False) but i
cannot disable a particular filter.
Thanks for any help!

 

[Alvin Bruney [MVP - ASP.NET]]

That functionality is not supported

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc, Amazon, B&H etc


Forth-coming VSTO.NET

 

[RAGHAVAN JAYARAMAN]

Thanks Alvin for the reply. Is there to achieve from MSAS Side through
Cube partitions or Setting Dynamic Dimension Security from Analysis Server
Side
to allow user to use only some portion of Data ( Filter by particular
Dimension).

I'm a great fan of this OWC tool but i can't sell this to upper management
unless i resolved this issue or OWC overcomes this limitations.I'm not sure
if these supported by RS2005 , Proclarity or Business Object tools etc..

That functionality is not supported

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc, Amazon, B&H etc


Forth-coming VSTO.NET
-------------------------------------------------------------------------------

I need to apply an persistent Filter without actually dropping the Filter
into any
Pivot table areas. When i apply Filter into FilterAxis and haven't used
isIncluded to false, the Filter gets applied but if set to false, the
filter
doesn't get applied.
Also i tried Calculated Members from Non-Measures to resolve this issue ,
but i have read from forum it's not supported on OWC , PTS etc for Non
Measures.
Is there a way i can restrict user from Filter for a particular dimension
,
instead of
setting AllowFiltering to False. I want the Filter to applied for
particular
dimension
so that i'm restricting access to user for data. I found a way to disable
a
particular dimension from the FieldList ( DisplayInFieldList to False) but
i
cannot disable a particular filter.
Thanks for any help!