Versions Compared

Old Version 21

changes.mady.by.user Radek Micka

Saved on

compared with

New Version 22

changes.mady.by.user Ondrej Špalek

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

Joined data sets allow you to analyze data from more data sets together and therefore use data from more data sources in a single report.

Tip

The principle is similar to joining SQL database tables.

Creating Join

To create join in BellaDati:

  1. Navigate to one of the Data Sets you want to use in join
  2. Click on Joined Data Sets in Settings section of the left action bar
  3. Choose Create Join
  4. Select Data Set to be joined with

 

Join condition

Each join has to have specified following parameters:

  • Name: Joined data set name.
  • Join with: Name of the source data set to join with.
  • Join condition: Date/time in both records are taken in account or not.
    • With Time Match: Date/time in both records are taken in account.
    • Without Time Match: Date/time in both records are not taken in account.
    • Custom: Cross join with option to specify own condition.
    Join type: Standard join types available - match always depends on attributes.
    • Left outer join: Record in the target data set is not mandatory.
    • Inner join: Record in the target data set is mandatory.
    • Cross Custom join: No User can define own joining condition. If not specified, no attribute match is required (Cross join).

Info

The resulting joined data set will contain all the attributes and indicators from all source data sets.

Custom Join Condition

BellaDati allows you to define you own joining condition. To do so:

  1. Select Custom in Join Condition
  2. Cross join will be automatically applied
  3. Type joining condition to restrict the output
Tip

BellaDati offers you autocomplete to easily construct joining conditions.

Multiple Join Points

One data set could be joined with more data sets (eg. join by department ID to get department full name, address, country, total sales and then join by product ID to get products name, price, weight and mass). Each join is called join point.

To add another joining point into existing join:

  1. Click on add joining item
  2. Select desired Data Set
  3. Continue with Join Conditions

Joining Facts and Restrictions

Info
  1. Data in the joined data set will be the intersection of all joins.
  2. Data in joined data sets are updated automatically when data are changed or imported to the source data sets. You cannot import data directly to the joined data sets.
Note
  1. Please note, that the permissions setting based on data filter has to be set for both (source and joined) data sets!
  2. Data join is also available on data source level (database). Please consider this option when you plan to analyze millions records of data. Joining on database level may provide better performance.
  3. Joined data set is rebuilt after the import into one of the data sets which is joined. All data sets which are used in this joined are locked during this time - import into these data sets will not run.

User can add join when:

  • User can edit data set (Domain Admin, Data Set Owner, Data Set Editor). Data set editor needs to have enabled the edit access as user or user group.
  • No data filters are set in sharing (USER nor USER_GROUP nor ATTRIBUTE_FILTER).
  • On-demand synchronization is disabled.
Available data sets to join: 
  • All the user can access (even in read-only mode).
  • Must have the same storage type (local or remote, if remote, location must be the same).
  • No data filters are set in sharing.
  • Partitioning must be disabled.
  • Cannot be joined data set or big data set.

Joined data set supports these functions the same way like in ordinary data set:

Tutorial video

Widget Connector
width853
urlhttps://www.youtube.com/watch?v=Q5awkTjZsE0
height480

Next Steps

...