Hello,
It's similar to your other thread
How to handle decryption in SSAS and the answer.
It depends on how is it encryted and how to decrypt. Do you have a stored procedure or a .NET assembly / COM library to decrypt the data?
Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de