What does the calculation your are looking to do mean in general terms. For example if you have: Week Date ID Planned Week Number 7/28/2024 A 0 31 7/29/2024 A 1 31 7/30/2024 A 1 31 8/8/2024 A 1 32 8/9/2024 A 9 32 For Week 31 -- do you want 1 as the answer? For Week 32 -- do you want 10?

@Rajakumar Burra — it is not clear why you need to add all the datasets here. One note is that when a dataset is in a workbook — the workbook assumes all the columns can be used together. So you are both managing datasets and also defining where joins work. It might be worth a call to learn more. Since the dataset is…

@User_FBG8L this seems like a related but useful idea — allow a step (perhaps at the add data stage ) in a data flow which allow experessing a manual sql. Can you create a new idea entry so it gets its own votes?

What is the scenario here? Today the data flow generates a query (such as where mycolunm > "last updated time" ) What would you want to happen for an alpha numeric column?

Can you confirm you are looking for workbook style search on the dataset Edit Definition page?

@MGibbs_2023 — if this were an option in the dataset editor — is that sufficient? @Luis E. Rivas -Oracle This seems useful.

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. https://docs.oracle.com/en/solutions/oracle-analytics-cloud-disaster-recovery/index.html

Does the Row Expander extension help here? https://www.oracle.com/business-analytics/data-visualization/extensions/

@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) 

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…