The improvement is on the roadmap. We don't have a target release date yet.

The enter manual SQL option in OAC doesn't support all SQL syntax. I would expect it to give you and error and not allow you to save the definition. If you have database access, implementing a view is a good work around and they you will do a pretty simple select in OAC. And Idea Lab suggestion on support either JSON…

Can you elaborate on Map to Table? You can switch viz type from map to table today. What is missing?

This is a useful improvement. A few things available today — you can use APIs to do backup/restore of snapshots. You can also look at the fullstack DR offering.

Does the Row Expander extension help here?

@User_0MSAU I am asking — if you rename XLSX on your hard drive and then upload it… does that work? The fact that it works when replacing the file when editing the data flow makes me think there is an issue with renaming the file. If so — then the two work arounds would be: 1. Edit the data flow and replace it there 2.…

If you rename the "input file" to the same name as the original file name — does it then work?

This seems useful!

Have you considered adding a prep step in a dataset or subject are to convert to an easier to use format? Usage tracking is logged in UTC for clarity on the meaning. This can be easily handled in queries or at the reporting level. For example you could use: TIMESTAMPADD(SQL_TSI_HOUR, +12 ,TIMECOLUMNHERE) 

@Dave Kekish — are you looking to have this surface in the ERP application direclty or in a report? If in ERP directly — this idea probably belongs in a Fusion specific idea area as it would need to be surfaced by the application. Such as:

You could implement with your own security filters which include data effective information in DB tables. Would that allow you to implement it today?

The UI was updated to have a profile icon with your initials or a profile picture. This was a general improvement in OAC and OAS and part of the UX updates. What is your goal with seeing the full username?

@Gianni Ceresa - please open and SR so we can do a deeper dive on the details and start an investigation. We appreciate the feedback here and would like to get to the bottom of it.

If you want a different year -- you will need to have the viz ignore the workbook level filter and then add a new filter either to the canvas or at the viz level. Depending on the goal you could use extract year in a calculation to make it easier for a user to pick different years. Here are list of things you could use by…

That could work. Say your year for the filter is 2024 (the session variable above). Then if you look at table such as "Termination date" you can filter it like this YEAR(Termination Date) = 2024. This would return just terminations in the year 2024. I am not sure what you mean by global in this context. A report or…

@E. van der Poel-Oracle this feature does work and is tested. I recommend creating an SR to investigate what is happening with your situation.

Is this for Oracle Analytics? Perhaps this was meant for an ERP forum?

@Manu R-Oracle which assets do you want purge. Subject Areas tables for example allow you to configure caching rules/behavior. For example, datasets and OAC data flows allow you to schedule reload/runs. There are lot of assets in OAC and it is not clear which you want to control. Can you add some details on the types of…

Have you tried using keys per: https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File

@JasonJang-Oracle Excel would work. As an alernative -- copy data and then paste in to a CSV will do this: