There are couple of options. For a specific failure you can setup a filter: This function generates a new filtered measure from the given measure and the given filter expression. FILTER(measure USING filter_expr) measure is the name of a measure column. filter_expr is a filter expression. Example: FILTER(revenue USING…

A work around for a popular workbook would be to create a copy of the workbook (for example with Save As) and put it in the new folder and then change the existing workbook to have a pointer and some text about the change. Of course, for moving a large number of workbooks -- this would be a lot of work.

You can do this via the share menu now. Share a Workbook URL with a Specific Canvas Selected (oracle.com)

The purpose of upload is to use the data in FAW/OAC and the purpose of download is to able to export data from the system. There is no VLOOKUP in OAC -- however you can create joins or blend data between files or tables. FAW and OAC are not file storage system. I would recommend you use another tool such as Oracle Content…

Agreed -- we can have a more complete experience. Note -- a DV Author should be able to use the developer options on their own workbook.

Are you using Fusion Analytics Warehouse here?

One work around would be to recommend a business user the "Developer" tab. Build a table or list with the correct data and filters and then use the developer Logical SQL to get the work LSQL syntax. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/developer-options.html#GUID-5A0BD6CE-EEB3-4028-B64C-BE3178B69C21

What is the goal here? Sort order is often defined at query time. What do you hope to know or do based on "uploaded" sort order?

For the file type -- today we do use the file type to determine how to parse the file. Supported file types are: .xlsx, .xls, .csv, .text, .txt, .tsv, .tab For the ADB connection, it is not clear what is happening here. Can you make a connection with these credentials via SQL developer or other desktop tool?

Which type of report is being exported here? Is the user trying to get the visuals of a canvas from a workbook? In general -- export should not cause a timeout unless there is a time when viewing the dashboard.

Have you tried using the screen for "Edit Definition" -- this shows you a preview of the data based on the SQL you enter when using Manual SQL.

For the formatting -- yes you can set formatting options in the dataset editor. These properties on in the lower left corner of the editing screen per column.

You can see all objects via the "Content" management option in the OAC Console. You can use this to filter by Connections to see all connections. You can change ownership or identify the owners from this screen

Have you tried using Edit Definition after it is copied? https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/filter-dataset-table.html#GUID-C39918C2-EB0B-470D-BA1C-98AB3908EFE8

As a work around currently -- a user could edit the dataset definition with a filter and then reload. If it were via some kind of variable, would you set it for every dataset reload or you would you want it to be driven by something like an RPD variable which changes independently.

You can control re-use of an exist connection by changing the Access settings on a connection. If you remove all access from a user or group -- they will not be able to create a dataset from the connection. We will need an improvement to control whether a Content Author can create a new connection, or it is not allowed.…

This is a good suggestion. Right now columns are order based on the order which they were added or where you position the selection when you add a row-wise calculated column. You can use this as a work around while we look in to this improvement. You will need to remove and re-add the columns via "edit definition"…

This idea should be directed to https://community.oracle.com/products/oracleanalytics/categories/otbi

I think this idea should be directed to the OTBI forum. https://community.oracle.com/products/oracleanalytics/categories/otbi

There is work being done around fine-grained permissions. @Adam Bloom-Oracle FYI