Hi,

I am wondering if this is possible... I have a cube concering the sales of
cars. The cube contains two dimensions

- Manufacturer
- Color
- Size

And two measures

- SalesPrice
- PurchasePrice

Now... I want to be able to select the cars that come from one or more
specific manufacturers OR have one or more specific colors. The way Analysis
Services usually works, if I pick one or more manufacturers and one or more
colors, I end up with the cars that are from these specific manufacturers
AND have these specific colors.

Is it possible?

Thanks in advance!

/Michael

Can you give an example of the query results you want?

Here is an initial idea, don't know if this applies:
Set [Clrs] as '{[Red],[Green],[Blue]}'
Set [Combos] as 'Except(CrossJoin(
[Manufacturer].[Brand].Members,[Color].[Hue].Members),
CrossJoin(Except([Manufacturer].[Brand].Members,[Mnfs]),
Except([Color].[Hue].Members,[Clrs])))'

Select [Measures].Members on Columns,
[Combos] on Rows

From AutoSales

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In addition to Deepak's comments, you might also be interested in
reading the following thread:

http://groups.google.co.uk/groups?hl...%3D10%26sa%3DN

HTH,

Chris

"Michael Barrett Jensen" <mbiwj001 (AT) sneakemail (DOT) com> wrote

Thanks Chris... That is an extremely enlightening thread! :-)

/Michael

"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote