How detect filter selected in filter axis? 
Author Message
 How detect filter selected in filter axis?

I'm trying to create an MDX query to execute DRILLTRHROUGH, but i can't detect the filters which are checked.

This is the way i'm trying to detect the filters, but it isn't working:

For i=0 To document.PTable.ActiveView.FilterAxis.FieldSets.Count -1
         sMDX = sMDX & "{" & document.PTable.ActiveView.FilterAxis.FieldSets(i).Filtermember.UniqueName & "} ON AXIS         (" & axisCont & ") ,"
        axiscont = axiscont + 1  
Next

I'm use OWC10

  Fernando Colosimo


  ICQ #43180585



Sun, 31 Oct 2004 03:50:50 GMT
 How detect filter selected in filter axis?

Hello,
See the following article Microsoft has recently posted:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q302101

Best regards,
Geyzerskiy Dmitriy

Quote:
>-----Original Message-----
>I'm trying to create an MDX query to execute

DRILLTRHROUGH, but i can't detect the filters which are
checked.
Quote:

>This is the way i'm trying to detect the filters, but it
isn't working:

>For i=0 To

document.PTable.ActiveView.FilterAxis.FieldSets.Count -1
Quote:
>         sMDX = sMDX & "{" &

document.PTable.ActiveView.FilterAxis.FieldSets
(i).Filtermember.UniqueName & "} ON AXIS         (" &
axisCont & ") ,"
Quote:
>        axiscont = axiscont + 1  
>Next

>I'm use OWC10

>  Fernando Colosimo


>  ICQ #43180585



Sun, 31 Oct 2004 19:53:24 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to filter many data in filter axis when using PiovtTable10

2. Filtering Pivottable on the row axis

3. Limit the values in filter axis

4. Filter Accross Date Range - Different Filter Value for Different Dates

5. Row Filter & Join Filter

6. Merge Replication with Dynamic Filter and Row Filter failure on two Deletes

7. Row filters don't filter enough

8. Problem with filters and join filters in merge replication

9. joined dynamic filters VS dynamic filters [mergerepl]

10. Join Filters not filtering

11. Dynamic filter vs static filter...

12. show members with empty measure values/filters on filters


 
Powered by phpBB® Forum Software