Click here to Skip to main content
15,443,430 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900