You asked the same in the MOSC forum and got answers (including one you accepted as correct). https://community.oracle.com/mosc/discussion/4512484/can-a-dv-consumer-access-a-dv-project-in-any-shared-folder-or-would-s-he-need-access-permissions-fo Feel free to close this thread.

Hi Deepa, You can do the same thing Michal is doing in the database for OAC as well, but of course not via SQL. You can either export a snapshot as BAR of your OAC and work on it as it comes with the whole catalog and all the datasets (if you selected them). The BAR can be processed by a script to do exactly what you ask.…

You can do it in your browser, you can do it by script as well. There isn't a public documented API for it (it's coming), so you have to performs the same actions as you do in the browser. Technically doable but fully hand-made code, to get a valid session first and call the needed URLs to create the snapshot first and…

https://medium.com/@insight2action/oracle-analytics-embedding-tech-talk-b2f2cb0c1962 Or also https://acesathome.com/sessions/2020/05/06/mike-durran-embedding-with-oracle-analytics-cloud/

I assume the offline RPD has been deployed and therefore your changes with the variable exists online, right? Did you try setting a default value for your variable? Does your query return a value for every single user? What product are you using exactly?

Sounds like this thread is dead as you asked the same in https://cloudcustomerconnect.oracle.com/posts/c06ff1d46e .

Hi, Any chance you could be a bit more precise? Do you mean DV projects or the classic analysis? OAC is this 2-products-in-1. Classic analysis come with a bunch of webservice available, more often people just want the data and not the charts, but there is a service for that as well. DV projects are a lot simpler to embed…

Mike Durran, PM Oracle, did a webinar yesterday exactly on this topic. Showing how you can integrate DV projects in other applications or webpages, including how to deal with security (there are many options). The slides and recordings are still not online, will post a link (if I don't forget) once they will be available.…

You don't have the permissions. Also the fact you aren't allowed to click on "Delete" point to a permission issue: you can probably consume it (open) but not edit (and renaming is editing or new+delete).

Google says a "lakhs" is supposed to be 100'000, so your dataset is supposed to have 1,5 millions rows? OAC definitely support that and even bigger, but depends on the resources of your OAC instance. As you can see…

It's available now: https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html Sending to eDelivery for the download this time and they renamed the app once installed as the "about" shows 'Analytics Desktop' as name now.

As said by others, Catalog Manager (the tool installed with the Admin tool) can get you that kind of list. If you want something more "scriptable" you can run Catalog Manager by command line to get the same extract as the UI, or call the OBIEE webcatalog webservice and get the whole list of what is into your catalog (and…

There is (luckily) an easy way. From the classical home you go in Administration > Issue SQL, from the data visualization one you go in Console > Issue SQL (it's the same page). The SQL you execute is: call GetOBISVersion();

Hi, As OAC is quite "wide" and contains few different products inside, do you mean in a data visualization project? And by "errors seen in my visualization" is that a reference to business errors? Like if you are showing sales of products and one is missing or it is a wrong number? Or "technical" errors like if you…

Interesting situation: either slow but running queries on your database live or fast but cache side effects. Could "Refresh Data" be a solution? I don't really use cached sources, so never tested it, but in classical OBIEE it's the way to force the system sending a query to the BI server instead of just using the front-end…

Keep applying updates when they are available for that instance. I tested in a new release preview and it is fixed, you will be able to use the expression filter without the error.

Bonjour Christian, Just to be sure I get the whole picture: you are using Data Visualization Desktop and have Oracle 18c XE installed on Windows on the same PC/laptop (or another one in the same network which can be joined just by its host name). Right? Just to give it a try on my side to see how it looks like, knowing…

Are you sure about the settings you entered? I believe 18c XE is installed by default as a pluggable database, and "XE" is the CDB, not the PDB (at least based on some default 18c XE installs I have around). The PDB is called "XEPDB1" by default (if not wrong), but you can anyway check that in your own database to make…

If you go in "Analytics" you will see a list of the instance you currently have. Click on the instance name representing the one you are using and there you must see the version.

It seems to work like a RANK function in the database and not DENSE_RANK. This is at least what I saw based on a quick test earlier.