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 Reading OTBI 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 Reading How to access flexfields in OTBI Subject Areas?

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

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 the report. Many a times, we would need to run queries on ad-hoc basis and need to get the complete output (More…

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