Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Selecting default values for filters without using parameters

Delivered
124
Views
2
Comments

With the understanding that parameters was just delivered and there are potential improvements coming, there is still a big gap in functionality between what it can do as far as setting default values in filters versus what is possible in Classic.

While the parameter feature does mostly allow default values in filters, it is still a very messy solution that is not easily implemented. Having to use a logical SQL statement instead of just selecting a server variable name is sometimes difficult.

Additionally, even when creating these default values with parameters, that the filter value list does not change based on other selected prompts is not workable. In classic, if I set a default value using a server variable it works and selects that and the list of available values will change depending on other filter/prompt values selected.

For example, our business unit structure at UTA goes College/Division -> Department -> Cost Center. By default, we show people the data for their single department using a server variable on all Classic dashboards. They could then set the College/Division to their unit, use the drop down on Department, and only see departments in that College/Division. Likewise, if they used the Cost Center prompt drop down, it would show only the cost centers belonging to the selected department. Using parameters to set the default value on an on-canvas filter ignores the other filtered values and does not impact them and what they show either.

This same level of functionality is still needed in DV. Ideally, we should be able to select Server Variable in the Default Value for an on-canvas filter in the settings pane, shown in the screenshot below.

image.png

I do also want to add that parameters is a wonderful feature and does greatly improve the product. I understand that it was a significant amount of work to implement and I do greatly appreciate the attention that was paid to it. It's just that in this particular use case, it is still far from the ideal solution.

2
2 votes

Delivered · Last Updated

Comments