Refreshing Dashboard using Scheduled Workflow

Refreshing Dashboard using Scheduled Workflow

The dashboards that you create are static, meaning the dashboard views do not change if the data they represent is changed. For this, you can use the refresh function provided by RubiSight. Refer to Refreshing a Dashboard.
However, there can be instances that data keeps changing often, and the dashboards that are plotted using that data need to be auto-refreshed without any user intervention.

You can achieve this auto-refreshing of the dashboard by scheduling workflows.
The auto-refresh of dashboards involves two main steps:

  1. Create Workflow for Cache Refresh
  2. Schedule the Workflow to run at a specified time interval

To enable auto-refreshing of the dashboard by scheduling workflow, follow the steps given below.

  1. On the home page, click the Create icon ().
  2. Hover over the Data Integrator tile and click the Create Workflow button.



    Create Workflow page is displayed.
  3. Enter the Name for your workflow.

  4. Enter the name in the Project field to create a new project.

     Notes:

    • The workflow is created under the entered project name.
    • You can also type the name of the existing project in the Project field to select the project.
    • The project name is mandatory.
  5. Enter the Description for your workflow.
  6. Review all fields and click Create.



    The workflow is created, and the workflow canvas is displayed.
  7. Follow the path (Data Integration >> Control >> File >> Orchestration >> Refresh Cache) from the left Task Pane, drag and drop Refresh Cache on the workflow canvas. 



  8. Select the Refresh Cache node.
    The properties pane is displayed on the right side.

  9. From the Select Datasets drop-down, select the datasets for which the cache needs to be refreshed.



     Note:

    You can select more than one dataset.

  10. After selecting the datasets, click Done.
  11. Hover over the Refresh Cache node and click the ellipsis, and then click Run.



  12. Schedule this workflow. Refer to Scheduling a Workflow.
    After the schedule is successfully created, the workflow executes at the specified time interval, and the dashboard is refreshed based on the latest data.

Notes:

  • If any of the datasets selected for the Refresh Cache node are not consumed in the dashboard, an error is displayed in the Log Trace.
  • If you do not select any dataset for the Refresh Cache node, an error is displayed in the Log Trace.

    • Related Articles

    • Refreshing a Dashboard

      Refreshing a dashboard helps you fetch the latest data and display the most current views. To refresh a dashboard, follow the steps given below. Open the Workspace that includes your dashboard. Refer to Changing Workspace. On the home page, click ...

    • Refreshing Metadata of Dataset

      Rubiscape supports the Metadata Refresh feature for datasets, as listed below. Google Spreadsheet dataset RDBMS dataset File type dataset from AWS S3 cloud storage Applicable to all flat files (Excel, CSV, JSON, Text) This feature is available in ...

    • Using Dashboard Hierarchies

      In a data dictionary, you can rearrange or change the order of the features in the newly created dataset using the Hierarchy function. The created hierarchy is used in the RubiSight application. To use the created hierarchy in a dashboard, follow the ...

    • Export Dashboard Schedule

      In RubiSight, you can export a dashboard using the Export functionality. Refer to Exporting a Dashboard. You can not only schedule this export, but also send the dashboard pages as PDF via email, at a stipulated date and time. Notes: You can schedule ...

    • Using Miscellaneous Features in Rubiscape

      As a user, you should know some of the basic activities that you can perform on the Rubiscape home page. You can change the view of the items on the home page from card view to list view and vice-versa. You can set a dashboard, workbook, workflow, or ...