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
NickKroppe's avatar
NickKroppe
Icon for OneStream Employee rankOneStream Employee
4 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
4 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
    Valued Contributor
    4 years ago

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

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago