I have 3 dimension in the cube. I want to select dimension id and dimension desc with measures or without measure using mdx query.

For example i have region,product and value_center diemnsion

The query should be like this,

select region_id,region_desc, product_id,Product_desc,value_center_id,
value_center_desc ,Measures1,measures2
From <CUBE>

I need mdx query like above query.

Can anyone give solution for this?

Thx,
selva