The last response from me was for hyemang!

Thanks for the resply! That sure works but I needed a much simple solution and I think I got it. Thanks anyways!!!!!!!!!!!!

Steve,

Thanks a tonne!!!!!!! It worked. Today morning when I read ur initial response I thought I need to put in an entire select statement with Left(...) etc into a Named...

Steve,

I've have no idea about MDX so don't know how the calculated field should look like. If you could build that for me. Moreover I don't see the LEFT function...

Got it done with SQL statements that load the fact and dimension tables then process the cube. All in SSIS package.

Thanks guys!