There are times when users want to clear all selections and return to the default state on a Dashboard. In SAP Dashboards, this can be achieved by using the “Reset Button” component. Although the “Reset Button” is of great utility in many scenarios, it has its limitations when it comes to resetting just parts of a Dashboard. Here is a simple trick you can use to overcome this limitation using the “Push Button” component.
Push Button: The “Push Button” inserts specific data each time it is clicked. It can be used to allow users to restore single value components to their default values without resetting the values for the entire model, or to create a pop-up window that appears when the button is pushed. You can configure the “Push Button” to set the values of one or multiple cells to specific values when users click the button. The values change only when the user clicks the button, so users have more control over when the data is copied to the destination cells.
OK ,So let’s get into the detailed part.
1.Master Reset Button:-It is very much simple Reset Button.
2.Job Reset/Division Reset Button:- It is a Push Button implemented specially to build the Reset functionality.
So,now just look into the dashboard what it resets.It resets the drop down selection of the particular section to All Jobs/All Divisions when clicked on the respective Reset button.
Example;- Suppose for Job Functions Combo,we select the Facilities and for Divisions combo we select Asia Pacific.Now if we click the Master Reset button both the combos change to All selection. But if we click on the Job Reset or the Division Reset it resets the particular section only depending upon the button selection.
Now lets look into details how we can achieve this functionality for the Custom Reset.
Take the example of Job Reset button because both the Custom Reset buttons are build on same functionality only.
- Identify the range of data on the Excel model that you want to set as default.
- Configure the “Push Button” component so that it uses this data as a source and inserts it in the designated destination range.
- Use the destination range to build your dashboard.
First look into the binding of the Job Drop down
So based on the selection from C11:D25,the data gets pasted into C10:D10 which is the destination.This D10 cell’s data is the Selected Item of the dropdown.So,to achieve the Reset Functionality we need to somehow paste the C11:D11 data into C10:D10 row.
This functionality is done by the Custom Reset button.
So,let’s look into the binding of the Push Button which we are using as Custom Reset button.
So what its doing ,it is bring D11 cell’s data i.e “All Job Functions” to D10 to make the Reset possible without touching the Other section’s data.
This way whatever changes during the Dashboard run-time will be reset to default when you click on the Push Button.
This trick can only be used to reset components which have the property to bind the “Selected Item” to the underlying Excel model. (E.g. Works for a Combo Box, but not for a Check Box)