If not wrong, there is a webservice giving all the info about the datasets in a single (or worse case it is paged) json. From there you should easily get all the datasets just by searching your connection. I don't have it handy and can't fully confirm it contains the required info, but I'm definitely 100% there is a simple…

In your prompt you can enable the "limit values by" condition, and select if you want to limit values based on all prompts or just one specific prompt.

I really can't remember the Doc Id, sorry. But glad it did work and at least you are back to a working system.

I remember that it was possible to switch the security model back to "Oracle Fusion Middleware" in the config file, there was a MOS note about it. You can try by stopping everything, look for the config file (it could be named xmlp-server-config.xml), and there inside find the <property name="SECURITY_MODEL" tag and set…

Hi Chris, Just to get everything correct (between your message and title). What version of OBIEE 12c? Is this a full OBIEE install, right (not just BI Publisher)? It is a new install or an environment that was already running for a while? When you say "I can't connect to Oracle Analytics Page", what page you can't connect…

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…