Building MDX query

[Guest_imported]

How can i create the where clause with clauses from the same dimension.
Ex:
Select ....on columns
... on rows from cube
WHERE
[Store].[All Stores].[Canada],[Store].[All Stores].[USA]

what is wrong or what i need to do?

marco.rosas@ine.pt

 

[hilbrink]

What exactly are you trying to accomplish in the where-clause? And what do you mean with "clauses from the same dimension"?

The WHERE clause is a filter that defines the conditions each row in the source tables must meet to qualify for the SELECT.
Example:
SELECT ......
FROM store.[all stores].canada, store.[all stores].USA
WHERE
store.[all stores].canada.productID = store.[all stores].USA.productID