What Amrita said. There are 2 kinds of exports: one that goes directly on the criteria and does export your criteria (all the columns you have there) and one that is based on the visual rendering of the view as you see it on your screen (and therefore can have less columns because some are excluded etc.). CSV is an export…

It isn't Oracle's role to provide you every kind of GeoJSON file you could need. They provide some as reference, just like some custom plugins are also available, but it isn't meant as Oracle being the official provider for whatever kind of GeoJSON users would need. Go online and find what you need or build it yourself…

Use the "Find" filter on top of the list, if you have a fixed naming convention giving all MVs a fixed prefix / suffix, the job is done. A materialized view isn't very different from a table, and that's why it isn't shocking for the wizard to mix the 2 kind of objects. In the end from an OBIEE point of view they do behave…

I just managed to do a quick test: a materialized view will be seen by the import wizard as a table. They are there inside the list and don't have a different icon or anything, that's maybe why you didn't see them.

MVs works just fine in the RPD, are you saying you can't see them anywhere when using the import wizard? Did you check if they aren't shown with tables or with views or just anywhere else? Of course you can always define them manually, but it does take some more work (you could generate the needed code with SQL, but if…

What kind of information are you looking for? There isn't a detailed roadmap for semantic modeler made public yet. The tool is in preview, it only supports a subset of physical sources (only relational) and still has some issues here and there. That's what a preview is for: have a look, give it a try, don't replace…

The good old webservices are fully working in OAC (as long as you have the permissions, managed with privileges in the admin page), they didn't change for 5+ years but at least they are there still. Using that you can do the same job you would do with Catalog Manager but without the GUI. But you can absolutely get the code…

Just saying (again), think twice before using "denied" in the privileges. "denied" is stronger than any "granted", by inheritance you can disable things to everybody just by adding a "denied" on BI Consumer. "denied" should be used very carefully in the privileges page. Remove the grant to BI Consumer instead of denying…

Default application roles can be edited, you can edit everything and even drop them fully (OP talks about OAS, full access to EM and app roles management and app policies management). This is just not the point, OP doesn't really want to edit an application role but want to change default privileges grantees.

Do what Jahnavi said: go in Admin -> Manage privileges and change the privileges for the "Access to Export" privilege. You don't map privileges to app roles, you add app roles to privileges. (And if you aren't familiar with that page, stay away from "deny", you will understand why if you don't...) Just keep in mind that…

Or the webservices, the good old one that is part of the tool for 10+ years: you can recursively loop through catalog objects or search them by type and then get the "definition" (the code inside the file when on disk), all by webservice. The downside of this approach compared to what Michal suggest is that the security is…

You can script the job, but yes: find all the workbooks you need (catalog search can help) and process them one by one. That's why a script will be useful: lot faster and will not get crazy after a few workbooks...

No really, it's a product/service.

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…