Correlated and Similar Items



Technical documentation about how to setup and configure the Correlated and Similar item funcionality. This page handles the configuration for the Correlated and Similar item workspace.
The Correlated and Similar item workspace and all tables and procedures for that are part of the standard AGR. It is available from version v6.2-r10. Please retrieve patch 6.2-r10 from http://releases.local/ .

To be able to run the correlated and similar item algorithm, a python setup needs to be installed to SQL Server instance. Please follow these instructions before configuring other setup.
Next, follow the seperate instruction for Correlated Items and Similar Items for more detailed setup.
When you have completed the steps in these three pages, please follow the following instructions to further set up the correlated and similar item workspace.


Turn on data transfer

To turn on the data transfer for correlated and similar items you need to update core.stg_run_group.

UPDATE [core].[stg_run_group]
SET [active] = 1
WHERE [stg_run_name] = 'ml_correlated_and_similar_item_run'

core.stg_run_group


Make the workspace visible in AGR

To make the workspace visible, update in table dbo.features the value for enabled from 0 to 1. E.g. see the code below:

UPDATE [dbo].[features]
SET [enabled] = 1
WHERE [feature_ref] like 'correlated_and_similar_items%' AND [enabled] = 0

dbo.de_workspaces


Add to Navigation bar

Add Correlated and Similar item to navigation bar (this is not needed if you are implementing the AGR system the first time)

  • Go into Settings > Navigation in the AGR system.
  • Click the </> besides App Navigation
  • Add the following code under "caption": "MORE","submenu": [...] :
    {
    "caption": "CORR_SIM_ITEM",
    "path": "workspaces/correlated_and_similar_items/correlated_and_similar_items",
    "feature": "correlated_and_similar_items"
    }

Navigation bar setting


Create scheduled task

It is recommended to run the data transfer for correlated and similar item once every month.

Set up a scheduled task for the data transfer and select in the calendar the preferred dates when you like to run the data transfer. See Scheduled tasks for more information on how to schedule a task.

Scheduled task


Other information

  • We use id range 6000-6499 for correlated and similar item.
    • 6000-6099 is used for correlated items
    • 6100-6199 is used for similar items
    • 6400-6499 is used for custom columns/data series
  • To check the data transfer for correlated item, look at the log in core.event_ex on stg.
  • For similar item, look at core.event_ex on prod.
  • By default, the views are on item_no level. But if customer likes to manage it on location level, the views are already available on location level but disabled. Go to dbo.de_workspace_views and change the share settings on the [per-location] views

workspace_views