I have a table in a SQL Server 2000 database containing web page requests
like this:

LogTime UserId
8/3/2005 0:32 f2128966-2150-4b40-8110-f225400f6a19
8/3/2005 0:15 cdf8e91f-dd44-47e8-8761-27ff5989240e
8/3/2005 0:14 cdf8e91f-dd44-47e8-8761-27ff5989240e
8/2/2005 23:56 87c2f0d2-c2fa-4659-92c7-513558d21ad7
8/2/2005 23:55 87c2f0d2-c2fa-4659-92c7-513558d21ad7

Now I would like to use Analysis Services to create a cube to view the
number of unique users over time (month, day, hour etc.).

I have no problem creating a cube to view the number of page requests over
time, but how do I define it to get the number of unique users?

Olav

Use "count"

example from my calc measure, count of unique sold articles:

count ({[measures].[Sales Retail]} * descendants
([Article].[Tree].currentmember, [Article].[Tree].[Article
Description]),excludeempty)

Ramunas

"Olav Tollefsen" <x@y.com> wrote

I didn't get how your measure Aggregate Function relates to my table and how
it ensures that it only counts the distinct rows.

I tried to use the Aggregate Function "Distinct Count" on my UserId column
when creating the measure, but the menu option for "Distinct Count"
disappeared when I selected the UserId column. I have a numeric column and
then the "Distinct Count" was available for that column.

Why isn't the "Distinct Count" available for a column with a varchar
datatype?

Olav

"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote

Limitation of AS2K. It is possible to do with AS2005.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Olav Tollefsen" <x@y.com> wrote