All posts on OTBI Analytics

Information on Subject Areas and List of Seeded BI/OTBI Reports

  • Post published:September 24, 2020
  • Post category:OTBI Analytics
  • Post comments:0 Comments
  • Post last modified:September 24, 2020
Information on Subject Areas and List of Seeded BI/OTBI Reports
Information on Subject Areas and List of Seeded BI/OTBI Reports

Do you know where to find the list of all subject areas and the roles required to access them? Do you know how to get the list of all seeded BI/OTBI Reports? Read on to know more details.

Continue Reading Information on Subject Areas and List of Seeded BI/OTBI Reports

OTBI Direct Database Query feature removal and fix – Obsolete

OTBI Direct Database Query feature removal and fix – Obsolete
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?

  • Post published:January 24, 2019
  • Post category:OTBI Analytics
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
How to access flexfields in OTBI Subject Areas?
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

  • Post published:January 19, 2019
  • Post category:OTBI Analytics
  • Post comments:10 Comments
  • Post last modified:September 8, 2020
SQL to fetch 200+ rows – Direct Database Query – Obsolete
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 Reading SQL to fetch 200+ rows – Direct Database Query – Obsolete