Analysis services & CLR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Analysis services & CLR

Author

Topic

stathis30_2000
Starting Member

23 Posts

Posted - 2007-09-04 : 04:08:43

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.
ST

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources