All posts on OTBI Analytics

OTBI Direct Database Query feature removal and fix Obsolete

In one of the earlier posts Direct Database Query, we saw how to use the Direct Database Query feature of OTBI analytics. This feature has been removed from 19A, so if you have upgraded or planning to upgrade to 19A, remember that the reports created using this feature will not be supported post upgrade. Oracle has suggested moving these analytics…

Continue ReadingOTBI Direct Database Query feature removal and fix Obsolete

How to access flexfields in OTBI Subject Areas?

In this article we will see how to access the Flexfields in OTBI subject areas. If you are new to flexfields then check this article to get basics of flexfields Flexfields Introduction When we create flex field segments, there is an option to have them enabled in BI, if we enable that check box, then the segments can be accessed in…

Continue ReadingHow to access flexfields in OTBI Subject Areas?

SQL to fetch 200+ rows – Direct Database Query – Obsolete

This article is obsolete now as Oracle removed Direct Database Query option. Please check out the alternative to run adhoc queries. https://fusionhcmknowledgebase.com/2020/09/sql-developer-like-tool-for-oracle-cloud-for-free/ When we create a Data Model using SQL Query, the max number of rows that we can fetch using the Data Model is only 200 rows unless we create a layout, tag it to data model and run…

Continue ReadingSQL to fetch 200+ rows – Direct Database Query – Obsolete