Drillthrough Problem. Urgent ! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Drillthrough Problem. Urgent !

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
Not sure much of it but I hope you might findhttp://sqljunkies.com/WebLog/davescube/archive/2006/12/02/25828.aspx this as useful. HTH 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.
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
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.
]]>