Concatenate columns Code and Description in custom Subject Area

Sidshah

We have a custom Subject Area with 24 dimensions in Production.

In DW hierarchy table, we have two columns "Code" and "Description.

There is a new requirement from Business to concatenate "Code" and "Description".

Since we have huge data in this Subject Area, it is not feasible to concatenate in OAC presentation layer.

The option we have is to add a new column which will concatenate "Code" and "Description" and populate the data in this new column.

But since we have 24 dimensions and multiple hierarchies in the dimension, it is a large development work in our Integration as well as ADW.

Any other options exists ?

Sidshah

any one ?