InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:48:40 GMT20http://www.sqlservercentral.com/Forums/Topic1253479-2797-1.aspxI'm still fairly new with drillthrough actions. I want to create an action that runs a query and extracts columns from a table which is related by key but for which it's not practical to create a dimension. Is there a way to have a drillthrough query? Say, for example, I have a location dimension and user dimension and I aggregate and show that I have 1500 people living in my region and I want to right-click and drillthrough to a query that takes those associated userID's and pulls back the associated addresses and phone numbers (which is NOT in it's own dimension).Ideas?DonalithThu, 16 Feb 2012 14:55:43 GMTErin Ramsay