Custom MDX Distinct Count - SQL Server Forums

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 2000 Forums

Analysis Services (2000)

Custom MDX Distinct Count

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-20 : 07:17:32

David Smith writes "We have a cube with the following dimensions and measures:
Dimension called: Card Number
Dimension called: Transaction Type
With Levels: Load, Redeem, Unknown
Measure Called: Transaction Count
Is there a way to write a calculated measure to return the following?
The Distinct count of cards that have between 2 and 4 "load" transactions
and at least 1 "redeem" transaction

Note: We are using Analysis Services 2000, but are planning to move AS2005
soon

Thanks"

spdhiva
Starting Member

13 Posts

Posted - 2006-10-13 : 16:33:28

Use View to Caculate the Count(1) as intNoOfCardCount of the cards by all othet Dim values.
Create a Another Dimension based on your count values from the fact table.
1,
2
3
4

Create a Measure with Distinct functions and Process it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources