SQL Server Performance

Drillthrough Problem. Urgent !

Discussion in 'SQL Server 2005 Analysis Services' started by chiall, May 21, 2007.

  1. chiall New Member

    Hi All,

    I have a problem to get the distinct drillthrough record. As we all know, the drillthrough function in analysis services will return the record down to transaction level. Is anybody there know how to get the distinct record based on the return field from drillthrough action. For example, i have 100,000 sales in January 2007. These 100,000 sales is contributed by 50,000 customers. Now i want to know these 50,000 customer details like age, contact no, mailing address and so on. So i am able to analysis from those details. But the problem is, it shows all 100,000 sales records which got lots of duplicated customer details when i drillthrough on customer count. So is there got any solution to only return distinct drillthrough record? Any assit is appreciated. Thanks in advance.

    FYI, i created the drillthrough function in SSAS.

    Regards,
    Ling
  2. satya Moderator

  3. chiall New Member

    Hi Satya,

    Thanks for your input. I have gain some ideas from the posted article link. It shows the drillthrough in SSAS is different with MSAS and it may need to change the database design to cater the correct drillthrough result in SSAS. In instead of doing this, i am trying to use reporting action in SSAS by passing required parameter and generate the result in reporting services. Anyway thanks for your feedback.

    Best Regards,
    Chiall
  4. satya Moderator

    I think there is such drill-through option available in SSRS using SSAS, as suggested you might need to change the design in this case as far as I'm aware of that, you might try contacting MS Support or refer to relevant SSRS Technet/MSDN forums or checkhttp://blogs.msdn.com/bobmeyers/ bob's blog.

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page