Oracle Fusion Data Intelligence

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
26
Views
1
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.