Counting Customer Transactions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Counting Customer Transactions

I have a question I’m hoping someone will be able to help me with – I’ve been working on it for a while and can’t seem to find an obvious solution. Basically I have a fairly standard transaction fact table, and customers may have made multiple transactions over the selected range. I need to know how many customers made 1 order, 2 orders, 3 orders, etc. As far as I can tell, I’m effectively doing a count of a count. It seems to me to be a fairly straightforward request, however I can’t work out a way to do it in Analysis Services. If someone can help me out or point me in the right direction I would be very grateful Thanks,
Matt
May look athttp://www.sql-server-performance.com/wp_msas_10.asp fyi or might use the PERFMON (SYSMON) to get the transactions/sec counter. 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.
]]>