Creating a dimension...

[#1]

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:

Thanks!!

[#2]

Hai,

Please send me in the form of excel doc

and tel mw what u want to look

[#3]

Not sue how to add the data - hope this is suitable

Employee	BranchCode	SalesAmount
Robert	399	714
Robert	516	23 242
Robert	6166	714
Christopher	626	48 883
Christopher	1647	1 035
Lucia	651	6 455
Lucia	1647	672
Lucia	2352	672
Alex	500	714
Alex	514	134 810
Alex	6595	714

[#4]

Hi - how do I attached an Excel doc. Cant seem to find an option to do this....

[fdelacal]

See the qvw i atach

Regardas

[thomas_skariah · Accepted solution]

Hi Andrew,

You can go through the attcahed application.

Hope it works!

Regards,

Tom

[#7]

Thanks.

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

[#8]

Thanks a lot Tom !!