Can I query across multiple subject areas?

Yes, you can create reports that span multiple subject areas if the selected dimension attributes are common across all areas.

For more information, see Guidelines for creating cross subject area reports in Oracle Transactional BI (OTBI). [ID 1567672.1]