There is a lot that cache management strategy must pay attention to. The first thing is to identify why do you want to turn cache on: what is the reason behind using cache? Is cache the real solution or you hope it will just hide the real problem? Before to turn cache on you must ask yourself how long must the cache be…

So you are saying it's a per-user cache issue? You have another thread where cache was already a problem (with agents maybe, can't remember). Sounds like somebody did a really dirty job on your system. They turned on cache everywhere randomly to desperately try to hide poor performance (which is generally the result of…

user477756 wrote:OBIEE 11.1.x. You aren't helping yourself: there must be close to 40-50 versions of 11.1.something ...

I didn't test this because I don't have an OAC instance up with multiple roles/users ... In a way renaming is deleting: you rename an analysis which is used by a dashboard and you break the dashboard as the linked object doesn't exist anymore. Same behaviour as deleting the object completely. "Edit" is to change the…

Look at the queries generated to populate the lists and you get your answer. There are multiple possible reasons, so look directly at what does the job and you get the answer.

Hi, You aren't giving much content to get a real answer ... Simple things like exact product and version you use, browsers (name and version) you tested etc. As it goes away on refresh, it sounds like a rendering issue, so something which is browser related. And a screenshot would also be helpful. And when you have the…

Somebody maybe saved system-wide properties for either that column or that data type?

Bouman, Arie wrote:....however when I try to change for instance last line, as suggested by a few blogs, it gives none or wrong result Everything comes from a query, so how does the query look like? No result or some other result is maybe not wrong in th end ... Look at what query is executed and that will probably give…

Hi Adrian, Nothing else cross by my mind at this time. It would require to be tested (and abused) till something work, but I already have long list of things to do/try first ... Did you try opening a SR to ask Oracle if they maybe have a hidden param or way to pass that password?

4122460 wrote:When customer click on action link... Where is the link they click exactly? If it's on the values, the one which is clicked is sent as context...

Setup a job in the database rolling your logs. Partition the table and simply drop the old partition on a monthly/weekly/daily base. Ask your DBAs, they will easily fix that in a clean way.

You are following a way which isn't the natural way to achieve what you have in mind. If the JS thing was the standard way to prevent an analysis from executing because of missing filters, it wouldn't be described in the "System Administrator's Guide" but in a document read by most users (not just sys admins). You are over…

Deploying "analyticsRes" is pretty simple once you follow all the steps: https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/

This topic has already been covered many times. If your analysis in a dashboard page, make your prompt mandatory and set predefined values by default (either static or using variables). Or in the dashboard properties check the "Prompt before opening". If you just want to use the analysis standalone (no page) add your…

If your 3 measures are attributes instead of real measures, you can use a trellis view. But if they are 3 separate measures the trellis isn't going to let you use them as rows I believe.

user12863665 wrote:Thanks Gianni for the update. Actually I am looking for correct product count based on the month From the original data What is "correct"? What is "wrong"? Keep in mind you are the only one seeing that model, that data, that screen. We don't have it. By default a count must always be correct, or why…

Hi, Are you sure your example is correct? Because in your example all the rows of January = 100 + 200 = 300 => what you expect, all the rows of February = 300 + 500 = 800 => what you expect. Which means that all you need is to take the month level of your date (you must have that in your time dimension or you can make it…

Hi, Did you have a look in the doc? Either your own documentation as you deployed those certificates in the past already, or the official documentation of the products?

Did you try something like https://stackoverflow.com/questions/49866578/how-to-automatically-answer-user-prompts-in-java too ? The .sh does execute a piece of java, something like exec ${JAVA_HOME}/bin/java ${JAVA_EXE_MODE} -classpath ${CLASSPATH} oracle.ods.virtualization.config.TemplateAdapter "$@" there adding a timer…

The narrative is based on the result of the criteria of the analysis, if you set your sorting there, the narrative will adapt and follow. But when you play with sorting at the table level, that's just the table itself, it isn't the analysis sorting, so the narrative has no way to know about it as well as the rest of the…