installed? and getting error

Topics: Developer Forum, User Forum
Jul 11, 2016 at 3:17 PM
hi I downloaded the ssas 2012 version and placed the assp.dll in the system32 directory, but when I run the following in an mdx window,

CALL ASSP.DMV("SELECT * FROM $System.DISCOVER_SESSIONS");

I get:

Executing the query ...
Query (1, 6) The '[ASSP].[DMV]' function does not exist.
Execution complete

I need to be able to see the people that are connected to the cubes.

thanks!
Jul 11, 2016 at 7:34 PM
Not sure if its supposed to wotk that way.

Have you registered the dll and followed the guide?

here is an example that works for me - can you try something similar before trying your mdx query?
'call ASSP.ExecuteDrillthroughAndFixColumns("' 
 + ASSP.GetCustomDrillthroughMDX(
    "NAME([$Date].[Date Key]
    ,[Measures].[Sales Amount]"
   )
   + '")'
Coordinator
Jul 11, 2016 at 8:43 PM
The install instructions are in a link at the bottom of the home page