Concatenate two columns into One

[Steve]

I am using a Cube package. I need to add two columns from the same dimension but different levels (Name and Code) into one column to show 'Name - Code'.

What expression should I use?

Thanks !

[Arsenal]

Why not just do this at the FM level (by concatenating required data items) and then building a dimension off this concatenated data item?
Depending upon the number of records the cube will have, there might be a build time overhead but I feel this would give you a cleaner solution.

Open to suggestions by others.

[Steve]

Whoa ! Got it !

The Long Name and Short Name property works for this. No need to change the cube or FM Model for this.

[Cube].[Heirarchy].[Level].[Name].[Name - Long Name] + ' - ' + [Cube].[Heirarhcy)].[Level].[ID].[ID - Long Name]

[MFGF]

Is this in a List report? If so, you could drag the first item in as a column, press the padlock button to unlock your structure, then drop a text item inside the same column (' - ') followed by the second item. This removes the need for a calculation and so makes the report slightly more efficient.

Just a thought.

MF.

[Steve]

Thanks ! Definately a good thought !

Actually I did this to create this value for a Prompt so I just created a Query and crated a Data Item for this.