BUG or Intended Feature - Pivot Table Filter dropdown shows entire list -

[Rabbani]

Hi Alvin

I would really appreciate if you can help me understand this.

Please consider the below scenario

I have an OWC XP Pivot table in an asp page connecting to an olap cube. I have two dimensions (dimA, dimB) and a total. I dropped one dimension dimA (containing four values T1, T2, T3, T4) in the filter area. I checked T1 and unchecked the T2,T3,T4 and dragged the totals in the totals area. I dropped the dimB on the row area. The dimB contains a total of 400 members but as the filter is set to T1 in dimA, the pivot table shows only 100 members which looks fine.

The problem is, when i click the little filter-drop-down arrow on the dimB, i see the complete list of 400 members checked, although the pivot table shows only 100. Our users want the same 100 members to appear in the drop-down list too as shown in the pivottable according to the filter applied, so that it becomes easier for them to uncheck some more from that 100 if they want to.

Now, I am confused whether this is a BUG in OWC or an intended feature. If it is an intended feature, then what is the logic behind this. Is it possible to programatically hide these extra 300 members from the dimB drop-down list?

Thanks
Rabban

 

[Alvin Bruney [MVP]]

give me some time to look into this

 

[Mohammed Rabbani]

Hi Alvin,

Just wondering if you were able to get a chance to look into this?

Thanks for your time.

Rabbani

give me some time to look into this

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alvin,

I would really appreciate if you can help me understand this.

Please consider the below scenario.

I have an OWC XP Pivot table in an asp page connecting to an olap cube. I
have two dimensions (dimA, dimB) and a total. I dropped one dimension dimA
(containing four values T1, T2, T3, T4) in the filter area. I checked T1
and unchecked the T2,T3,T4 and dragged the totals in the totals area. I
dropped the dimB on the row area. The dimB contains a total of 400 members
but as the filter is set to T1 in dimA, the pivot table shows only 100
members which looks fine.

The problem is, when i click the little filter-drop-down arrow on the
dimB, i see the complete list of 400 members checked, although the pivot
table shows only 100. Our users want the same 100 members to appear in the
drop-down list too as shown in the pivottable according to the filter
applied, so that it becomes easier for them to uncheck some more from that
100 if they want to.

Now, I am confused whether this is a BUG in OWC or an intended feature. If
it is an intended feature, then what is the logic behind this. Is it
possible to programatically hide these extra 300 members from the dimB
drop-down list?

Thanks,
Rabbani

 

[Alvin Bruney [MVP]]

I haven't heard back anything. If you are pressed for time you should submit
a tecnical request to microsoft product support. This will allow a more
immediate response than my approach.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alvin,

Just wondering if you were able to get a chance to look into this?

Thanks for your time.

Rabbani

give me some time to look into this

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alvin,

I would really appreciate if you can help me understand this.

Please consider the below scenario.

I have an OWC XP Pivot table in an asp page connecting to an olap cube.
I
have two dimensions (dimA, dimB) and a total. I dropped one dimension
dimA
(containing four values T1, T2, T3, T4) in the filter area. I checked
T1
and unchecked the T2,T3,T4 and dragged the totals in the totals area. I
dropped the dimB on the row area. The dimB contains a total of 400
members
but as the filter is set to T1 in dimA, the pivot table shows only 100
members which looks fine.

The problem is, when i click the little filter-drop-down arrow on the
dimB, i see the complete list of 400 members checked, although the
pivot
table shows only 100. Our users want the same 100 members to appear in
the
drop-down list too as shown in the pivottable according to the filter
applied, so that it becomes easier for them to uncheck some more from
that
100 if they want to.

Now, I am confused whether this is a BUG in OWC or an intended feature.
If
it is an intended feature, then what is the logic behind this. Is it
possible to programatically hide these extra 300 members from the dimB
drop-down list?

Thanks,
Rabbani