What tool is the question about? The "Oracle Business Intelligence" category is quite vague... Assuming you mean from OAS, it is the wrong tool for the job... Publisher has way to deliver content remotely and could be an option. Anything else would require some creativity and code because that's the wrong tool for the job.…

By memory the latest SA available is one of the first releases of OBIEE 12c, a very old (6 years?) and not supported anymore version. And Oracle was supposed to have removed that download. Installing a recent OAS or OBIEE is a matter of minutes with a silent install.

The ( ... ) in a filter is achieved by clicking on the "AND" or "OR" to make them "sub conditions" (indentations = ( ) ). You can also adjust the XML of your analysis if needed in case you get lost while clicking "AND" or "OR" to make blocks of conditions, because mainly the first time it takes a bit to get the expected…

The columns of the scheduler/agents tables aren't all documented. I remember there was one or two documents in MOS explaining the meaning of a column or two, but that's it. It isn't a table meant for direct access and usage. That table, like the others, is used by the tool and by Job Manager. You could deduct the meaning…

@Branden Pavol , there is/was a swagger file describing the available services, but I believe the list of datasets should be something like https://<your hosts>/ui/dv/ui/api/v1/dataset/datasets . I would find them looking somewhere else, but it isn't a documented thing and therefore better to stick to the what is public.…

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…