OAC (and not OAC Classic) doesn't allow to execute customer code, you don't have any access to the OAC server itself (ssh etc.). In some old blog posts they were using ODBC to connect to Redshift, downloading the driver, setting up an ODBC connection and using this ODBC connection in the connection pool. But in the OAC RPD…

What Joel said if possible. If you can't that way have a look at https://www.youtube.com/watch?v=DQ5nAIpUa8M , it can give you some ideas of possible workarounds. Also https://www.youtube.com/watch?v=8BdAB8ictvA can give hints for a workaround.

Agents can run in 2 ways: - a single execution of the agent and sent the result to many - run as recipients: OBIEE login as every single recipient and send the result only to the recipient itself If you have 10 stores and want a single agent to deal with that, you need 10 different recipients which are going to filter the…

This is an extension of OBIEE 12C BAR file automated daily backup If you expect somebody to write a nice batch file and send it over, this isn't how the community forum work. If you have specific questions ask them and people here around will be glad to help (on their free time).

mmajdana1 wrote: @joel I want to apply this in RPD as a part of security. Did you look at Row-Level Security (Data Filters) in the RPD? This is what they are there for, to filter data retrieved by business models / subject areas based on some conditions.

OBIEE 12c by default is already mobile by itself (while 11g was a nightmare and really only worked with the app) being HTML5. Obviously a phone screen is in portrait mode by default and is also quite small compared to anything else. If you leave all the "style" settings as defaults (so not settings width and other sizing)…

BVT can connect to on-premises instances and also to OAC (the very first wasn't able to do it because it was targeting OBIEE 11g to 12c upgrades, following releases added this support). You can run BVT from where you want, it doesn't need to be the OBIEE server. BVT connects to OBIEE/OAC just like you do yourself in a…

John305 wrote: i would like to transform them to Mobile reports. What is a "Mobile report" for you? Define this and all your questions will be easier to answer, otherwise there are multiple options.

1019440 wrote:Can we use Baseline Validation Tool(BVT) to compare OBIEE12c in on-premise data with Oracle OAC? Of course, that's what BVT has been developed for originally: pre-post migration regression testing. How? Download BVT and use it. There are bunch of resources about how to use BVT.

dileraco wrote:Here, I understand that deleting cache 6 hours apart is ok for us. That should be our process Right If 6h is the answer, then go for 6h In general you start looking at the sources you use for the analysis, you identify how often those changes and get the business owner deciding if they always want to see the…

Hi Dilek, This is what you get with cache: before to enable cache, one must have a cache management strategy in place. Turn off cache and no problem anymore. If you want to keep cache on, you must define a process fitting into your current processes and workflow, depending on the sources etc. to define when and how to…

I don't know if you have such a process setup in your environment, but by asking I guess you don't Is it possible? Sure! Everything is possible. Is it done by itself? Nope, nothing happen by itself. You know how to create a BAR by executing a single command, you can easily schedule that if you want to.

What product are you talking about? Assuming you are referring to some pre-packaged content you would need to move your question in the product related forum.

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.