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
NickKroppe's avatar
NickKroppe
Contributor
3 years ago

I would suggest putting the query against the application database in a dashboard dataset rule and then creating your own custom table on the fly with the correct usernames.  You can convert the user keys to user names by leveraging our ability to execute BRApis within the dashboard dataset rule, in this case, consider the BRApi.Security.Admin.GetUser function. This may perform better than performing multiple queries and intensive joins. 

There's an example of this exact concept in the rules chapter on pages 230-231 in the OneStream foundation handbook.

 

Regards,

 

Nick Kroppe

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

    Hi, Nick.

    Once the dashboard dataset rule is written, how do you assign it to the data adapter?

     

     

    Thanks,

    Bil

    • ckattookaran's avatar
      ckattookaran
      VIP
      3 years ago

      Use the BusinessRule method, and then the format is {BusinessRule}{FunctionName}{Parameter}