I am trying to join two datasets one from MDX(Main set i am using in my report) and one from SqlServer. I have joined the dataset from sqlserver with a parameter. I am using this parameter to create a calculated measure in my MDX set and then use the
main dataset(MDX) in the report.
This is the expression I am using to get the calculated field :
I am able to get only the first value in this join and this value is getting repeated in all the bars.
when i am trying to use split join then i am getting an error : The value of '1-dimensional array of string' cannot be converted to 'string'
Expression i am using :