Oracle Transactional Business Intelligence

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

OTBI Analysis - Getting DFF meaning instead of the value

488
Views
5
Comments

Content

Hi,

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!

Regards,

Tito

Comments

  • Shakher Sharma
    Shakher Sharma Rank 4 - Community Specialist

    How complex is the OTBI analysis? If it is tabular in nature, you can create a BI Publisher report instead. In the query, you can link Lookup and Value Sets table to get desired result. You can also fetch physical query behind an Analysis easily, so that you don't have to create whole query from scratch. Please let me know if this helps and you need help with fetching physical query behind the analysis.

  • Tmolina-Oracle
    Tmolina-Oracle Rank 1 - Community Starter

    Thanks for your feedback.

    The reason why I am doing it using an OTBI Analysis is because we need to expose some additional assignment fields, including the DFF, on UI embeding the report as detailed on this post: How to embed an OTBI analysis into HCM Cloud UI

    I have embed BI Reports on UI pages before but they long look as good as OTBI Analysis, which is what the customer is asking, so I am afraid I need to continue on that direction.

    Thanks

  • Sricharan Monigari
    Sricharan Monigari Rank 4 - Community Specialist

    Hi Tito,

    In such case, you can use the Logical SQL to modify the OTBI analysis to get the meaning by joining the tables.

    Please refer to the below thread for more info on Logical SQL:

    https://cloudcustomerconnect.oracle.com/posts/be69d9f14b

    https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1918-creating-an-otbi-analysis-from-logical-sql-in-oracle-hcm-cloud-2

    If you follow these steps then you would be able to get the meaning as well in OTBI analysis only instead of going for BIP report and this analysis can be embedded on UI pages seamlessly

    - Sricharan

  • Tmolina-Oracle
    Tmolina-Oracle Rank 1 - Community Starter

    Hi,

    The thing is that there is no subject area where I could get the lookup meaning from so I can't do the join.

    I tried also creating a new analysis from a Direct SQL but I found 2 constraints:

    - Only BI Administrator can run an analysis created as Direct SQL.

    - I can't have prompts/filters so I can't extract just the details for one specific worker on UI.

    Thanks,

     

    Tito

  • Yves Chassein
    Yves Chassein Rank 2 - Community Beginner

    This issue is still there, right? There are no other solutions currently then the mentioned workarounds?