This is a good enumeration of the key capabilities needed and that they are required for OAS.

Michal ... might be worth to discuss. With this example, you could create a specific dataset or dataset table with the complex calculation (or even a DB view) ... making the logical SQL simple where you are just grabbing a simple item in LSQL.

No timeframe to announce. We will change the status when we start development and again once we ship it. It is a bit of a ways down the dataset improvements list and for now I would implement the work around if you can or create a Subject Area for this use case.

Michal -- can you give an example? You can use logical sql to initialize a parameter. That logical sql can reference a dataset. Would that work?

We are investigating how we can add an alternative sort column. For now the work around is to add the column to the visual and set the sorting on that extra column.

Have you considered data actions for this scenario?

To understand a bit better, you want to pass the hierarchy as an object and then set the value/level in the destination. Is that right?

Try using the classic catalog permissions per Subject Area. Deny to the groups which should not be able to author. Administration Security -Manage Privileges Manage privileges and rights given to users and groups. The path is <OAC URL>/ui/analytics/saw.dll?Admin

In the September release, we added an option to "go right to editing" the metadata. The profiling and recommendations will still happen but move to the background. Many sources are fast and this is not necessary but some sources or tables take longer to profile and this can help.

It is not clear if you followed all the steps. Any more information about what you did -- how you got the URL, if you applied the client updates, which version of PBI desktop you are using?

Assuming you are using a dataset, to trouble shoot, I would create a new dataset from the tables and see if that has the old information. If it does, then it is likely something in the DB. IF that does work -- it is not clear when Live would not get the latest information. Be sure all tables in the dataset are set to live.

The message is saying the query it taking too long. If your report creates a query that is too slow from the source system - you can try creating separate charts or you can see if adding a filter such as per employee is sufficient. For example, make a list of employees and then have a drill through or details chart with a…

We definitely have customers that build analyses like these. You have a few options. First -- you can put the raw data in to its own dataset or table. Then you can build calculations off of these data points. Depending on the calculations -- data flows can help. They are especially useful for changing the grain of the…

At the moment you can hover over the Oracle Analytics in the about box.

This seems like an idea -- could you post https://community.oracle.com/customerconnect/categories/idealab-oracle-analytics-cloud-and-server

You should create an SR. If you have deleted an instance or let your tenancy expire -- the OAC instance should no longer be available. You should work with support to determine your options.

We are working on APIs to allow you to automate this scenario. https://community.oracle.com/customerconnect/discussion/510521/api-for-oac-snapshots

The Union functionality currently has this limit. In your situation --you may want to try creating one datasets with multiple tables or use blending. In data flows today - the Union operator is trying to create a fully denormalized data table in the flow. The other option you have is to add and select columns to each side…

This looks like a general database tuning situation. The numbers might be a bit misleading as the query time is 0 which is unlikely. In this case -- I would start by running the same query generated by OAC against the database directly and seeing how long this is taking. To get help with trouble shooting here you can open…

There was an update to JET in 6.0. We will investigate if there is a tweak you will need on the javascript side.