Hopefully the plans have attached successfully this time. Like I said before the use of views is to enable me to quickly prototype the dimensions for a data mart to support the proposed reporting requirements. With the specifications being pretty slack the views enable me to make changes and see the results straight away. It is not my recommended final solution!

Regards

Daniel