If you look at functions there is one being the day number in the week: by using that you can write a logical expression dealing with what you want.

What is the exact name and version of the product you try to install? What is your OS version?

Assuming you are talking about OBIEE agents, everything is possible because OBIEE has a quite flexible security model. Agents that aren't about personal content should be owned and executed by a "system" account (not an employee that could leave the company). You can then use "act as" and things like that to behave as this…

It depends ... The person leaving the company has no impact on your OBIEE if nothing is done. If the user's account is dropped and the agents are running as that user, they will not run anymore. And if they are delivered to him, not sure that still make sense... Sounds like a good occasion to clean up things and adopt some…

Did you install the latest bundle patch? There has been in the past few reports for variables not refreshing etc. But it was quite some time ago (I believe earlier 12c versions) and the fix was supposed to be in one of the bundle patches. If you are at the latest bundle patch already you should probably raise a SR.

Ok, so that's definitely BI Apps. The concept of "global currency" as far as I know it's also a BI Apps thing as I don't remember having seen something for it in OBIEE (other than setting display options and be able to use a variable to retrieve the correct currency or something like that). Still, the best way to prove…

Hi, So you are on OBIA and not a simple OBIEE? And I'm not fully sure what you are looking for... You say that some reports become slower: are they really BI Publisher reports or is that OBIEE analyses? Could be analyses but always better to be precise with wording... So, are you trying to confirm that what the developers…

Nothing has ever been added to DDR, it's almost surprising they never dropped DDR fully. It does the bare minimum and has minimal support to variable, that's about all you can do in DDR. It's generally easier to consider that DDR doesn't exist :D

I didn't test in 12c because I don't have one available, the test was in OAS 6.4.

Did you try it? In 2 minutes you should have had your answer... A DDR doesn't go through the RPD and therefore its columns do not match any LSQL formula referencing RPD objects. DDR shouldn't be considered as normal objects providing standard features, this is just one of the many things you can't do with a DDR.

If you look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2832967.2, when using JDK 8 u331 or later there is an extra patch required. Did you install that one? If not, install it and try again...

Ok, so you aren't trying to access WebLogic but Answers (or DV), and you are redirected to the lightweight SSO page. What version of JDK did you update to? There is an extra patch needed with some of the latest JDK versions or you will not be able to login anymore. Did you install any patch other than updating your JDK?

Not sure what a screenshot of database listener has to do with WebLogic. No details on the exact product version (obiee 12c: there are 5 major versions and each has about 5 different bundle patches, and you complain about WebLogic which, like with FMW, has it's own patches), no info about the environment (OS etc.), the…

You should have usage tracking enabled, mainly because it does asynchronous inserts and therefore doesn't impact your performance. That gives you already a number of information on what your prod server does (or better: what users do with it). And yes, I would also go with log enabled. If you have a concern about logging…

production environment logging is disabled Why? Exactly because it's a prod environment you need logs to be able to analyze issues without messing around with things trying to reproduce something you don't really know what it was. Without logs, you just have no way to investigate anything, you can only validate that the…

If they are sure (I never fully trust people: historically people lied more about things they didn't do or did wrongly than a server), maybe you have a cache issue? If you have cache enabled your condition could have perfectly missed the updates because it never really sent a query to the database. If you have logs on you…

Hi, There aren't tons of options... The first thing you should check is if the agent did execute correctly every day (or at least Tuesday-Saturday based on your description), then you should check the condition query: seeing a function is one thing, what the analysis really does can be quite different. Look at what the…

You add a filter and turn it into an exclusion instead of inclusion. Like in this example I did select "Null" and then clicking on the "..." option I switch from "Include Selections" to "Exclude Selections". Select all the values you don't want and then change the behavior from inclusion to exclusion.

In what part of OAC? There are 3 different places where you could be seeing data: a "classic" analysis, a DV workbook, a BI Publisher dataset.

So what you want to do is not directly to display the max date, but it is to filter your analysis for the max date for the 2 different status. Such kind of complex filter is probably more easily achieved by filtering based on another analysis, handling the logic of finding what rows have the max date for your 2 status. It…