Hi,
Following is the scenario. A customer makes a phone call and
requests about three services provided by our company. This
information is stored in the fact table in one row. The fact table
looks like

[(Call ID);(Date);(Svc 1);(Svc 2);(Svc 3)].

"Svc" columns will have 1 or 0 depending upon whether the customer
requested for that service in that particular call.

If the fact table contains two rows with
1) one customer asking for service 1 and service 3
2) second customer asking for all three services
how can i create a service dimension so that I can create output like

"Services"-----"No of calls"
-----------------------------
"Svc 1" ------- 2
"Svc 2" ------- 1
"Svc 3" ------- 2

Thanks
Kri