I would like to store "custom" binary data as a measure in an analysis
server cube.
When I set up a fact table to store my data in this way and tried to process
the cube I got this error message ..

Analysis Server Error: Error in data [Column type not supported.] 'data
(128) '

Is there anyway around that? Or can it not be done (like this) with
Analysis Services?

TIA

Hello Andy,
AS only accepts numeric data in Fact-Table.
Text is not possible as well.

HTH
Jörg

"Andy" wrote:

No, it cannot be done. Your best approach is probably to define an Action
and then write an application which retrieves the data and displays it, e.g.
an ASP.NET application. So the way this would work is that as end-users are
browsing the cube, Analysis Services is providing cell-level or
dimension-level Actions (typically I recommend a URL Action type for stuff
like this). Then when the end-user selects the action, the client tool
invokes IE passing it the URL that Analysis Services gives it. Then the
ASP.NET application can do whatever is needed -- including the rendering
your custom datatype.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Andy" <swarb70sok (AT) hotmail (DOT) com> wrote

Sorry I have not be here (this newsgroup) for a while.
Thank you both for your responses Joerg and Dave.