First Purchase measure/dimension?

#1

You could implement the logic in a CASE statement (or UDF)
in your fact table. You will have to make your fact table
a view to do this if it is already not one.

Quote:

-----Original Message-----
Various types of analysis at our company revolves around
the notion
of "did the client make their first purchase in _______".

Example:
I want to look at all clients that made their first
purchase of product A in
2002 and then see
how much of product B they bought in 2003.

However the definition of first purchase varies, some
people are looking at
first purchase
of anything (All products) and some people are looking at
first purchase of
a specific product and
some people even put criteria like > $1000 of a product
in the mix.

Any help on how to approach this type of problem is
appreciated. Looking
for something
generic that would work for everyone if possible.

Thanks in advance,
Mark

.

#2

Ok I do use a view and doing case logic is easy in the view but how do I
make this thing flexible? Your answer is a bit vague.

I'm sorry I know this is a tough question,
Mark

"Andrea Worley" <k_rage (AT) hotmail (DOT) com> wrote

Quote:

You could implement the logic in a CASE statement (or UDF)
in your fact table. You will have to make your fact table
a view to do this if it is already not one.

-----Original Message-----
Various types of analysis at our company revolves around
the notion
of "did the client make their first purchase in _______".

Example:
I want to look at all clients that made their first
purchase of product A in
2002 and then see
how much of product B they bought in 2003.

However the definition of first purchase varies, some
people are looking at
first purchase
of anything (All products) and some people are looking at
first purchase of
a specific product and
some people even put criteria like > $1000 of a product
in the mix.

Any help on how to approach this type of problem is
appreciated. Looking
for something
generic that would work for everyone if possible.

Thanks in advance,
Mark

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

First Purchase measure/dimension?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

First Purchase measure/dimension? - 07-23-2003 , 01:58 PM

Re: First Purchase measure/dimension? - 07-23-2003 , 02:39 PM