Create a complex multi-subject area analysis in Oracle Transactional Business Intelligence
Summary Oracle Transactional Business Intelligence (OTBI) is a great reporting tool that is embedded in a lot of Oracle's cloud services - including ERP Cloud, HCM Cloud and many others. A lot of reports and analyses come out-of-the box and you can use the BI tool itself to change existing reports and/or create new ones. Creating a new report is really easy and does not need any IT involvement. It involves dragging and dropping the fields you want analyse and then choosing a nice layout: But what if you want to need to do something much more complex such as combining data from different possibly unrelated subject areas and joining them together? This blog will explain how you can do that and provide you an example. Subject Areas Data in the OTBI repository is grouped in subject areas. You can easily create your own analyses using the pre-defined subject areas. These subject areas are defined as follows in the online documentation : The BI repository defines the columns that are av