Re: Using NOT in a Slice
From: Tom Chester (publicNOSPAM_at_tomchester.net)
Date: 03/23/04
- Next message: DanO: "Calculated Member"
- Previous message: Michael Vardinghus: "Default member - filtrering member properties"
- In reply to: Aaron Relph: "Using NOT in a Slice"
- Next in thread: Aaron Relph: "Re: Using NOT in a Slice"
- Reply: Aaron Relph: "Re: Using NOT in a Slice"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 09:11:30 -0800
Hmm. It's doable (on the backend) if the only products you care about are A
and B. However I presume there is also C-X, yes?
public @ the domain below
www.tomchester.net
"Aaron Relph" <aRelph@nospam.com> wrote in message
news:uqNWFoLEEHA.1128@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I want to be able to answer the question:
>
> Show me all the customers who bought Product A but didn't buy Product B.
>
> How do I model this in AS2K? My fact table is at transaction level, and
has
> a customer and a product dimension. I want to be able to answer this
> question using a pivot table - not an MDX Query.
>
> Thanks
>
>
- Next message: DanO: "Calculated Member"
- Previous message: Michael Vardinghus: "Default member - filtrering member properties"
- In reply to: Aaron Relph: "Using NOT in a Slice"
- Next in thread: Aaron Relph: "Re: Using NOT in a Slice"
- Reply: Aaron Relph: "Re: Using NOT in a Slice"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
