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.
Please send me in the form of excel doc
and tel mw what u want to look
Hi - how do I attached an Excel doc. Cant seem to find an option to do this....
See the qvw i atach
How would I go about doing this in the load script so that it creates a Dimension with just two columns - ie Employee and BranchCode
You can go through the attcahed application.
Hope it works!
Thanks a lot Tom !!
Retrieving data ...