Drillthrough action

Hi,

Is there any way in AS2005, I can specify a cube action which will bring up an HTML page displaying the Drillthrough MDX for the cell that I just initiated the action on?

Also, will this MDX work across all cube partitions (no need for FIRSTROWSET clause)?

Thanks,

JGP

Drillthrough actions return a DRILLTHROUGH statement to client application (e.g. cube browser) which in turn executes the statement and displays the results. The results will contain data for all partitions (no need for FIRSTROWSET clause). See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_anservdrill.asp for more info.

HTML actions are unsafe and BI Dev Studio does not let you create them. If you do want to expose the DRILLTHROUGH statement to the user, you have to plug in some code (depends on the client app) that retrieves the actions schema rowset, extracts the statement and displays it.

|||

Any idea how I would go about retrieving the action schema rowset? Any samples would be greatly helpful.

I'm trying to get this working from the ProClarity clients (Standard and Professional).

Thanks,

JGP