Hi

I have a webpage which has an embedded pivot table
component.
By default at page load the pivot table is having a
activeview wih filter axis having a dimension as a filter
criteria.
At page load i want to show this filter dropdown as
the "All" member unchecked i.e with no filter criteria
selected.
Is this type of behaviour possible and if yes how?

Thanks And Regards
Samp

Hi,

I am not quite sure whether you can Uncheck the "ALL"
Members and don't check at least one of the member.

If you Uncheck "All" Members, then you will have to check
atleast one of the members to get some valid data.

Please check the following URL.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/dnoffsol02/html/odc_PivotingTablesParti.asp

Regards,
Sanka

Hi,

On page load i am getting all the data into the pivot
table i.e for all criteria in filter list.
After this can i do something in javascript due to which
all the members in the filter will get unchecked.
This means that the filter dropdown will be visible with
the all members unchecked, after which the user will have
to select at least one member.

Regards
Samp

Hi Samp,

I just tried out this and this works

vwView.FilterAxis.InsertFieldSet(vwView.FieldSets
('JunkDimension'));
vwView.FieldSets('JunkDimension').Fields
('JunkDimension').IncludedMembers = Array('Choose One');

Guess you would have written some code similar to the
first line to load a dimension in the Filter Axis.

Add the second line of code as above in your program.

This Line deselects all the elements in the JunkDimenion
and tries to select 'Choose One' element in JunkDimension.
I am hoping you don't have any element called 'Choose One'
in the dimension...
As it cannot find the element, 'Choose One' and also it
wouldn't have selected any element in the dimension - So
the User can now select any element he wants from the list.

Note that the "All" member would be in the HalfGray status
on page load.

Hope this helps.

Cheers,
Sanka

Hi

Thanks a lot !!
It worked !!

Regards,
Samp