Oracle Transactional Business Intelligence

OTBI Analysis - Getting DFF meaning instead of the value
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
-
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.
-
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
-
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
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
-
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
-
This issue is still there, right? There are no other solutions currently then the mentioned workarounds?