Do you have either of those versions of WebLogic? If you do, then you need the security patch.You didn't mention the specific version of OBIEE 11g that you are running.

Trying to implement this logic in code is a nightmare. What about leap years for example? As @Christian Berg said above, the best solution and best practice is to have a date dimension in which you'd have a flag that indicates if a date is a weekday in your case.

Yes , you need to set virtualize=true https://docs.oracle.com/middleware/bi12214/biee/BIESC/GUID-99968A33-0D49-41AE-83CC-A3CA4112E9F1.htm#GUID-0EDD6411-21BE-4C90-8337-88ADF97FEF11

Saved Customizations are just a snapshot of the dashboard at that point in time. The Customization doesn't pick up subsequent changes. https://docs.oracle.com/middleware/12212/biee/BIESC/GUID-351F0594-047C-489B-A4B7-9779A0088574.htm#BIESC6004

I have to agree with @Christian Berg & @Gianni Ceresa here. There doesn't seem to be any benefit (analytical or financial) of implementing OBIEE to work off a single database table. For the benefit of the wider OBIEE community, the solution you've provided as a workaround should be noted as a solution that doesn't take…

Do you mean that the agent works on some occasions and on others, it fails with these errors? What version of OBIEE is this? What is the underlying data source? Have you checked the bi server log files for any possible data source errors?

Hi @Uttam.Singh It appears to be a change that sneaked in under the covers. https://support.oracle.com/knowledge/Oracle%20Cloud/2343252_1.html

There does appear to be an ODBC driver that can hook up to MS Project as @Gianni Ceresa mentioned earlier - https://marketplace.visualstudio.com/items?itemName=CDATASOFTWARE.MSProjectODBCDriver

You need to reference the presentation layer name of the hierarchical level in the AGO function. Quick trick is to right click on it in the rod copy and paste into a text editor and you should see it’s fully qualified name in the XML.

The syntax should be: AGO(Measure, Level, Number of Periods to offset) The Level is optional but can be used to override the grain of query in your analysis. Try adding the level in your AGO function.

OK, so what's the syntax of your AGO function?

Hi Do you have all the levels in the new date dimension? It appears that the logical levels of granularity of the dimension and the AGO function aren't the same. Take a look at this: OBIEE: [nQSError: 22040] To use AGO function, the storage level of the query ('[time1.time_keymust be a static level…

This isn't an OBIEE issue. Speak with your network admin team who can reassign the existing host name from the 11g server/s to the new 12c server/s.

I would suggest that you take a look at this article.You can delete temp files but ensure that you don't delete files which could be currently in use.

I didn’t look at the URL properly! it works for me. I’d suggest that you try another browser and try clearing browser cache as well.

By the way, providing your access credentials on a public forum isn't advisable.

Hi @Mark.Thompson Have you tried this URL? - https://adc3-zdfi-fa-ext.oracledemos.com/xmlpserver/servlet/home

Do you have other applications other than OBIEE within this domain? It would appear that you need to upgrade all applications within your domain. https://support.oracle.com/knowledge/Middleware/2324286_1.html You'll need to use the Configuration Wizard - Oracle Support Document 2017388.1 (How To Delete An Oracle HTTP…

1st question, why do you need an EVALUATE function for a CASE statement?

Which version of OBIEE?