Working with Live Widgets
  • 18 May 2022
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Working with Live Widgets

  • Dark
    Light
  • PDF

After you have published your live model, you can begin to create visualizations, like you would with any other data source. See Creating Dashboards and Introduction to Filters for more information.

In Sisense , live data sources have the icon next to their name.

8-6livemodelsourcethumb0300.png

While you can create dashboards from a live data model like you would from an ElastiCube, you can also add live data models as a data source to a dashboard that already has a data source, such as an ElastiCube. When you have multiple data sources working together on a single dashboard, the data source and the widgets built on it operate independently of each other. This allows you to view widgets that visualize time-sensitive information in addition to widgets that are refreshed less frequently. For more information about adding multiple data sources, see Changing a Dashboard’s Data Source.

In terms of governance, all existing access rights settings and data security settings can be applied for live connections.

When and How Data is Refreshed

The most significant difference between dashboards built on ElastiCubes and dashboards connected to live data sources is when and how your data is refreshed. With an ElastiCube, you refresh the data when you build an ElastiCube and query the ElastiCube. With live connections, queries are run directly against the data source. Sisense uses the connection settings and credentials in the data set to query the live data source. This means that you don’t have to wait for an ElastiCube to finish building before you see the results. This is useful, for example, when displaying a dashboard on a wall-mounted monitor where the data is automatically refreshed. Each time a refresh occurs, your live data source is queried, so it needs to be able to handle the refresh rate you define.

8-6add-live-connectorthumb0300.png

Refreshing a Data Set

There are several ways in which you can refresh a widget build on a live data model, depending on your Sisense user role.

Administrators manually define the refresh rate (in seconds) and timeout for each data set from the Data Sources tab in the Admin page of Sisense. After the refresh rate is set by the Administrator, no user can set a refresh rate that is shorter than the rate set by the Administrator. Administrators can manually refresh the data set from the Data Sources tab in the Admin page.

8-6refreshadmin.png

Designers can refresh a widget from the widget’s information window . Designers can reduce the frequency of data refreshes or stop automatic refreshes on a per-widget level, but they cannot increase the frequency of refreshes beyond the threshold set by an Administrator.

8-6refreshwidhgetthumb0300.png

In addition, Designers can reset the Refresh Rate, however, the rate cannot be lower than the default rate set by the Administrator.

Like Designers, Viewers can refresh a widget from the widget’s information window, but they cannot modify the refresh rate.

8-6viewerrefreshthumb0300.png

Any user can refresh a widget. However, you need to wait a minimum of 10 seconds from the start of a refresh before you can refresh the widget again. Refresh requests within 10 seconds of the previous refresh will be ignored.

Canceling a Refresh

If you have a refresh that you want to cancel, you can cancel it by clicking Cancel in the widget’s information box.

This button is displayed only when a refresh is in progress.

8-6cancelrefreshthumb0300.png

If a user leaves a dashboard (for example, to view another page in their browser), Sisense pauses the query.


Was this article helpful?