Got it. The overall improvement is still needed. Datasets should reference the same column as the alias — unless you use "Edit definition." In this case, it will drop the missing columns. There is an improve to warn about this and help you fix it up. Ping us if you have a dataset that is referencing an alias (without being…

If you are renaming and create an alias in the Subject Area — queries will keep working. If there is a case where the alias exists and it is not being used — we should look at that in the SR. If you are removing things which should not exist and were used — you will need to create a list for users to change their workbooks…

Understood. This in an improvement to the edit definition experience to highlight changes so a user understands if they want to proceed or if they should cancel and fix the source/input file first.

You can accomplish this on the "Edit Definition" screen when editing the dataset. This is how you "change the columns being input into a dataset." If we mis-understand the scenario, please provide another example.

This appears to be looking for a way to add a dimension extension. I think you have two choices. Add it to the subject area as a dimension extension or create a dataset and do blending. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/work-workbooks-datasets.html#GUID-366E6952-2B1A-4729-8CD0-129003672EB5

Resources is a bit vague here. Most customers enable Usage Tracking and use query performance by dashboard/workbook as the main method of identifying where to focus improvements. Would sorting workbook queries by either the most frequent or longest running be close to what you need?

Ok — it looks like the OS settings were as expected but OAC / DV was picking up the formatting from the browser's locale. Look in Settings \ Languages and make sure the formatting you expect is at the top.

Right — with Semantic Modeler — you have to create connections in OAC (similar to datasets) and mark the System option. Then you can use this in the Semantic Modeler and update the connection pools, etc.…

Can you explain the scenario for this? Reports don't have Job IDs in OAC. Is this a Fusion issue?

I haven't seen this problem before. Can you create a simple repro with an excel sample file and share a screen shot?

JDBC support is on the roadmap. The next OAS update will be in early 2025.

Is there a reason this can't added to either the data source or a 2nd dataset that you blend on the data tab? The parameters feature is not intended as a source of data but more as a tool to help you create experiences in the workbook.

@Teemu Jutila You can paste in formatting in to the Text viz. Is that what you are referring too? If not, can you explain in more detail or post an example of the kind and source of the formatting you are looking for?

What does the Cumulative count mean hear — year to date? For example if you pick may and have data from Dec 2021 — should that be in the amount?

You can also implement data level filter with roles in datasets. https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-role-based-filters/#step_three

I think this is a duplicate of the following. Can you confirm? https://community.oracle.com/products/oracleanalytics/discussion/21603/need-rest-apis-to-create-custom-application-roles-in-oracle-analytics-cloud

There are few ideas in this topic. The main one seems to be "a common homepage" which is being planned.

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?