Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Using mashups allows you to easily customize your extracts by adding data from other data objects.

By default, the mashups store their data in cache and do not require repeated database requests. In cases of large volumes, this can mean huge performance improvements. The way cache is built and managed for each mashup depends on its cache policy, and is defined in the Data Object's properties.

On this page

Table of Contents

Add a Mashup

After

you  for

 for your interface and click Create, you see the EDS Worksheet.

The

The main Data Object you chose is at the left and the Taxonomy is at the right.

To add a mashup to the current interface, you can select an available Data Object from the Shapes toolbox on the left and drag it to the canvas. See the example in the following figure, where you selected

warehouseposition

warehouse position as your main data object and then select Generic SMF.

Image Removed
Warehouseposition Main Data Object and Select Generic SMFImage Added

View Key Expressions

Key expressions used to join the mashup to the main data object are automatically populated for you.

To see key expressions, click the caption next to each key box. See the following figure. 

Image Removed
Caption Next to Key BoxImage Added

The keys are different for different mashups. For example, the key for the SMF mashup contains Security Alias, for Generic Entity it is Entity ID, and so on.

Add Fields from the Mashup to Your Output

To add fields from the mashup to your output, drag them from the mashup data object to the Taxonomy grid. See the following figure. 

Image Removed
Drag Fields from Mashup Data Object to TaxonomyImage Added

On occasion, you may need to use same mashup multiple times. For example, you may need to use the same mashup multiple times to run different code-translations.

Rename Mashups

To give your mashups meaningful names, you can rename them by right-clicking the window header and clicking the Rename option from the shortcut menu.

Image Removed
Rename Option in Window HeaderImage Added

Unclutter the Worksheet

If your interface needs many mashups and the worksheet becomes cluttered and busy, you have two options:

  • You can collapse the mashup by clicking the Image Modified Collapse icon in the mashup header.

  • Another option is to completely remove the mashup control from the canvas. To do so, right-click the mashup header, and then click Transform to inline expression. After you see the confirmation box, the system converts the expressions for this mashup to the form that does not require the mashup object itself. See the following figure. 

Image Removed
Transform to Inline ExpressionImage Added