Hi Team,
How do we add a new column in the OTBI subject area not present in the existing model?
Currently, it is system limitation. If any of the base table attribute is not available, you can create an idea to bring it in the subject area. Only solution is to create a BIP report in this case.
You can create multiple SA reports with conditions. Please check below document for details on cross subject area report pre-requisites.
Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1)
Thanks.