Detect customer pattern

#1

I need to write an MDX statement to detect a customer pattern over 4 years.
If they signed up last year for the first time and renewed this year, then
they are a first time renewal, if they signed up 2 years ago and kept
renewing last year and this year, then they are a multi-year renewal, if they
skipped last year but renewed again this year then they are a Lapsed Renewal,
and so forth. This would be easy if you could put an "and" in an iif
statement, but I haven't seen any examples of that. What other MDX functions
should I investigate to accomplish this task?

#2

Look into the GENERATE function; and if you don't have it -- get "MDX
solutions" by George Spofford -- he does an excellent job of shedding some
light on the esoteric nature of MDX.

HTH

Jim

"bhorwatt" wrote:

Quote:

I need to write an MDX statement to detect a customer pattern over 4 years.
If they signed up last year for the first time and renewed this year, then
they are a first time renewal, if they signed up 2 years ago and kept
renewing last year and this year, then they are a multi-year renewal, if they
skipped last year but renewed again this year then they are a Lapsed Renewal,
and so forth. This would be easy if you could put an "and" in an iif
statement, but I haven't seen any examples of that. What other MDX functions
should I investigate to accomplish this task?

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

Detect customer pattern

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

Detect customer pattern - 03-04-2005 , 09:15 AM

RE: Detect customer pattern - 03-04-2005 , 02:39 PM