Web service and initialization block

717256

This is another question so I'm creating another thread.

I created an initialization block in OBIEE, because I use SSO and I need to check that certain server variables are correctly passed.
The block basically does a SELECT :MY_VAR from specific_table, MY_VAR being a variable taken from a cookie.

I want to know if this initialization block will be executed when a session is created via web service.

If so, then my web service call will fail.

So again, are initialization blocks executed when creating a session via web services?
If so, what are the solution to conciliate both?
thanks

717256

any idea?
thanks

717256

help?

rmoff

I don't know the answer for sure, but if I had to guess then I would say that the init block would be executed. This is because it is at the BI Server / RPD and whether the session on the BI Server is created as a result of a web service call or interactive Answers user, it's still an ODBC call (in this case from sawserver, but could be admin tool, etc) into BI Server.

Let us know if you find out for definite!

rmoff

did you try this out and find an answer for sure?