All posts on OTBI Analytics
Do you know how to pull the OBTI Usage and Performance metrics from an environment? What data does these reports generate? How much of history can be reported using these subject areas? Read on to know more details.
Do you know that you can fetch the HDL Imports and HCM Extract Run Details using OTBI from 20D? Read on to know more details.
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.
Do you know how to get Physical SQL Query for an OTBI Analytics? What is nqquery.log and how to get it for an OTBI? Read on to know more details.
Do you know the mapping of subject areas to the database table and columns? Read on to know more details.
Do you know how to migrate/import OTBI analytics using catalog file, XML file and Logical SQL? Read on to know more details.
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…
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…
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…