Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
3 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
adykes's avatar
adykes
New Contributor III

Hi Krishna, thanks for your response, it is very helpful. I am new to Dashboard Data Set BRs and am wondering how would you go about calling this function in a Data Adapter? Thanks

Krishna's avatar
Krishna
Valued Contributor
3 years ago

Hi Adykes - here we go

{BRName}{Datasetname}{Name1=Value1, Name2=[Value2]} and if you do not have any parameter make it as {}

 

Hope this helps.

 

 

  • Krishna's avatar
    Krishna
    Valued Contributor
    3 years ago

     

  • adykes's avatar
    adykes
    New Contributor III
    3 years ago

    Thank you so much! And thank you for the fast response as well.