MDX query on a dimension member

Is it possible to query an analysis services dimension using MDX select syntax, if so

can someone list a example?

For example there is an employee dimension with Employee Name as the member name

and Employee ID as the member property. I want to write an MDX query to return the member name

if I have the member property.

Thanks

Umesh

Yes. Something like:

select { ... } on 0
from [$Your Dimension Name]

You can attach SQL profiler to the server and browse a dimension from BI Studio or SQL Server Management Studio. The profiler will trace the queries we send.