Dear, I m write MDX query.we get all information which customer name "Ly Le" OR Customer Country Name "China".
But this query get Error:
Members belong to different hierarchies in the function.
SELECT NON EMPTY
{
[Measures].members
} ON COLUMNS,
NON EMPTY
{
--[Customer Name].members
[Vendor Name].members
} ON ROWS
FROM CB_AnalysisTest
WHERE
{
([Customer Country].&[China]),
([Customer Name].&[Ly Le])
}