I have a query that I need to change so I can concatenate the to columns together. I am an SQL guy and dont know MDX can someone please help
The MDX I have which the system I am using generates
Select non empty HIERARCHIZE(DISTINCT({Crossjoin({
[Sales Items].[Item Code].[Item Code].Members},
{[Sales Items].[Sales Item Name].[Sales Item Name].Members}
)})) on rows,
non empty {[Measures].[Sales Item Quantity]} on columns
From [Sales]
What I am trying to achive is joining the two columns of data together with a '-' inbetween
sales.items.Sales.Item Name + '-' + Sales.Item.Item Code
Example of the output I am looking for is
CMLCAKE DEAL - 000005