Change your analysis to return the 2 years instead of using AGO or a column representing that. It's about how you developed your model and the analysis you build.

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…

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…

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 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…

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.

Jonathan Chan gmg wrote:My goal is to fill the Null values with the first/only NOT NULL values in "Raw Materials" column per each product i.e A, B and C in Product column. Do those lines really have NULL has a value? NULL is very different than empty, NULL being a value by itself while if empty there is just nothing.

But what is the target SSL certificate like? Working in your own browser doesn't mean it isn't a self-signed one, you maybe just installed (or somebody for you) the self-signed CA one in your browser and done.

3487083 wrote:In order to make the HTTPS call, i think we need to import the certificate in OBIEE server. Did you try and you get an error (screen or log) telling you there is an issue with certificates? If the target host has valid SSL certificates, there is not need to import IMHO, they will be accepted. If your target…

The "Invoke an HTTP request" action can perfectly deal with a HTTPS request, just enter a URL with https instead of http. In the name of the action they can't really express all the possible URLs you can request or the name of the action would take the whole screen. Does the URL you are calling use HTTP Basic…