how to write subqueries in MDX
In SQL it would be something like this
CREATE PROCEDURE sp_proc
@param1 varchar(55)
as
Select id,name from table1
where id in(
SELECT distinct e_id
FROM table2
WHERE field=@param1)
go
HOW TO IMPLEMENT THIS FUNCTIONALITY IN MDX
please help. URRRGENT