SQL Server Performance

Drill-Through Access to Relational Tables

Discussion in 'SQL Server 2005 Analysis Services' started by spalding, Feb 6, 2007.

  1. spalding New Member

    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
  2. satya Moderator

    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.

Share This Page