Hi, You don't need to create columns, you just need to write the join expressions in your join. The joins should be defined in the physical layer, if you want to create columns to make your joins simple "columnA" = "columnB" then you need to create views of your physical tables either in the database or use SQL queries…

You said you have 3 logical table sources, not 3 logical tables. If you have 3 logical table, each having different LTS pointing to the different physical tables, it's impossible that selecting a logical column from C you get a column of D instead.

Windows 11 is a desktop version of Windows and it isn't certified and not supported for OAS. Use a supported OS and it will work without problems: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html

Well, if you have a single logical table merging your 3 fact tables, you should either decide if the 3 facts provide data for the same measure or if they all provide different measures. All in all you don't give enough info to know exactly how your model is built, what is the expected behavior etc. Keeping it simple: if it…

If you don't have something making those splits (like a column attribute) you will need to add calculated items defining by hand what should be inside. If your dimension is well defined for the business need, it will be a one-click action of adding totals on that column.

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…