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.

BI Portal 2003 connecting to SSAS 2005

Hi,

I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff:

Line: 465
Char: 4
Error: the object doesn't support this property or method
Code: 0
URL: http://localhost:8080/_layouts/1033/Menu.htc

How can I make a data source connection? Help is very much appreciated.

Thanks in advance,
May Lanie

If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here is whitepaper on how to do that: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

If you would like to connect to AS using TCP/IP, here is set of instructions on how to troubleshoot connectivity problems http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello May,

Were you able to resolve this issue? I am experiencing the same issue. Please let me know either way. I will let you know what I find.

Thanks

BI Portal 2003 connecting to SSAS 2005

Hi,

I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff:

Line: 465
Char: 4
Error: the object doesn't support this property or method
Code: 0
URL: http://localhost:8080/_layouts/1033/Menu.htc

How can I make a data source connection? Help is very much appreciated.

Thanks in advance,
May Lanie

If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here is whitepaper on how to do that: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

If you would like to connect to AS using TCP/IP, here is set of instructions on how to troubleshoot connectivity problems http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello May,

Were you able to resolve this issue? I am experiencing the same issue. Please let me know either way. I will let you know what I find.

Thanks