There is a way, but you will not like it... A DV workbook is just an object in the catalog. The classic OBIEE/OAS/OAC objects were all XML and Catalog Manager was able to get these info out in a report as Michal said. DV workbook went through various iterations from XML containing JSON, to JSON containing XML and other…

I did ask about the official way to get offline catalog access in OAS/OAC, not receiving a reply from PMs sounded like they did confirm to not see reasons for doing it (anyone having to administer and maintain this tool would disagree)...

A real full list of agents can't be obtained from the database tables you mention: an agent can exist in your catalog without being in those tables. The real reference for the agents is the catalog because that's where an agent is defined and stored. Sadly OAC doesn't allow any offline access to the whole catalog because…

Yeah, that checkbox is off by default. You generally use it when you want to be notified that nothing happen (and when you do that, people setup rules to automatically archive your automated emails and will not even read them when there is something real inside :D )

You can set a condition on the agent, and the condition will be if there are rows or not. The agent will still run based on the schedule, but if the condition fail (= no rows of data), it does stop there and doesn't send anything.

You maybe wanted to raise that internally somewhere? Because the error is quite clear, but only you can know if it's right or a mistake. Cloud accounts have limits set on everything. Do you have anything else running using OCPUs in your account? If you do, that's probably why you did reach your limits. If you don't have…

It actually looks a list of IP that could be a bit more correct than the one you found: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/manage-service-access-and-security.html#GUID-C13DE22F-5069-4704-B64E-2F6D28B8D027 If you scroll a bit you find a similar table as the one you did use, but this one has every…

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…