Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Drillthought action to a query Expand / Collapse
Author
Message
Posted Thursday, February 16, 2012 2:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:58 AM
Points: 546, Visits: 1,061
I'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?

Donalith
Post #1253479
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse