J
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.
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.