Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum› Oracle Fusion AI Data Platform Forum

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
32
Views
2
Comments
Sidshah
Sidshah Rank 3 - Community Apprentice
in Oracle Fusion AI Data Platform Forum

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 & AI 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.