How to Use Same key for Multiple columns in dimension


  • Hi

     I have a table Product and categories. The product table have CategoryUID and SubCategoryUID both refers the table Categories UID..I add the CategoriesUID and change the NameColumn property.. but i could not achieve what i need.

    I want the hirerachy of  Category,SubCategory,Product Name.. Once i process the dimension and i select hierarchy  Products it shows  Category,Category,Product Name..Please help to fix this..

    Thanks & Regards Manoj

    Sunday, July 28, 2013 5:35 PM


  • Hi

    Your scenario, is very similar to AdventureWorks sample solution so have a look at sample solution.

    1. You can also denormalise the Category, SubCategory and Product tables to one ProductTable

    2. Create an User Hierarchy as Product -> SubCategory -> Category


    Sunday, July 28, 2013 10:33 PM