When doing a SQL query in a Data Adapter, is it possible to have a Join between the Framework and Application tables?

Answer

• Yes, it is possible but requires the use of a Dashboard Data Set Business Rule
• The OneStream Integration team has done some custom solutions that use this…you could reach out to them for assistance via a Support ticket, though the time may be billable.

Source: Office Hours 2020-09-27 Partner Enablement