In a MDX query, I would like to slice on 2 dimensions in the following
way:
The sales cube in the sample OLAP database I need to retrieve the Unit
Sales for Gender=Male or Marital Status=Married.
To obtain the results without the above slice, I query the cube as
WITH
SET __CRYSTAL_SET_ON_AXIS_0__ AS ' { [Measures].[Unit Sales]
} '
SET __CRYSTAL_SET_ON_AXIS_1__ AS ' { [Store].[Store
Country].AllMembers } '
SELECT
__CRYSTAL_SET_ON_AXIS_0__ ON COLUMNS ,
__CRYSTAL_SET_ON_AXIS_1__ ON ROWS
FROM [Sales]

If I add
WHERE
( [Gender].[Gender].&[M], [Marital Status].[Marital Status].&[M]
)
the results are an intersection of the set with Gender=M and Marital
Status=M. I am interested in the union.

Can someone suggest a way to query for a union in the where clause?
The actual number of dimensions in the cube I am working on is around
8, and hence would be having to solve the above problem for a union of
members from around 8 dimensions.

Thanks
Yash

Hi Yash,,

I am new in MDX

I have problem on Union().

I try to union two different dimensions together, but it is not worked. MDX
shows me "unknown error". so please advise if Union() can be used to union
two sets from two different dimensions.

thanks


"Yash" wrote: