Drill-Through Access to Relational Tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Drill-Through Access to Relational Tables

In SSAS 2005 the drill through action only allows you to view attributes and members in a cube. If you have a dengenerate column in your fact table you must set it up in as an attribute of a dimension before the drill-through will recognize it. I am trying to work around this problem by writing a query out to the relational tables, but don’t see how I can wire this functionality into an SSAS action. If anyone knows how to do this, could you please let me know. Thanks
YOu can function using SSRS or SSIS in SSAS, I’m not able to understand what you want to achieve, sorry. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>