Note -- in addition to changing the visible name, you can also create a new dataset and use the "Replace dataset" function in a workbook. If you have a lot of workbooks using the same dataset, this may not be a good work around.

I can't think of a reason this should happen. I can reproduce it for my OAC as well. [Update] -- it is actually working as expected. The difference is that the export to excel works for just one visual. When you select the visual in the canvas ... this let's the export button in the chrome know that you are able to export…

CSV is a view of the data in a simple row/column format. Can you create an example from sample data of what you are looking for? The purpose of supporting excel format is to allow things like a pivot table.

You can do this today in the dataset if the formatting applies to all of your workbooks. Have you tried this approach?

Thanks Dan. Understood. Right now there are still things you will need to do with the command-line or admin tool. Semantic Modeler is a work in progress!

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.