General OBIEE

Get Involved. Join the Conversation.


    Tito Molina
    OTBI Analysis - Getting DFF meaning instead of the value
    Topic posted March 20, 2018 by Tito MolinaGreen Ribbon: 100+ Points, last edited March 22, 2018, tagged Analyses, Core HR, Fusion, OTBI 
    671 Views, 4 Comments
    OTBI Analysis - Getting DFF meaning instead of the value


    I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the system containing meaningless codes as values. The DFF then store values but on UI, they always show the meaning. However, the OTBI analysis extracts just the value but not the meaning.

    I found on Fusion Applications OTBI (Reporting) FAQ For Descriptive Flexfields (DFF) (Doc ID 1503455.1) a workaround that requires to manually define the meaning for each value, which is quite difficult to maintain over the time so I was wondering if anyone knows another way of managing my requeriment.

    Many thanks in advance!