MS SQL Server OLAP - AS Cubes Scenario

Author

AS Cubes Scenario

Varadaraj Bhat

2006-01-30, 9:26 am

I have this scenario in my application . Can anyone provide me the solution
to this.

Few KPIs like Number of new customers are to be viewed across different
dimensions like Customer Group and Items. These KPIs are not cumulative
across both the dimensions and hence cannot be shown across both the
dimensions in the same scorecard.

For Example, Let’s say a customer is a new customer for the items I1, I2 and
I3 for the year 2005.
When analyzed across items,
Item Number of new customers
I1 1
I2 1
I3 1
Then the total number of new customers would be 3 where as there is only one
actual new customer in that Customer Group.
Any help would be appreciated
regards
varadaraj

Deepak Puri

2006-01-30, 8:24 pm

Hi Varadaraj,

A couple of options come to mind, depending on the underlying data
schema:

- Distinct Count measure on a CustomerID field

- Many-Many relationship between Customer and Item

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links