Does Drill Through work fine in AS2005?

Hi,

I had designed several cube in AS2005. And I counfused by some problem of drill through.

1. The large amount of dimensions makes drill through broken?

Drill Through works fine in the cube that includes 20 dimensions. But, In the same cube, the amount of dimensions is increase to 25. The drill through works no response...

2. In some case, the drill through do not response correct row data.

A MDX syntax that response measure is 8 (In my project, that means there would be 8 row data in the fact table.).
And I use the same mdx syntax to drill through, that only response 1 row data!

Any idea? or it's the bug?

thanks,

Drillthrough is certainly very different in AS 2005 compared to AS 2000.

It returns you the rows at the deepest granularity of the measure group. If the rows in the measure group are for the same cell coordinate, then they will aggregate up to a value of 8 in 1 row.

If you need to see all 8 rows, then you should define a degenerate dimension (could also be ROLAP) which is at that deepest granularity -- e.g. at TransactionID. You can hide this dimension so normal cube browsing operations will not see this deepest granularity.

When you define the default drillthrough action for the cube you can specify this granularity attribute in the RETURN clause and fetch the data for the 8 unique rows.

Its difficult to say what may cause the different behavior when you move from 20 dimensions to 25. Perhaps looking at profiler would help to see what is happening. Also, you need to make sure that drillthrough is being done on a reasonable size of dataset -- drilling through on a cell that has millions of fact rows will perform very badly.

HTH,

Akshai