(Showing Draft Content)

Selecting a Dataset

<!-- Selecting a dataset is the preliminary step before you start designing a dashboard. When you create a dashboard, you drag-drop the scenarios to the design area. It is only after adding a dataset and binding attributes to these scenarios, that the scenario is meaningful. You can add multiple datasets in a single dashboard and bind different datasets to different scenarios. -->

A dashboard is made up of multiple scenarios. Each scenario in the dashboard is bound to a dataset or model for data visualization. Different scenarios can be bound to different datasets or models depending on your business requirements.

When you create a dashboard, you drag-drop the scenarios to the design area. It is only after binding data to these scenarios, that the scenario becomes meaningful.

To Bind Data to a Dashboard Scenario

Follow the below steps to bind a dataset or model to a dashboard scenario.

  1. Drag and drop any scenario onto the design area of the dashboard. Note that the Data Binding panel automatically expands as shown in the following image.

    Adding a chart in the dashboard designer

  2. From the Data Binding panel, choose the suitable dataset or model from the list. With the Wyn Enterprise release version v7.1, direct datasets are now available in the data binding dropdown list. See the Bind Direct Dataset section for more information.

    Note: For the direct datasets, note the following,

    1. In case the dataset can be converted into a direct query data model, the system generates a direct query data model to establish a direct connection with the data source of the dataset and execute queries against it.

    2. If the dataset cannot be converted into a direct query data model, the results of the dataset are loaded into memory. Subsequently, a direct query data model is generated, and the result set is stored in the memory.

Choosing dataset from the dropdown list

Once the dataset or model is loaded successfully, you will see the measures and dimensions available in the dataset.

Measures and Dimensions in dataset

Bind Direct Dataset

On selecting a direct dataset from the dropdown list, you will have the following options,

  1. When the dataset directly incorporates user input parameters, you have the option to assign a value to these parameters within the dashboard. These assigned values can then be used for query purposes.

  2. Use the settings icon next to the search box to configure and set the parameter values.

  3. Configure the Cache Settings for direct datasets referenced by dashboards from the info panel. Within the Info panel, proceed to the Caching section where you can enable the Allow Caching flag. Additionally, specify the Caching Interval and select the appropriate unit for the interval.


See Also

Introduction to Datasets

    Introduction to Direct Query Model

    Introduction to Cached Model