Oracle Communities

Oracle Analytics and AI

Child Item

Finding DFF field in HCM OTBI Subject Area

Good afternoon.

We have added values to this HCM table/field, HRT_PROFILE_ITEMS.ATTRIBUTE1 as a DFF that we need to add to our OTBI reports.

We have followed the required steps of checking the BI enabled box, deploying the DFF and running the "Import Oracle Fusion Data Extensions For Transactional Business Intelligence" process. When I search for a field named Attribute1 in the "Workforce Profiles - Person Profile Real Time" subject area I don't find it.

Any help would be appreciated, as we must be missing a step. Thank you!

Find more posts tagged with

OTBI

Accepted answers

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28155/finding-dff-field-in-hcm-otbi-subject-area

Hi @Richard R.

Welcome to the Oracle Analytics & AI Community!

Can you please check if you have followed those steps:

While creating DFF segment, make BI enabled checkbox yes for the segment. Deploy DFF.
Run the "Import Oracle Fusion Data Extensions For Transactional Business Intelligence" process from scheduled process area.
Wait for the process to complete successfully.

Please take a look into the following Oracle document & the post which might be useful.

https://support.oracle.com/knowledgefs?docId=2357136

Unable to see the DFF attribute which are based on Table type value set in the OTBI subject area — Cloud Customer Connect

Hope this help.

Thank you.

Bhaskar Konar

Hi @Richard R.

Here is another discussion which might be a good read to debug the issue.

What is the subject area of Project Definition DFF on OTBI on Projects module? — Cloud Customer Connect

Hope this help.

Thank you.

Richard Kemp-Eyre

Hello Richard R.

When you configured Attribute1 DFF, did you label / name it and/or give it a BI Label? It could be that it has imported in to the relevant subject area but displays as the Name or BI Label that you configured it with.

Rich R.

@Richard Kemp-Eyre, the person that added the DFF says that he didn't add a BI label. The label field is empty.

Bejoylin

@Richard Ribeiro - I am also facing similar issue.

Created a DFF under HRT_PROFILE_ITEMS and used value set of learning module attribute and able to use it in UI.

But, after running the Import Oracle Fusion Data Extensions for Transactional Business Intelligence (successful job), the DFF is not visible in the OTBI areas under Person Profile folder.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/74884#Comment_74884

Hi,

Did you enable the BI enabled checkbox on the DFF attribute level setup?

Thanks.

RVohra

@Bejoylin , did you enable the enable the DFF? Please refer attached screenshot …

Bejoylin

Thanks @RVohra & @MandeepGupta - I have already enabled the same.

Later, found the DFF token in some other folder within the subject area instead of Licenses and Certifications folder.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/75035#Comment_75035

That's good to know.