We are using dot net application for customized reports with MDX scripting. I am new for writing the MDX Quries. Can anyone help for fetching the data from the below question.
 
1)      For each CPKey we have List of patients
2)      For each Patient information available in Patient dim table.
How can I retrieve patient information as a column from Patient DIM table, when I have the CPKey from the dot net application by the MDX?
Expected result set like below
 
PatientID
PatientName< ...

Go to the complete details ...