Oracle Analytics and AI

JacoG

We have setup Context DFF's within the Enterprise Contracts Module. Next we have created an OTBI report and added the DFF's into the report.

The DFF columns are showing multiple times, since they technically different fields I assume. Is there a way to combine these columns into one column?

Below an example:

Bhaskar Konar

Hi @JacoG,

Welcome to the Oracle Analytics & AI Community!

If your requirement is simply to display a single column in the analysis, one option is to create a custom column using a column formula. Depending on your requirement, you can either:

• Concatenate the DFF columns if you want to display the values together in one column, or
• Use a conditional expression (for example, CASE or IFNULL) to return the first populated DFF value, if only one context is expected to contain a value.

The following post demonstrates how to create a calculated column by concatenating multiple columns in OTBI, which may be helpful:

How create a column by concatenating multiple columns in otbi — Cloud Customer Connect

Hope this help.

Thank you.