How do I concatenate string literals such as the below where report_month is a number and I want to append a more descriptive string to the front of it? --With SET test as --'Report Month ' + [Report Date Dimension].[report_month].[report_month]<br/> SELECT [Report Date Dimension].[report_month].[report_month] ON COLUMNS, [Product Type Dimension].[Product Type].[Product Type] ON ROWS FROM [Data Warehouse] WHERE([Measures].[Number Units])

bump, still struggling with this...

Hi AaronLST, To this question, I think it can be achieved in MDX, you will get a better support if you post this MDX in Analysis Services forum http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/threads Just from the Report level, I think you could make use of MonthName function to convert the number to more descriptive name. You could also add some string at the front of the field. If I misunderstand you please feel free to let me know. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.