is there any way to specify a SET in the WHERE clause, other than using AGGREGATE() function?
I'm using AGGREGATE to accept parameters from a web client and limit the query output.
My sets can be fairly large, i.e. they contain hundreds of members and AGGREGATE performs poorly.

for example, I construct a set similar to the following:
SET ABC AS {[dimensionA].[levelB].[key1], [dimensionA].[levelB].[key2], [dimensionA].[levelB].[key3].... [dimensionA].[levelB].[keyN]

and then define a member as follows
MEMBER dimensiona.DEF AS 'AGGREGATE(ABC)

MDX statement is as follows:

SELECT blah on COLUMNS, blah1 on ROW
FROM some_Cub
WHERE (dimensiona.DEF

please help! thanks.

The only optimization that comes to mind is using NECJ():

SET ABC AS {[dimensionA].[levelB].[key1], [dimensionA].[levelB].[key2],
[dimensionA].[levelB].[key3].... [dimensionA].[levelB].[keyN]}
MEMBER dimensiona.DEF AS 'AGGREGATE(ABC)'

-- MDX statement is as follows:

SELECT
NonEmptyCrossJoin(blah, ABC, 1) on COLUMNS,
NonEmptyCrossJoin(blah1, ABC, 1) on ROWS
FROM some_Cube
WHERE (dimensiona.DEF)


- Deepak

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