How to calculate frequency of Total Transaction

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

How to calculate frequency of Total Transaction

Author

Topic

cheechwan
Starting Member

11 Posts

Posted - 2007-11-28 : 03:30:15

Dear Experts,

Im currently using SQL Analysis Server 2005, i have built the following cube with dimensions as below:
1) Time(Attribute as below)
- CalendarYear
- CalendarQuater
- CalendarMonth
- DayOfMonth

2) Merchant
- Merchant Name

The two dimension stated above is link to a fact table. A fact table name (Transaction)consist of the following fields:
- Transaction ID
- Transaction date
- Transaction amount
- Merchant Outlet ID
- Customer ID

Let say, if want to filter those customer who have spend more than 3 transaction on the transaction date. How does the calculation look like.

Do u have any sample how to create a calculated command?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources