Drill through in migrated cubes ?

We have some migrated cubes that implemented drillthrough in Analysis Services 2000 and appear to have drill through in the migrated version if viewed through Proclarity. But when I look at the cube in the 2005 BI studio, I see no structure to implement this drill through. Nor am I able to drill through from the Management Suite--just Proclarity.

What's going on ?

Dan,

Drillthrough has gone through significant changes in AS2005. The following is a link to a good whitepaper on the topic:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_anservdrill.asp

What you are seeing in ProClarity is "backward compatibility" support that was built into our 6.1 release. If you build a "Drillthrough Action" in AS 2005 it will show up in the cube browser used by the BI Studio.

HTH,

- Steve

|||

Steve:

I appreciate the help, but am a little confused.

First, my group has implemented drill through in 2005 using the concept of a degernate dimension on new (i.e., NOT migrated) cubes.

Our confusion occurs becauses migrated cubes exhibit drill through when viewed in Proclarity, but do not have a degernate dimension when examined in the BI 2005 Development Suite.

So, where is Proclarity getting the drill through data from ?

The answer apparently must be that SQL Server Analysis Services 2005 implements an "alternate drill through capability" that cannot be built using the 2005 BI Suite at all, but can only be created by first building a cube in 2000, and then migrating it.

Is this true ?

So, why is this all relevant to us ? Because we wish to add a field to the drill thru in the migrated cube.

|||

Dan,

If you can email me a phone number at spontello@.proclarity.com we can discuss the specifics.

- Steve

|||

Steve,

Is there a way to turn off this "Drill to detail" feature at the PAS server level?

Or to map the "Drill to detail" action to a Drillthrough action that was specifically created by the cube designer?

Thanks,

JGP

|||

JGP,

This could be done by customizing the PAS code. If you want more details send me an email at spontello@.proclarity.com.

- Steve