05-31-2022 10:42 AM - last edited on 05-24-2023 12:06 PM by JackLacava
Hi community
We are using Method Type CertificationForWorkFlowUnit in a data adapter for creating a Certification report
This Method Type provides 3 data sources (as you see in the screen):
Currently, we have Profile Name, Question Name, etc in columns but all these fields are part of CertificationResults DataSource.
We are trying to include UserName filed column on Certification Result Dashboard, but we can’t because this line is part of another DataSource: CertificationResult_SignOff.
Is there a way to include this Username Field? With a Join between data sources or another alternative?
Thanks
06-01-2022 09:19 AM
Hello,
The method query is a kind of SQL query build in OneStream for you. Now, if you do not see the value anywhere in the default method query then you should go back to SQL.
It is more challenging obviously, because that means that you have now to build your own SQL query. You can use JOIN like you suggested and put this into your data adaptor.
But has you can see, it is totally customized... and it is the case you are in.
If it helps, please give a kudo