MDX QUESTION: Can IIF() be used in set outputs?

[GrandMauler]

So here's the scenario:
Say I have the following MDX Script

SELECT [Measures].[Sales] ON COLUMNS,
[DIM VEHICLE].[CARS].CURRENTMEMBER ON ROWS
FROM [SALES_CUBE]

But then my boss comes in and says, "Hey GrandMauler... we need the results put into terms of Corvettes and Non-Corvettes!"

How do I accomplish this in MDX without having to create a whole new dimension that has just Corvettes and Non-Corvettes?

 

[MDXer]

Without really sitting down and working through some code my first shots would be to try and use named members and named sets. Or if you are using SSAS 2005 some form of attribute hierarchy. The trouble with so many items like this one is that every "I NEED" can have a seperate best method. if you can Narrow down to this Business Case or need then the answer is probably much easier to come up with. Also lnowing what tools the user has to access the cube may help as each toolset has it's strengths and weaknesses.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck