analysis services & clr

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I have some problems deploying my cube. I have made two CLR udts called : trajectory, rectangle and the corresponding database tables. I have also created a fact table with the following columns :

rectangle_id : dimension
trajectory_id: dimension
gender_id : dimension
distance: measure

When I try to deploy my cube the following error occurs:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine";>
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<Object>
<DatabaseID>TrajectoryAnalysis</DatabaseID>
<CubeID>Trajectories</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Dimension 'Trajectories' failed.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
Processing Dimension Attribute '(All)' completed successfully.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
Processing Dimension Attribute 'ID' completed successfully. 70 rows have been read.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_trajectories].[ID] AS [dbo_trajectoriesID0_0]
FROM [dbo].[trajectories] AS [dbo_trajectories]
Processing Dimension Attribute 'TRAJ OBJ' failed. 1 rows have been read.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
SQL queries 1
SELECT [dbo_trajectories].[TRAJ_OBJ_ID] AS [dbo_trajectoriesTRAJ_OBJ_ID0_0],[dbo_trajectories].[TRAJ_OBJ] AS [dbo_trajectoriesTRAJ_OBJ0_1]
FROM [dbo].[trajectories] AS [dbo_trajectories]
Error Messages 1
OLE DB error: OLE DB or ODBC error: Requested conversion is not supported.. Errors in the OLAP storage engine: An error occurred while the 'TRAJ OBJ' attribute of the 'Trajectories' dimension from the 'TrajectoryAnalysis' database was being processed.
Processing Dimension Attribute 'GENDER ID' completed successfully. 2 rows have been read.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_trajectories].[GENDER_ID] AS [dbo_trajectoriesGENDER_ID0_0]
FROM [dbo].[trajectories] AS [dbo_trajectories]
Processing Dimension 'Gender' completed successfully.
Start time: 4/9/2007 11:00:16 #960;#956;; End time: 4/9/2007 11:00:16 #960;#956;; Duration: 0:00:00
Errors and Warnings from Response
OLE DB error: OLE DB or ODBC error: Requested conversion is not supported..
Errors in the OLAP storage engine: An error occurred while the 'TRAJ OBJ' attribute of the 'Trajectories' dimension from the 'TrajectoryAnalysis' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.


Is there a problem using CLR udts in dimension tables ?Please help.
.