In a Tableau-based report, such as the Budget Status Report or Project Status Report, you can set up your screen to show the data you want, then save the "view" so you can easily access it again.
You also have the ability to send a copy of the view to your inbox on a schedule of your choosing, called "subscribing."
In this article, you will learn the steps to set up a view in a Tableau-based report, then save it and subscribe/ unsubscribe to it. A subscription delivers the report to your email on a selected schedule.
This article uses the Budget Status Report by Department, Fund, and Account, but the tips can be applied to any Budget Status Report.
You can refer to the OIR Tableau Reports page for tips and tricks on Custom Views and more.
First, log into the Budget Management System.
On the Budget Status Report homepage, you can select all of the parameters for the report view (e.g., Department, Bud Ref, Fiscal Year).
Click the Department dropdown list.
Click the box next to the department(s) that you wish to include in the report.
Note: You can click as many departments as you wish.
Example shown here: " 14012345 - Sample Department 2" .
Continue to select the Department ID(s) that you wish to include in the report.
Note: You will need to deselect the current department if you don’t want it included in your results.
Example shown here: " 14023456 - Sample Department" .
Continue to set the parameters for the report.
Note: As soon as you change the parameter(s), the report view will be updated to match the selected parameter(s).
When you have the report view that you want, click the View: Original button to save your view.
The Custom Views dialogue box is displayed.
Enter a name for the report view that you want into the field next to the Save button.
Example shown here: " BSR - Sample Dept ".
If you wish to make the current report view the first view you see when you log in to the Budget Status Report, click the box next to the Make it my default option.
Example shown here: Make it my default option.
Click the Save button.
You can request a report delivered to your inbox with a schedule of your choosing by using the Subscribe option.
To subscribe to the saved report view, click the Subscribe button.
The Subscribe dialog box is displayed. Here, you can set up your subscription preferences.
The first option is what to include in the subscription.
If you wish to subscribe to the view you just created, elect the default "This View" option.
Next, identify a schedule on which you would like to receive the view emailed to you.
Example shown here:Schedule dropdown list.
You can select from six schedule options
Example shown here: Monday morning at 8:00am option.
After selecting your preferences, click the Subscribe button.
You can see a yellow box at the top of the page that confirms " Created 1 subscriptions ".
If you ever need to unsubscribe to your existing subscription(s), click the Subscribe button.
The Subscribe dialog box is displayed.
Click the Manage link in the bottom left corner to unsubscribe to your subscription(s).
The Budget Status Report - DFA page is displayed in another tab.
On this page, a list of users with their corresponding subscriptions appear. You can view who subscribed to a report view(s), which report view(s) has been subscribed to, the subject(s) of the report(s), and the schedule of the report(s).
Scroll down to find your name and the subscription(s) to which you wish to unsubscribe.
Note: Even though you can see other people's subscriptions, you do not have the ability to unsubscribe to them. Those options should be greyed out for everyone except yourself.
Example shown here: " BSR - Sample Dept " to which Clara Heys has a subscription.
After selecting a report(s), click the Actions dropdown list.
Click the Unsubscribe... option.
A pop-up message asks if you wish to unsubscribe to the selected report(s).
Click the Unsubscribe button.
You can see a green box at the top of the page that says " 1 subscription has been deleted ".
You can close the tab after you have unsubscribed to a report(s).
Click the Close button.
You are returned to the Budget Status Report homepage.