OAC is like a black box: there is little to no logs other than what you see on screen (which is weird as OAC has about 10 different log files all containing really important messages), it's the downside of a fully manage product. To be fair I have no idea if there is an official debug process on the OAC side. I would start…

@Rajesh_Kolli : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-delivery-destinations.html In this page you see a list of supported delivery destinations, as you can see FTP and SFTP are supported. A VPN isn't a requirement, it all depends on the networking needs for your OAC instance to reach the SFPT…

I'm quite sure OAC does support a lot more than what you think, the detail is that the real smart piece of OAC is the good old RPD (or semantic model as they start calling it because of the availability of the semantic modeler). In the RPD you can do generally do everything by modelling things accordingly. Creating…

I would agree with what Michal said: the catalog archive does not contain any information about absolute paths, you can restore it where you want but you need to execute the import where you want it. I highly doubt they did change the behavior of that 10+ years old piece of logic just for this (even if the DVA does contain…

The "Export" seems to be a hybrid between DV export and catalog archive. If you do export from Catalog in DV you get a file containing a catalog archive (the same good old archive that exist for more than 10 years) for everything that is just part of the catalog (folders, DV workbooks, analysis, dashboards, agents etc.)…

@Indra Sardana-Oracle and a screenshot, because as said: it works perfectly as designed in the example I just did on a new instance. What is the behavior you are observing (with a picture or detailed example)? How did you build your analysis? What behavior were you expecting instead? There are at least 10 possible expected…

Slightly confusing to get where you are doing what exactly... You say report, which means BI Publisher, but you have a tag "analysis" which means "classic" Oracle Analytics Answers. Can you clarify this point? Where are you setting sorting? As a criteria condition or in the view? Tried right now, works as expected. You…

@SaurabhJaiswal-Oracle , keeping it simple what you asked never existed as a feature in the product, and not even worth raising an ER for it because it doesn't really fit in with the architecture of the product. Usage tracking is a technical feature, Oracle Analytics is still a single-instance product (they did try adding…

The product never supported that. They can setup an ETL process doing the job: reading usage tracking from the central place and pushing the relevant rows around to the various databases. Or more simply just sending the whole content. Can be batch based or near real-time with the the various options the various ETL tools…

What would be the need? Do you have the usage tracking tables split in 2 different databases? Or do you expect "double" insert in 2 different places in parallel duplicating all the rows? Quite sure that for usage tracking the connection pool has always been one, even in OBIEE 10g, 11g and 12c.

As there isn't a function doing that in one step, you need to get there by some logical operations. There is a function calculating the number of days between 2 dates, that same function can give you also the number of weeks between 2 dates (or you can take the days / 7). You then only need to adjust things a bit to cover…

Oracle Sans is the default font with the Redwood theme, now the question is when Redwood theme has been added to OAC. Based on https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html, Redwood was added as an option you could enable in OAC 6.1, while it switched to the default theme in OAC 6.4. The Alta theme…

Give me a simple universal definition of a "business day" and I give you a simple function for it. Every single business has a personal definition of "business day": different countries work different days, same country but different fields work different days, and it's better to not even talk about holidays (I'm in…

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…