Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Data Lookup option within Strategy Designer has the ability to access the Competition table in our partition. Each of these lookups will return a value that can then be used within our custom pricing strategies.

A Competition data lookup will follow these steps:

Add Lookup

On the Data Lookups panel, select the Add Lookup and then choose Competition option:

This will add a new data lookup to our list with a default name of Price Parameter_1.

Lookup Name

We should always change the default name to something more meaningful using the Rename Lookup option:

NOTE: The data lookup name can be any combination of letters, numbers, spaces and special characters. Both upper and lower case characters can be used.

Unlike our other data lookups, there is only one table that contains our product competition data. Therefore, renaming of this data lookup would be to save specific types of search conditions. For example, if our lookup was based on specific competitor name:

Select Lookup Table

The default Price Parameter set of visual blocks will be created and our initial step will be to select our Price Parameter table from the list of tables:

NOTE: The table names that are listed in this list will be the Labels associated with our tables and not the actual table names.

Once the table has been selected, then the set of attribute filters will be displayed for this table:

The number of attributes filter shown can be linked to the key fields for our table. For example, for the Cost Plus Factor table it has three key fields and they are shown as our filter attributes.

NOTE: Price Parameter tables that can have multiple key fields are known as MATRIX type tables and the maximum number of key fields allowable is 6.

Live Preview

The Live Preview option for Price Parameter data lookups will display all of the rows that match our search filters and also display the Value that is being returned for the attribute selected. Additionally, it provides a drop-down to allow us to select different product sku values:

NOTE: In this example, we are returning multiple result rows since not all of the search filters are used, to return a single unique role we would need to supply values for Industry, BusinessUnit, and product_group_category.

 

  • No labels