Have you looked at your log files for any clues? Check the obips1 log file in particular.

Have you tried using a different browser? Have you tried clearing your browser cache?

Hi Mounika I've never done this before so I can't say for certain if the following will work and it all depends on whether or not the BI Server can interpret the FDA ASOF syntax. You can try adding the ASOF syntax in the "WHERE" clause section of the Logical Table source in the BMM layer. If that doesn't work then you'll…

I don't believe that the use of Opaque views is your underlying cause of the performance issues that you're facing. Flashback queries, in most instances don't make use of Oracle's query optimisation.

Probably best to move this to the Business Intelligence Applications forum.

Vertica does provide an ODBC driver and can you confirm that you followed these instructions- https://www.vertica.com/kb/Vertica-Integration-with-OBIEE-Connection-Guide/Content/Partner/Vertica-Integration-with-OBIE…

Does your Node Manager come up? Any errors/warnings in the Node Manager log file?

What happens when you revert the config.xml changes?

There is a permanent solution to this but beforehand, this is a DB error indicating that your OBIEE analysis is using up all the TEMP space on your DB which would indicate that the data volumes are excessive. Resolve this by redefining the analysis causing this.

Take a look at @Gianni Ceresa blog about time series functions.

You’ll need to provide some context. What version of OBIEE? What OS? What are you doing? An upgrade?

Check the interop tab in the OBIEE 12.2.1.4 certification matrix - https://www.oracle.com/technetwork/middleware/obiee-122140-certmatrix-4472983.xlsx

Follow these instructions to reset the trusted user (BISystemUser) password: https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1352697_1.htm…

As far as I'm aware, out of the box, you can't do what you want but to take a few steps back, what is it that you're trying to achieve?

I'd suggest that you start off looking at the Oracle Whitepaper on Best Practices Guide for Infrastructure Tuning: Oracle Support Document 2106183.1 (OBIEE 12c: Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 12c (12.2.1)) can be found at:…

Has anything changed recently? What happens when you manually restart presentation services? Is this the only error in your log files?

Have you got a tnsnames.ora file in the right place? https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2068474_1.html

Didn't fully understand your requirement - should have read it properly! Amount & Code logic: SUM(Amount BY Supplier, Invoice Num)CASE WHEN RANK(Amount BY Supplier, Invoice Num) = 1 THEN Code END

RANK code BY invoice num, supplier name and you can have a filter on your analysis where this column = 1 You may need to change your analysis to a union to do the 2 calculations in separate steps because of the differences in filters.

Create a column formula using RANK on Amount BY Supplier & Line Number, that should handle all of your scenarios and also a column to return the code using similar logic