Link to home
Start Free TrialLog in
Avatar of milani_lucie
milani_lucieFlag for United States of America

asked on

Need MDX query help for "OR" condition on different hierarchies ....

Hi,

I am executing the following MDX query but i am getting an error:

SELECT NON EMPTY {[Dim Customers].[Hierarchy].[Customer Name]} ON COLUMNS,        
                 NON EMPTY {[Dim Products].[Hierarchy].[Product Name]} ON ROWS
FROM [ADOMDDBCube]
WHERE  { [Customer Name].[Mike], [Product Name].[Pant] }

Error
====

Executing the query ...
Members belong to different hierarchies in the  function.
Execution complete

Can you please FIX this MDX query ? Appreciate your help !

Thanks
ASKER CERTIFIED SOLUTION
Avatar of RWrigley
RWrigley
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial