milani_lucie
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].[Cu stomer Name]} ON COLUMNS,
NON EMPTY {[Dim Products].[Hierarchy].[Pro duct 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
I am executing the following MDX query but i am getting an error:
SELECT NON EMPTY {[Dim Customers].[Hierarchy].[Cu
NON EMPTY {[Dim Products].[Hierarchy].[Pro
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.