Varicent Incentive Compensation Management Documentation

Data stores

Data stores are objects in the Composer module in Varicent Incentive Compensation Management (ICM). You can use data stores to join sources, such as tables, calculations, and draw results, into one large repository.

For example, a data store can be used to pull together results that are required for reporting purposes into one object. The data store can then be used as a source in Presenter to build reports. Reporting users can then easily create reports as all the sources that they require are available in one place. All tables and calculations within the model can be used as sources in the data store, regardless of the component where the data store is located.

At a high level, the following steps describe how to create a data store:

  1. Add a data store object in the Composer module.

  2. Join the data sources that you want in the data store.

  3. Select the detail columns from the added sources that are available to users from the data store.

  4. Define any restrictions to the data.

  5. Rename the detail columns with meaningful names.

Data stores can be wrapped into components within the Composer module, but they are globally visible. Users can select the data store as a source from anywhere in the Composer module. Security can also be applied to any data store to give users permission to view, edit, and delete the object.

Adding data stores

In Varicent Incentive Compensation Management (ICM), create data stores to join multiple data sources together.

  1. In the Composer module, from the Palette tab, drag the Data Store object onto the canvas.

  2. Type a unique name for the data store and click Save.

  3. Define the data sources for the data store.

  4. On the Restrictions tab, define any restrictions to limit the records displayed in the data store.

  5. On the Display Columns tab, drag the columns that you want to display in the data store from the data sources to the Add columns pane.

    1. In the Add columns pane, click the column name to rename it.

    2. Click the Edit icon when you are finished renaming the column.

  6. Click Create.

Exporting data store rows to Microsoft Excel

In Varicent Incentive Compensation Management (ICM), after adding data to your data store, you can export rows to Microsoft Excel.

You can use the Excel Add-in to import a data store in its entirety. For more information about the Excel Add-in, read: Varicent Excel Add-in.

You can also export data stores to Excel from the Composer module:

  1. In the Composer module, click the data store that you want to export to Excel.

  2. Click Edit.

  3. Click View Current Values.

  4. Click To Microsoft Excel.

Important

From the Composer module, you can select and export a maximum of 300 rows of data.