Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Concatenate columns Code and Description in custom Subject Area

Received Response
23
Views
2
Comments
Sidshah
Sidshah Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

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 ?

Tagged:

Answers

  • Sidshah
    Sidshah Rank 3 - Community Apprentice

    any one ?

  • Caroline Blanchard
    Caroline Blanchard Rank 6 - Analytics Lead

    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.