Hi to all,
I know I can make a Union with sets from the same dimension:

SELECT
{[Measures].[Warehouse Sales]} ON COLUMNS,
UNION(
{[Store].[USA].[WA].Children},
{[Store].[USA].[OR].Children},
ON ROWS
FROM Warehouse


but can I make a union of sets from different dimensions? The following
query raises a Calculation error - unknown error:

SELECT
{[Measures].[Warehouse Sales]} ON COLUMNS,
UNION(
{[Store].[USA].[WA].Children},
{[Product].[Food].Children})
ON ROWS
FROM Warehouse

The reason for this is that I need to present both data on the same page,
and I'm trying not to run 2 different queries.

THX

You can only use Union on sets that have tuples with the same dimensionality,
that is, the same dimensions in the same order.
From what you describe, using two queries would probably be the best practice.
Still, you could use a Union of crossjoins such as:

Union(
{ {[Product].[All Products]} * [Store].[USA].[WA].Children} ,
{[Product].[Food].Children} * { [Store].[All Stores] } )

to retrieve the data you want in one query.

HTH,
Brian
www.geocities.com/brianaltmann/olap.html



"Moco" wrote: