7 Replies Latest reply: Oct 16, 2012 6:02 AM by Andrew11 RSS

    Creating a dimension...

      Hi

       

      I would like to create a Employee Dimension in the load script where an employee is assigned to the Branch where he has made the Most sales.

       

      So, using the source data below, Alex would be assigned to BranchCode 514 only; Christopher would be assigned to Branch 626 etc.

       

      Source Data:

      Source Data.JPG

       

      Thanks!!