B.3 Creating a Custom Dimension for Product

To create a Custom Dimension for a Product, follow these steps:

1. Custom Product Dimension Creation is a customized step that has to be done from the AMHM Screen on FTP Setup.
2. After the Custom Dimension is created, update the AMHMConfig.properties file in the FTP Setup with the dimension_id in the Members and Hierarchy Reverse population headings with Y as follows:
   1. Restart the services.
   2. Log in to the application and Navigate to the AMHM screen.
   3. Navigate to the Members screen and then select Custom Product Dimension.
   4. Resave all the members from the Listing screen.
   5. Navigate to the Hierarchy screen and then select Custom Product Dimension.
   6. Resave all the Hierarchies from the screen.

   Note:

   If FTP Setup is hosted on a different server, then the Custom Product Dimension should be created on the PCD setup as well with the same dimension_id.
3. Execute the following query to map the Custom Product Dimension with the FTP Product Field available in the FTP Model Dimension Screen.

   update rev_dim_attributes_b set attribute_dimension_id=( select dimension_id from rev_dimensions_tl where dimension_name='<custom_product_dimension_name>') where dimension_id =6778 and attribute_id=1;