Call OBIEE agent using Webservices.Pass report prompt

7688438

Hi All, I have successfully called OBIEE Agents using Webservices. OBIEE Agent has 1 report as delivery Content and report has one prompt. Now I would like to pass this prompt value from a webservice.How can i pass values to OBIEE agent report prompt from 3rd party. Below are the details:- Web service name: ibotService .

Thanks,

R

[Deleted User]

What version? What platform? Etc etc etc etc.

Gianni Ceresa

The method definition is quite explicit: path and sessionID.

You can't pass anything else, so don't expect to be able to pass any prompt value in that way.

You would need to save the value directly in the agent before to execute it, you could do that by web services calls editing the agent first etc.

7688438

Gianni, I can't save the static value in the agent.because values are dynamic and has to pass it from 3rd party application based on user selection. Below are the same report prompts.

Gianni Ceresa

7688438 wrote:I can't save the static value in the agent

If you want and need, you are going to.

Be creative: you need a value, the method doesn't have an option to send it. What are you going to do? Redevelop the whole OBIEE web service interface? I don't think so.

But you can implement everything on your side: do a call to duplicate the agent with a random name, edit it to set the values you need in that given execution, execute it, delete it.

This is a simple way to avoid concurrence issues and have agents executing with your value.

You can be creative and make it happen or just stick to "nope, the method doesn't have that option".

7688438

Giani, Thanks for your inputs.I have total 350 input values. How many agents i have to create 350??. Editing agent with webservices,I do not see it in webservices List.

Gianni Ceresa

It's a process, like a transaction, you don't keep them: your process will do all the actions one after the other.

Don't get me wrong: you don't have to do it. I'm just giving alternatives for your need.

An agent is a catalog object, it can be edited and duplicated with the catalog methods.

7688438

Gianni, Does that means i have to create 350 agents and pass 1 prompt value to 1 agent.Call 1 agent from other? Some thing like. Agent 1-->Calls Agent 2-->Calls Agent 3......etc...350 or Do i have to schedule 350 agents??. 1 prompt value in 1 agent. Please clarify. I am trying to achieve with 1 agent by passing prompt value dynamically from 3rd party application using webservices. Thanks, R

Gianni Ceresa

You don't have to do anything, you can do many things.

You must find alternative approaches, there are various options.

You can create 360 agents and chain them, or not.

You could also develop a process: duplicate agent to temporary one, edit temp agent, execute temp agent, delete temp agent.

Or not.

You have to find alternatives to do what you need to do, or go back to your boss and tell it isn't possible and stop it there.

I can hardly be more explicit without coding it (but I'm not employed by your company, so not my job).

7688438

Gianni, I am trying the find the solution for our scenario.If you think there is alternate way,Please let me know. How can i pass values to agents dynamically? Thanks in Advance. R

Gianni Ceresa

7688438 wrote:Gianni, I am trying the find the solution for our scenario.If you think there is alternate way,Please let me know. How can i pass values to agents dynamically? Thanks in Advance. R 

"the" solution doesn't exist. There are various possible solutions as it's workarounds.

I posted it multiple times, it will not change much to post it again and again. If what I wrote make no sense for you, I don't really know how to write it in a different way if it doesn't make any sense, sorry.

Let's see if somebody else has other ideas or can express it in other words which will maybe be more clear for you.