I'm using SQL2008 AS and DB, downloaded and registered the correct DLL on my SSAS instance and am able to use certain functions like GetDefaultDrillthroughMDX and GetCustomDrillthroughMDX
without issue (both of them ran well in a rowset action expression).
However I really
need to access the database in my rowset action drilldown (long, boring story) and need to use the SQLQuery.ExecuteSql method. Here's my syntax for the action expression:
top 1 * from bc_dim_date")'
When I drill down using Excel 2007 I get this error: "The '[SQLQuery].[ExecuteSql]' function does not exist"
What am I doing wrong? urgent please...need help!