Thursday, March 22, 2012

Binary (Image) in SSAS

I have an Image column in my database nicely imported by SSIS. I want to use these (product) images in my reports. These reports use a SSAS cube as source.

However, I'm unable to use this column as an attribute of my dimension. I get the error:
The 'Binary' data type is not allowed for the 'KeyColumns' property #0

I know there are alternatives like only storing the location of the file and using the url to get it, but that's not an option for me.

Thank you very much!Still nobody who can awnser this? |||

Look in the Adventure Works sample cubes in the Product dimension. They've got the logo image in there. The trick is to put an int ID as the KeyColumn and use the image datatype as the MemberValue.

No comments:

Post a Comment