Mapping Spend Node ID for Categories

You can manually map the Spend Node ID for categories in Emptoris® Spend Analysis.

Procedure

To map the Spend Node ID for categories, complete the following actions:

The following table provides information about the actions that need to be completed to amp the Spend Node ID for categories.

Table 1. Mapping Spend Node ID for categories
#	Step	Procedure
1.	Create a batch upload definition for Category Batch processor.	Log in to the Emptoris Strategic Supply Management Platform. Click Batch Upload Definitions > All Batch Upload Definitions > Create. On the Create Batch Upload Definition page, specify the Format Name. From the Processor drop-down list, select Category Batch Processor. Select Master as the Data Source. In the Batch Upload Column Definitions, add the following two columns: Map the `VSM_ID` column label to the `VSM ID` attribute. Map the `CATEGORY_ID` column label to the `Data Source App ID` attribute. Select Lookup as the Column Usage for the `VSM_ID` column and Insert/Update for the Column Usage for the `CATEGORY_ID` column. Select None for the Default Value for both the columns. Click Save.
2.	Create a batch download recurring job.	Click Administration > Jobs > All Jobs > Create. On the Create Job page, from the Job drop-down list, select Batch Download Recurring Job. From the Batch Definition drop-down list, select the batch definition that you created in step 1. Select CSV as the Format. Create the following expression: Attribute: Data Source Operator: is equal to Value: Master AndOr: AND Attribute: Data Source App ID Operator: is anything Click Save. Click OK on the Job Submitted window.
3.	Download the CSV file.	On the Recently Viewed Jobs, click the Job ID. Go to the Attachments tab. Select the `.csv` file, and click Download. Save the file to a directory.
4.	Append the `Data set ID` to the `CATEGORY_ID`.	In the top menu bar, click Spend Analysis. Click Administration, and from the Admin Area drop-down list, select Integration Management. In the Import/Export Dimensions section, click Export Dimension. Select Category as the Dimension. Click Export. Save the file to a directory. Prefix the `Data set ID` retrieved from the exported suppliers to the `CATEGORY_ID` in the `.csv` file with and an underscore. Example: If the `CATEGORY_ID` is 219, and the `Data set ID` is `89f1bc423e7890d5013e795cc4a9001d`, the new `CATEGORY_ID` is `89f1bc423e7890d5013e795cc4a9001d_219`.
5.	Import the categories into Emptoris Spend Analysis.	In the Emptoris Spend Analysis application, click Administration, and from the Admin Area drop-down list, select Integration Management. In the Import/Export Dimensions section, click Import Dimension. Click Browse to select the file that you created for suppliers. Select CATEGORY as the Dimension. Specify the Description. Click Import. After the import is successful, select the job, and click Execute. The following message is displayed: `VSM mapping job was completed successfully`.