Composite Data Source


Apps - Datasource - Composite icon.png This type of data source belongs to the Standard category in the data source library. It enables you to merge information from several data sources. The link is created through a common column in different data sources.

Notes

    Open url.png  see General remarks on data sources

  • As a general rule, the Composite data source contains one Dimension column corresponding to the reference column. There are one or more Measure columns corresponding to columns from the different data sources associated with it -  Open url.png  see Standard data source structure
  • All of the data sources associated with the Composite data source must have the same grouping criteria.
  • All of the rows for each element in the Composite data source are processed when merged. If reference values are missing for an element, the row is still generated in the Composite data source with unspecified values for this element. See the example.
  • Each modification made to one of the elements in the Composite data source will automatically update its data.
  • If you delete an element in the Composite data source, you only delete the association. The original data source will still remain available in the data source library.
  • The Composite data source inherits the automatic refreshment interval of each of its elements (Auto Refresh property).
  • You can rename the columns of each element in the Composite data source. The name will not be modified in the original data source.

Example

You want to build a Composite data source that groups the number of incidents (data source 1) and the number of equipment (data source 2) by location (reference column).

  • Data source 1: Data related to the number of incidents by location.
  • Data source 2: Data related to the number of equipment by location.
  • Composite data source:
    • Reference value San Francisco from data source 1 does not exist in data source 2 ==> one row is generated in the Composite data source with an unspecified value for the number of equipment.
    • Reference values Cambridge and Dallas from data source 2 do not exist in data source 1 ==> 2 rows are generated in the Composite data source with unspecified values for the number of incidents.
Data source 1 Data source 2 Data source Composite
EVApps - datasource Composite - Example Datasource 1.png EVApps - datasource Composite - Example Datasource 2.png EVApps - datasource Composite - Example Datasource Composite.png
Download Zip icon.png Download Example (CSV files)

List of properties

Content

Name: List of elements associated with the Composite data source.

  • The drop-down list displays all of the data sources available in the app library that are not yet associated with the Composite data source.
  • Click on Apps - Delete icon.png to delete the association of one of the elements with the Composite data source.

[ ADD DATA SOURCE ]: Used to add a new element to the Composite data source.

[ CUSTOMIZE LABELS ]: Used to select the reference column that creates the link between the different elements in the Composite data source. Also enables you to rename the columns of each element-  Open url.png  see Procedure

Preview

Configure Field Types: Used to display a preview of the structure and data from the data source via a data editor. 

  • The button Apps - datasources Properties - Preview button.png displayed below the property indicates the number of extracted rows (up to a limit of 15) and columns. Click on it to open the editor. Open url.png See the Description.
  • The button will display No data available as long as you have not selected any of the mandatory elements of the data source.
  • In edit mode, only the first 15 data source records are displayed.
  • In execute mode, all of the data source records are displayed.
  • Data in static data sources comes from the last file upload.
  • Data in dynamic data sources is updated when you open the app in edit mode.
AutoRefresh

Auto Refresh (Note: Only for dynamic data sources): Used to indicate the automatic refreshment interval for a dynamic data source. The frequency is expressed in hours/minutes. The updating of data is done in execute mode or edit mode, each time the app is run and each time the page is redisplayed.

    Best Practice icon.png

  • Because the updating of data requires additional activity on the EasyVista Service Apps platform, you should define an automatic refreshment interval only if the app is required to constantly display  real-time data for long periods of time on a screen.
             Example documentation icon EN.png  Dashboards
  • You should not define an automatic refreshment interval if the app is only used for displaying a snapshot of data for short periods of time.
             Example documentation icon EN.png  A portal for consulting catalogs
SelectFirstRowAsCurrentRecord

Select First Row As Current Record: Used to indicate if the first record of the data source, when displayed in widgets, is selected by default (box is checked) or if no record is selected by default (box is not checked). 

NoDataMessage

No Data Message: Message displayed when no data is returned in the data source. Enter the code directly in the field or click Apps - Edit Html icon.png to open the text editor

Procedure: How to define a Composite data source

1. Create all of the elements you want to use in the Composite data source in the data source library.

2. Click on Apps - Add datasource icon.png in the Objects pane, and then click Composite Data Source. The Properties Inspector will appear.

3. Select the first element of the Composite data source from the Name drop-down list.

4. Click [ ADD DATA SOURCE ]. A new record is added. Select the element you want from the Name drop-down list.

5. Repeat the procedure to add other elements to the Composite data source. Note: You can delete the association of one of the elements by clicking on Apps - Delete icon.png.

6. Click [ CUSTOMIZE LABELS ]. All of the columns for each element in the Composite data source will appear.
         EVApps - datasource Composite - Composite Setup.png

  • For each element, select the reference column that will create the link with the other elements and click [ OK ].
  • To reset the reference columns for each element, click [ RESET KEYS ]. The checkboxes for all of the columns will be unselected.
  • You can rename the columns of each element. Enter the new name in the corresponding field. To cancel and reuse the original names, click [ RESET LABELS ].

7. Click Preview to see the result of the setting you specified.

Tags:
Last modified by Unknown User on 2017/09/01 16:44
Created by Administrator XWiki on 2014/11/12 22:08

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018