posted on Tuesday, June 14, 2005 9:26 AM by marcorusso

Drillthrough in SQL2000 SP4

I just discovered that drillthrough works in SQL Server 2000 SP4 even when used on calculated measures. I'm pretty sure it doesn't work with SP3. I haven't read about this in the kb888800.

I'd like to know if this is really a bug fixed or if I always misused drillthrough... Anyway, may be it's a very interesting news for many olap developers!

UPDATE: starting from a comment from Mosha I further investigated it and it was a miss on the Drillthrough macro code in Excel, that doesn't include the measure in the generated drillthrough query. So definitely don't consider this post as a real issue.

Comments

# re: Drillthrough in SQL2000 SP4 @ Tuesday, June 14, 2005 9:56 AM

Hi Marco - Drillthrough should _not_ work on calculated measures, and on calculated members in general. If it appears to work - it's a bug. Can you post more details - what is your query and what do you get back ?

mosha

# re: Drillthrough in SQL2000 SP4 @ Wednesday, June 15, 2005 12:55 AM

Mosha, I just bettere analyzed that and it works from Excel (with a macro that drillthrough the required cell) but doesn't work from Analysis Manager.
I further investigate that on a SP3 box just to make clear if the same macro behave differently or this is a previous bug (or strange behaviour) in the macrco itself.
Marco

marcorusso