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.

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.

Bii.exe V1.0-1 Utility for SQL Server 2000

I tried using this utilily to upload images into a table with a bigint datatype but it failed saying it does not support such datatypes. Is there another version of the bii utility that can support all the data types supported by SQL server 2000?
From http://developmentnow.com/g/118_2004_11_0_18_0/microsoft-public-sqlserver-server.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
I'm not aware of away to load images into a bigint column but I am curious
as to what kind of images do you have that fit into an 8 byte column?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Emmanuel" <nospam@.developmentnow.com> wrote in message
news:273fc90b-d4fa-4fbb-a9e3-7c35d65974f9@.developmentnow.com...
>I tried using this utilily to upload images into a table with a bigint
>datatype but it failed saying it does not support such datatypes. Is there
>another version of the bii utility that can support all the data types
>supported by SQL server 2000?
> From
> http://developmentnow.com/g/118_2004_11_0_18_0/microsoft-public-sqlserver-server.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Bii.exe V1.0-1 Utility for SQL Server 2000

I tried using this utilily to upload images into a table with a bigint datatype but it failed saying it does not support such datatypes. Is there another version of the bii utility that can support all the data types supported by SQL server 2000
From http://developmentnow.com/g/118_2004_11_0_18_0/microsoft-public-sqlserver-server.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comI'm not aware of away to load images into a bigint column but I am curious
as to what kind of images do you have that fit into an 8 byte column?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Emmanuel" <nospam@.developmentnow.com> wrote in message
news:273fc90b-d4fa-4fbb-a9e3-7c35d65974f9@.developmentnow.com...
>I tried using this utilily to upload images into a table with a bigint
>datatype but it failed saying it does not support such datatypes. Is there
>another version of the bii utility that can support all the data types
>supported by SQL server 2000?
> From
> http://developmentnow.com/g/118_2004_11_0_18_0/microsoft-public-sqlserver-server.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Bii.exe V1.0-1 Utility for SQL Server 2000

I tried using this utilily to upload images into a table with a bigint datat
ype but it failed saying it does not support such datatypes. Is there anothe
r version of the bii utility that can support all the data types supported b
y SQL server 2000?
From http://developmentnow.com/g/118_200...
ver.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comI'm not aware of away to load images into a bigint column but I am curious
as to what kind of images do you have that fit into an 8 byte column?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Emmanuel" <nospam@.developmentnow.com> wrote in message
news:273fc90b-d4fa-4fbb-a9e3-7c35d65974f9@.developmentnow.com...
>I tried using this utilily to upload images into a table with a bigint
>datatype but it failed saying it does not support such datatypes. Is there
>another version of the bii utility that can support all the data types
>supported by SQL server 2000?
> From
> http://developmentnow.com/g/118_200...ver
.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com