I am using Reporting Services to show my OLAP cube data.
I have my aggregates ready in cubes. i have to show to the user the requested columns (passed as parameters to the report).
Now, i can have dynamic MDX query to query the data. But i dont know how to bind the dynamic field names in reports. (something like evaluating the field or colum index.)
Atleast i know that i will be always showing two columns.
Maybe i can fix my column names by using member, but unfortunately i have to show 2 columns from the same dimension. there any way to do it?
Thanks in advance.