Concatenating dimensions to create "new" dimensions

May 17, 2011 at 5:19 AM


I'd like to be able to concatenate the values from two fields, without doing any "proper" arithmetic on them, using the OLAP Extensions.

For example, I have a dimension called "Business Name" and another one called "Business Code".  They both contain text (e.g. Mike's Bikes, MB345).

I would like to be able to do something like:

[Business Name] & " " & [Business Code] and, for the above example, the result should be "Mike's Bikes MB345".

Is this something that can be done through the OLAP extensions, or is this something that has to be defined at the Analysis Services level?



May 17, 2011 at 7:43 PM

I believe that would have to be done by the OLAP developer in your cube.

Marked as answer by furmangg on 6/10/2014 at 3:50 AM
May 18, 2011 at 12:54 AM

Thanks, furmangg, I appreciate your reply.