Concat dimension attributes 1

[wawanz]

Hi all, I'm using SSAS 2005. How do I concatenate two attribute values? For instance, I have two columns: Customer ID="001" and Customer Name="Mike". I want to make it display as one level in the hierarchy. Something like "Mike (001)".

Thanks guys.

 

[johnherman]

You could do that during the dimension build process. If Mike is always 001 and 001 is always Mike, you can associate the code with the description field, also during the dimension build. I am not aware of any way to create "calculated attributes" similar to the method of calculated measures.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[MDXer]

IN your Data SOurce View you can add Calculated columns you can create a Column in the DSV that is ColA+ColB. The alternative is if you r are using a view as the source for your data you can add it to the view.


THe additon of the DSV is a huge gain in functionality over what AS2K offered.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck