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