Well, it obviously depends on your whole query. If you have something like this: SELECT something FROM a_table WHERE location IN ( SELECT location_name FROM hr_locations_all_x WHERE active_status = 'A' ) You should look for something like this instead: SELECT a.something FROM a_table a, hr_locations_all_x l WHERE…

In SQL you aren't supposed to write an infinite number of values in a IN condition. For that need there are joins: just join together your tables and they will automatically filter the values just like the IN would do, but it's a lot better for performance (because that's the way a database is meant to work).

If your analysis is built with LSQL directly, you can reference dashboard prompts only through variables. Make your prompt assigning the value to a session variable, and reference the variable with the @{variable} syntax (and the various options there around).

Note: Even though the existing FMW is the same version (12.2.1.4), a new FMW need to be installed. This is because FMW is only one piece of the equation: the OAS binaries are injected right into that FMW ORACLE_HOME, therefore you don't really have a clean FMW 12.2.1.4 anymore when you are about to install the OAS 6.4 (or…

You shouldn't mix features permissions and catalog permissions. Removing your users the ability to create BIP reports will apply everywhere, you removed the feature for them. Yours is just a catalog permission thing. The system comes with a default security model (a number of application roles with inheritance, and default…

Guest access means no license access, this is also going to be an issue in case of audit of your licensing usage. OAS doesn't have that anymore because OAC doesn't have that, and OAS comes from OAC in the end. There are webservices that allows to integrate the OAS services in other tools, that's about how far you can go…

Queries, queries and queries again. OBIEE doesn't do any magic, it only generates queries based on what is modeled. Missing a record? Look at the query and identify if you have a model or data quality issue and fix it. Too many records/duplicates? Look at the query and identify if you have a model or data quality issue and…

By default it does indeed comes from your browser as that’s the only way the tool has to guess what language the user speaks/prefers. But you can’t only set the date format, it is part of the locale settings: English US is MM/DD/YYYY, while if you pick another English (like UK), they do use the more common DD/MM/YYYY. The…

What is the error you get when you try to upload your RPD? Do you have SSL enabled on that environment? is your SSL certificate valid for all aliases?

Well, not saying you aren't right, but a HTTP-500 does generate logs because it's a server error, therefore it must exist somewhere in your logs and come from somewhere. Apparently it is a fresh install of OBIEE 12c, starting from the beginning: is it installed on a supported/certified environment? Did the install go well…

Logs tell you everything about why something doesn't work. Start the usual checks: are the components started? What do their logs tell you?

Hi, I didn't try in OAC, no idea if it does still work... There was (is?) a system session variable named "USERLOCALE" that you could set in your RPD for all users with the value you need.

Hi, Embedding multiple CASE WHEN works, if you got an error you should check the logic of what what happening. What you could also try is to simplify your first CASE WHEN because it can be replaced by the IFNULL() formula. A random guess of what you could try: CASE WHEN IFNULL("Order Detail - Oe Order Release"."Revised EST…

As reference, if you want the details of the requirements to install OAS, you can check this: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/sysrs/system-requirements-and-specifications.html It's the requirements for installing the Fusion Middleware 12.2.1.4, which is the base on top of which you install…

By the way: installing OAS 6.4 now? OAS 2023 (aka 7.0) has been released, do you really want to miss a full year of features? You just need to replace the OAS install file, everything else is exactly the same (patches as well are almost all the same, the main difference is that OAS 2023 doesn't have a bundle patch so far…

The OAS installer doesn't install any OS prerequisite, but they are all documented and it's your job to make sure they are all set. The DB preinstall package mentioned above will install many more things and also change a number of settings in your environment. You should look in the doc for the minimum list of…

You mean SSL certificates? My guess is that if they are signed by publicly recognized authorities, it should be good. A doc says: In most cases, you don’t need to provide a compatible certificate as most mail servers can use the default certificate, including Office 365.

Isn't the Office 365 SMTP requiring an OAuth2 authentication? If it does, then no, not supported so far (not that I did look if the config screen changed, but nothing has been said about this in the list of new features of the March 2023 release). If your SMTP doesn't use OAuth2 but standard authentication (over SSL), it…

Hi, Any chance you could be a bit more precise on what version of the product you are using? OAC is OAC, while OBIEE is OBIEE. Or you maybe mean what is generally referred as "classic" in OAC (and not DV or Publisher): dashboards, analysis? Mobile usage of the product generally was done via the app (there is still the…

It becomes a challenge when everything starts by pushing DV for everything. It has no chance to catch up with everything classic does and it can't be the plan because it would take years. And when the "new features" are reproducing something that existed and worked for 15+ years inside the same tool, it's challenging to…