Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi Andrew,
You can go through the attcahed application.
Hope it works!
Regards,
Tom
Hai,
Please send me in the form of excel doc
and tel mw what u want to look
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 |
Hi - how do I attached an Excel doc. Cant seem to find an option to do this....
See the qvw i atach
Regardas
Hi Andrew,
You can go through the attcahed application.
Hope it works!
Regards,
Tom
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
Thanks a lot Tom !!