3248940 wrote:3. OBIEE - Made the deliver agent to deliver the content as HTML as inline rather than attachment If you send it as an attachement the size of the attachment will not change (if you don't edit it in a way or another). As you sent it as HTML look at the source of the email you received from OBIEE and the one…

You posted the LSQL (logical SQL) of your analysis, this doesn't tell you much as you can't test it directly in your database. Find the physical query that OBIEE generate and look at that one, the answer of what happen is there (and it also cover the point raised by Joel, if there is some row-level security the physical…

Do the folder exists "for real" in the catalog? If you look on disk or via catalog manager? If folders are there, could be a permission issue?

If you are using OBIEE you must have a proper time dimension, right? In this case use the AGO function. (AGO only works with a dimension having the needed levels and configured properly as time dimension)

The feature getting closer to what you describe is called "master-detail" : you have a master view which allows to set selections on details view. In your case you will need to add the country as a chart prompt field for your products chart. Setting the country in the table view to be the master and the products bar chart…

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…