Dynamic connection string to pps dashboard in sharepoint 2010

Question

Hi all,

I have a requirement that i need to build dynamic connection string depending on the user credentials. Every user has his own database which consists of his own cube.

Ex:= userid-x, pwd-y

after loging in the connection string would be something like

connectionstring=!"msolap;database=xxx;cube name=yyyy;";

So i need to pass this connection string to the pps dashboard that was designed through dashboard designer. If you arenot clear with the question please feel free to ask.

Waiting for your reply.