Drillthrough to Relational Database

• RonKyle

  SSC-Dedicated

  Points: 31539

  More actions

  March 17, 2017 at 1:30 pm

  #321769

  I've read in a couple of places that it's possible to drill from SSAS to the underlying relational database without that data being in the cube with the aid of the ASSP component.  I've attached the diagram from one of the articles. 
  
  Unfortunately the article itself is far too general and doesn't provide any idea of how to use the ASSP component.  Another article says "you simply setup a rowset action and define the expression that calls the stored procedure an parses the output of ASSP.CurrentCellAttributes() function  as the procedures parameter from that codeplex CLR proc." 

  Apparently this is so simple that it doesn't even justify a code sample.  I, however, haven't even been able to get the simplest query to work, a straight SELECT statements, let alone anything that takes the current tuple and puts it through a program to determine the TSQL equivalent.  Does anyone have any code samples that they would be able share?

  Thanks,