Pivot drill through

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top