The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

sdayringer's avatar
sdayringer
New Contributor III
3 years ago
Solved

Extract Account's Assigned Plug Account via SQL

Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SEL...
Reports
  • JackLacava's avatar
    JackLacava
    3 years ago

    You're joining on the wrong thing in the PlugAccount subquery. Should be:

    LEFT JOIN Member PA ON MP.DecimalValue = PA.MemberId

     

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

You're joining on the wrong thing in the PlugAccount subquery. Should be:

LEFT JOIN Member PA ON MP.DecimalValue = PA.MemberId