This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Combine several data sources in one report

In some cases you may want to create a report that uses data from several sources. If these datasets cannot be merged on data source level for some reason (with data integration techniques) you still can do that with these built-in SeekTable capabilities:

These capabilities are implemented as special functions of expression-type cube members.

External lookup

To resolve external lookup create expression-type dimension and use this function:

Cube("cubeId").Lookup(value,"keyDimension","lookupDimension")

where cubeId is an identifier of the cube you want to query (you can get this ID from URL of the cube view), value is a 'foreign key' that need to be resolved, keyDimension is a name of dimension in the cube that matches 'foreign key', lookupDimension is a name of dimension that contains a value to resolve.

Typical usage scenarious:

Notes:

Combine measures

To combine measures from different cubes create expression-type measure and use this function:

Cube("cubeId").Measure("measureName", dimMappingDictionary)

where cubeId is an identifier of the cube you want to query (you can get this ID from URL of the cube view), measureName is a name of measure you want to get (measure names are present on cube configuration form), with dimMappingDictionary you can define a mapping between dimensions of source cube and target cube if they don't match, for example:
new dictionary{ {"timestamp_year", "date_year"}, {"timestamp_month", "date_month"} }.

With this capability you can define formulas that involve metrics from different data sources. For example, for report that displays actual sales or profit per period you can define 'planned' values with CSV and then calculate absolute or relative difference.

Notes: