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 ?

Caroline Blanchard

We have this same business requirement. We're currently trying out concatenation through data augmentation then surfacing in the semantic modeler to hopefully improve the performance of our concatenated segments. We were simply just concatenating at the semantic model extensions level and then putting all of those into subject areas, but the performance has been too slow currently. Either of those two options may work well for you.