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…

If it's integrated with LDAP your users aren't in OBIEE, and group membership is managed where the users are: in LDAP. Ask the LDAP admins for that. OBIEE simply read the status of LDAP at a given time (when requested) and cache it for a short time to simply speed up operations.

1c222b3b-23d1-4e03-8869-f161ede6fa39 wrote:is it possible to migrate the reports generated from obiee to PowerBI? Kindly guide me through the process. Understand the business logic of the analysis, identify the sources involved, get those sources into PowerBI, replicate the business logic. There seem to be 3rd party tools…

As you can see from previous answers, a performance tile is a single number, you can't add a second one there. But OBIEE is a web-page rendering, that's why you can fake it in multiple ways: narrative view (with custom CSS for styling), table view (tweaking options to remove borders between 2 cells and visually "merge"…

Do you actually have a date dimension not linked to "procedure date" and "report date"? If you don't and with just access to the front-end you can't do much: OBIEE will never generate rows which don't exist in the result of the query, the query is driven by the model (to which you don't have access as you said). That's why…

Steelbird wrote:In Data base I can execute this select TRUNC((SYSDATE) + 14/24) from dual; but How can we implement this in obiee ("Time"."Date" + 14/24) ? In every place where you can enter formulas you generally have a helper with the list of available functions and there is a group of them called "Calendar/Date", have a…

At some point even the business is "smart" enough to understand you can't change the product and expect the exact same behaviour, or .... why did you even change and gave up on BO? As said, you are cheating with the tool, so play the game of how the tool is developed! Agents are meant for users, this means users is a way…

Every OS, Windows and Linux included, have ways to recursively search for a file based on name in a given path. Sounds like a legit way to find files ... Or the doc also has references to all the paths (and in google you can find it as the first link for a search result).

4117887 wrote:...or with out OBIEE... For this one, pick whatever other tool on the market doing the kind of analysis you look for and deal with it. As said agents are targeted on users, therefore that's how you could cheat. Link the various locations to different users and change your analysis to be reactive to the user…

Let's take a step back: what is the original requirement? And not what you imagine it is (like the GOURL thing ). If need to embed some OBIEE content into something else there are the webservices, ADF has other ways to do it as well. Authentication would need to be done by some kind of SSO if needed, or if you use…

Agents are meant to target users: the content is generated and sent to users, not wrote on disk. This means that either you have as many agents as you have values in your prompt and you set each and every single one to a different value, or that you have different users which by their setup have different content in that…

2668432 wrote:RPD was not touched at all during the prod freeze and not opened in online mode too. 6. How do you know nobody/nothing touched the RPD on your PROD environment?