Does some Data Source can serve as parameter value for another Data Source

User_Z8Y6M

Summary

is if there a way to populate a parameter for data set X by result of data Set Y (not join)

Content

Hi,

I would like to build a data model with several data sets when one of them is OTBI analysis result from some cloud system.

OBIEE provides great WSDL to define the Webservice data source.

The issue is that I had to get the result by two steps

1. login request to get session_id

2. use session id from (1) as a parameter to executeXMLQuery

I think that (1) can be done as a one-row result of data set based on logon command

My question is if there a way to populate :session_id as a parameter for (2) by a result of (1)?

Thanks,

Ark