SSAS Drillthought action to a query

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply