All filter on a Dimension

[Jer006]

Hi I have a cube in Analysis services 2000 and am using an OWC pivot table
control to view this over the web. On the cube there is a date dimension
from which I have removed the (All) option (All level is set to No in the
cube itself for this dimension).

Once I connect to the cube using OWC 9 the dimension shows up correctly with
no corresponding (All) level however in both OWC 10 and OWC 11 with no code
changes to either my cube or the HTML/VBScript the All level is available and
selectable, can anyone tell me why and how to remove this as this is invalid
for this field?

Also my date field is currently sorted in Ascending order so that the first
date in the series is selected upon opening up the cube (in all versions of
OWC), however I would like to either change the default selection or the sort
order so that the latest date is selected from the dimension when the cube
first loads up in the pivot table control, is this possible and if so how? I
have tried sorting and have had no luck, I have also tried filtering which
works but removes all other options from the dimension and that is not what I
want either....

One last request, with the Expanded option, is it possible to have a finer
level of control that basically expand all, for example I have a RowAxis
field called Hedge which has Y or N options and I would like to have N
expanded by default but Y should be collapsed. Currently with the Expanded
option both of these are expanded.

Thanks for any help you can provide!


Jeremy.

 

[Alvin Bruney [MVP]]

For first and second issue, you can simply set the expand all property to
false. You'd have to iterate the axis in question and examine each
fieldset's expand property. I believe there is a global expand property but
my memory doesn't always serve me correctly.

For the default sort, you would either need to adjust this at the cube level
or prepare a special mdx query.
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley