Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
4 years ago

Join Framework table data to Application table data using SQL

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user...
Data Integration
MarcR's avatar
MarcR
VIP
4 years ago

Hi Tom,

I tried this last month but OneStream confirmed that this is not possible in the current Azure Cloud. I first run the query on the framework to a datatable and then join that one with the application table. It’s a 2 step approach but works fine.

Marc

Tom_R's avatar
Tom_R
New Contributor III
4 years ago

Hi Marc,

What did you use to join the two tables?

Thanks,