Tips and Tricks

Adding Multiple Data Sources to one Workbook

Multiple data sources can be added to one workbook. Generally, navigation starts from one particular data source in Visual Explorer and then base a workbook on this data source. It is possible to have more than one data source in a workbook by selecting data from "New Data Source".

131535054987.png

Using VFC to add Sample Data

Follow these steps to add Sample data:

  1. In the Asset Manager, add an asset with a particular "Type".

  2. Write data in the asset from the Visual Flow Creator and the available corresponding nodes.

  3. Create a periodically updated data source in Visual Explorer Connector.

Row-level Security

The data sources created by Visual Explorer Connector enable Row-level Security, it protects against the ability to share dashboard among multiple users. Records in a data source belong to assets. Assets displayed on the dashboard are dependent on the logged-in MindSphere User. This enables the users to access different data from the same dashboard at the same time. An OEM can create a visualization for a Fleet and transfer it to subtenants, the subtenants can access assets that are enabled for them.

Dealing with Numeric Overflows

By default, Tableau® aggregates measure type values. With every Drag and Drop of a measure from the left side to the visualization, Tableau® tries to sum up the values. This is not convenient with multiple values and when a single value is not distant from the numeric limit of a variable type. For instance, many epoch time stamps may easily exceed the long integer data type. In this case, circumvent the aggregation by first converting the measure into a dimension. Drag it in the left panel from "Measures" to "Dimensions".

130946397835.png

Update a Fixed Range Data Source

Switching between the update modes at any time is possible by editing the data source configuration. Data source without periodic scheduling can be updated by editing it and saving it with the same parameter. Even without changes to the time range, the data source is treated as a new source and accordingly scheduled for updates.

Dealing with Limited Amount of Data

MindSphere limits the amount of data per data source, as the Tableau® server cannot optimize too much data at the same time. The User Interface shows the upper limit of records per data source. Processing a data source requires some time and for some frequencies, different limits apply in the continuous mode. These are listed in the User Interface. However, in some cases these limitations may be too conservative. Therefore, Visual Explorer provides a way to override the limitation, refer to the section "Choose update mechanism". Although higher limitations may be feasible in the particular use case, it is not guaranteed that the data transformation process will finish in time. You need to verify whether the update performance is still within the tolerances of the dashboard. To work around those limitations, MindSphere emphasizes on the following points:

  • Pre-processing the data with a different tool such as Visual Flow Creator.

  • Selecting a shorter time range.

  • Dividing the data into multiple sources: one source with much data, but low frequent updates, and another data source with only the latest data, but higher frequency.

Collaboration

The ownership of a workbook lies with the creator. This means that nobody other than the creator can introduce any changes. To change this, the creator must explicitly set permissions. There are two ways to do this:

  1. Workbook ownership can be transferred to another user.

  2. Fine-grained permissions can be assigned.

Both options are available in the corresponding menu in the workbook list.

130946693643.png