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…

They could still add a "Best practice violation" in the consistency check of the RPD, so they can perform the test only when Oracle is the database. Let's say there are ways it could have been added, they just didn't

I'm still not sure why by default it isn't enabled as it avoid many issues as soon as multiple schemas are involved. You can assume that on an Oracle database you can check that checkbox by default as it will avoid you issues in the future (and so far I didn't find issues in always enabling that).

I doubt the Autonomous Database is certified for the RCU. You don't have SYSDBA access on an Autonomous Database and this is what the RCU checks for and need to do the job. You can use Autonomous as a datasource, as you do in your OAC, but you don't use the autonomous for the RCU in OAC as you don't have access to the RCU…

Your year/months are dimensions, so you duplicate the measure you currently have and one you keep it as it is, the second one you do the "show value as...". The 2 measures (the same one in double) goes in measures, and you then move the "Measure Labels" in the Columns part and you place it after the month (so the 2 columns…