MDX and Concatenation Syntax

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

July 5th, 2013 2:49am

Hello,

Since the issue is about MDX query, please post question on SQL Server Analysis Services forum. It is appropriate and more experts will assist you.

You can refer to the following thread about similar issue:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/aee3126c-edff-4d4f-94b4-de35e4d5c56b/concatenate-mdx-query-fields-into-one-field

Regards,
Fanny Liu

Free Windows Admin Tool Kit Click here and download it now
July 15th, 2013 5:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics