Varbinary data type in SSAS

Question

Hi,

      Can u pls any one tell me SSAS will support Varbinary data type attributes???

I have one dimension called DimEmployee.

Attribute : Age  is a varbinary data type

I want to implement  Encryption and decryption in SSAS. So i used varbinary data type.

 it is showing error while processing  the dimension

"Requested Conversion is not supported."

Pls help to solve the issue.

Thanks,

Abdul2010

 

 

 

Answer 1

Before checking if varbinary is supported, do you really need to go to all of this trouble? Can you not just use AS security to prevent users from seeing the age or do you really need it encrypted in memory within the AS memory space too? Otherwise, can you not rather just store the encrypted value as a string rather than binary and decrypt the string?