Could you be a bit more precise about what you are trying to do, with what product, and how? Is it about OAC? Because if you mean OCI instances, then this is definitely the wrong place...

Even in online mode, by default you are checking out pieces of the RPD locally, work locally, and then checking them back in to the server. The work is still done locally and not from the OBIEE server.

For general Oracle Cloud this isn't the right forum, this area is fully focus on Oracle Analytics.

Development of the RPD is done on your local PC, the OBIEE server is a different story. Your error is a database error: ORA-12170: TNS:Connect timeout occured at OCI Call OCIServerAttach Check firewalls and network connectivity between the OBIEE server and the database. And just in general make sure that the OBIEE server…

Are you asking about OAC or just Oracle Cloud in general?

Do not resurrect 6 years old threads. Start a new thread and ask your question providing the relevant information (product, version etc.). As for session variables, a good place is to start in the doc.

@User_09N8L , Do not randomly post in 6 years old threads that aren't even related to your question. If you don't already have a thread open for that, start a new one (but no double posting).

Hi @User_KA15Y , Your question is maybe obvious for you, but you should try to provide some more context if you want a reply. Starting with a full product name. If it's about pre-packages content made available with the product, there is maybe another forum in charge of that product. If it's based on your own built data…

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).