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…

Exactly what Jerry said. You say the layout is important, but you aren't in Excel and therefore you have to go with how OBIEE work in a pivot table. The "Grand Total" will also calculate for the % column and the name of the 2 measures will be visible (as you more than 1).

Why don't you use typical linux tools for that? There are many ways and commands which can simulate a user entering a password when a script/command doesn't have a parameter for it. Otherwise there would be little to no automation at all as many scripts/commands don't have all the parameter you need and are only…

If you look at the certification matrix (https://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls ) you see that 12.1 is still certified. So it all depends what your "12c" is for real. And a old tool doesn't always get certified for newer DB versions (mainly because 11.1.1.7 isn't supported…

Did you look at the real query generating the ORA-00942 ? What is the table it try to find? Did you enable fully qualified names in the connection pools?

Rai Qaiser Hussain wrote:Tried with two connection pool also as shown in Fig.1 even updating accurate number of records That's all you don't want ! If you need 2 connection pools, one for dims, one for facts, you are moving the whole load of acting as a database on the BI Server. Do not do that! It make no sense to have 2…

That space as been disabled because, as the message says, it moved to CCC, the "other" forum. It has been a strange decision to close the space here and have one named "General OBIEE" which is actually only about Publisher and almost no OBIEE content at all ... I saw you posted there, so wait and see which thread get an…