M
Madan
Hello All
I'm using Office XP web components for analysis of our data.
I have implemented "Drill through" feature using the drillthrough.htc
provided by Microsoft with office web development toolpack.
It works great but for a special case.
The scenario is like this,
Pivot table is organised as follows
Year
2004 2005
Country Gender
-India 10 15
-Germany 15 25
-France 10 25
On the row axis, i have Country and Gender as dimensions and on the column
axis i have year as dimension.
The measure values for India are 10 and 15 for 2004 and 2005 years
respectively.
If i apply filter for the Gender dimension (sellect only Male) then the
totals are reduced as follows,
Year
2004 2005
Country Gender
-India 05 10
-Germany 10 15
-France 10 15
but when i drillthru for India for the year 2004 here, i should get 5 rows
returned but i'm recieving 10 rows.
The filter criteria is not taken into consideration until i expand the
"Gender" dimension as follows,
Year
2004 2005
Country State
-India 05 10
Male 05 10
-Germany 10 15
-France 10 15
now when i drillthru for for India for the year 2004 here, i get 5 rows
returned.
How can i get the filtered rows returned even when the sub-dimension is not
expanded?
Madan
I'm using Office XP web components for analysis of our data.
I have implemented "Drill through" feature using the drillthrough.htc
provided by Microsoft with office web development toolpack.
It works great but for a special case.
The scenario is like this,
Pivot table is organised as follows
Year
2004 2005
Country Gender
-India 10 15
-Germany 15 25
-France 10 25
On the row axis, i have Country and Gender as dimensions and on the column
axis i have year as dimension.
The measure values for India are 10 and 15 for 2004 and 2005 years
respectively.
If i apply filter for the Gender dimension (sellect only Male) then the
totals are reduced as follows,
Year
2004 2005
Country Gender
-India 05 10
-Germany 10 15
-France 10 15
but when i drillthru for India for the year 2004 here, i should get 5 rows
returned but i'm recieving 10 rows.
The filter criteria is not taken into consideration until i expand the
"Gender" dimension as follows,
Year
2004 2005
Country State
-India 05 10
Male 05 10
-Germany 10 15
-France 10 15
now when i drillthru for for India for the year 2004 here, i get 5 rows
returned.
How can i get the filtered rows returned even when the sub-dimension is not
expanded?
Madan