How to get text data in cell using MDX query

See more:

MDX

Can we get text data in cell using MDX query? Like I mentioned required table result as below:-

I need to have Columns heading's as FName, LName, Address
and Row as Employer's name.
And data should be details of the employee.

	        FName	LName	Address
TestEmployer1	FName1	LName1	Add1
TestEmployer1	ABC	XYZ	Add2
TestEmployer1	FName3	LName3	Add3
TestEmployer2	FName4	LName4	Add4
TestEmployer3	Name7	LName5	Test Address
TestEmployer3	FName6	LName6	Add6