@Dhaval Parikh Stantec - do you have some additional context here? I assume you mean creating an LSA. Overall LSAs are very similar to just using an SA directly. Perhaps you can explain an example where you see a different in performance (such as adding joins, joining across sources, etc.)

Hiding to clean up the homepage is a good suggestion. The ability to control what the users can see in a dataset — should be done with role-based filters. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/role-based-filters.html However, it may also be useful to share a dataset and not have it show up on the…

For trouble shooting… a good place to start is make a calculation for each state and list the detail. Once you feel the calc is working as expected — you can add the sum on top. So start with three calcs and put them on the same chart to see the low-level grain.

This is a useful suggestion. Could you leave this as a suggestion in the Idea Lab? https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

Can you post a picture of the experience you are looking at? This could be a few places such as the dataset editor "quality insight" tiles which do provide a sample/estimate or in the grouping dialog? Or it could be when you are working in a workbook after creating the datasets. We want to understand the ask and need a bit…

For a new idea, search here to see if it is already been submitted. If it has, please vote for it and add a comment if you have other input. If not, please create a new one: https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

@Branden Pavol just during development … like a "save a temporary dataset at this point and proceed from here" type of thing? Would just sample data be enough? A not great work around today would be to save that data flow and then start another one at step 6. But then you would have to put them into a sequence to run "End…

Current Admin tool does support analytic views. https://www.youtube.com/watch?v=pmhVGvEB98k Semantic Modeler has AVs on the roadmap but it is not yet available.

@Branden Pavol - this would be good as a separate idea as it would be delivered into the APEX experience and not directly in a workbook.

You can also use the "treat as attribute" option if you only want the details for one chart and "sum" everywhere else. In OAC, measures default to a calculation. Some tools always start as "attribute" and then only aggregation per viz.

For now a workaround may be an Expression filter with an IN expression

It can be set in your Profile.

An example would be helpful here. Here is a demonstration of the forecast and trendline functions. You can see in the top two charts that add "data from the previous year" has a big impact on the forecast. So, in general, it is working. In this case — 3.8M (with previous year) vs 4.8M (the current year only)

Today — the number of parallel jobs is limited by your OCPUs. You can increase parallelism by adding OCPUs.

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