ORA-34357: (MXDSS10) string is not an alias of analytic workspace string.
Cause : User attempted to use AW UNALIAS on a non-existent alias.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Make sure that the command specified the correct analytic workspace and alias. The alias must have been assigned (using AW ALIAS) during the current session and must not have been removed by a previous AW UNALIAS or AW DETACH command.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.