Analysis Service Deployment Error

Hi,

I created a SQL Server 2005 Analysis Service project. When I tried to deploy a standard Decision Tree model, it gave me errors (see below). Clearly, I can't use ntext data type with DISTINCT, but how can I change the SQL command since it was automatically created? What was the final impact of removing the DISTINCT word from the SQL command?

SQL queries 1
SELECT DISTINCT [dbo_Training_x0020_Data].[Hellos] AS [dbo_Training_x0020_DataHellos0_0]

FROM [dbo].[Training Data] AS [dbo_Training_x0020_Data]

Error Messages 1
OLE DB error: OLE DB or ODBC error: The ntext data type cannot be selected as DISTINCT because it is not comparable.; 42000.

Please assist!

MaryYou can change the data type in the DSV, or add a calculated DSV column that casts the ntext to text

Analysis

We have a decision support group here and we have built many Cubes. They
used to use SSMS then moved onto using BIDS to browse cubes. Since BIDS
isn't a really good end user tool for the general users - should we be
looking at getting them up on Excel pivot tables or Reporting Services and
using a Report Model? I see the Report Model from a cube is somewhat harder
than designing your data set with BIDS.Thanks for the comment - Proclarity does rock but we are in the $25k to $35k
for that tool - whereas we own the other tools already.
The 2007 Excel is really nice with the Pivot tables.
"BYU" <BYU@.discussions.microsoft.com> wrote in message
news:FA94F6FF-469A-40AA-A484-CA776E5FA1C8@.microsoft.com...
> BIDS is really a development tool. We are using both SSRS and Excel pivot
> table here. SSRS provides more standard/fixed format presentation of
> cubes.
> Excel sounds more suitable for your users since they are already familiar
> with dimensions and measures. Another tool, also from MS is ProClarity,
> which gives cube users much more flexibilites as well as functionalities.
> "Joe" wrote:
>> We have a decision support group here and we have built many Cubes. They
>> used to use SSMS then moved onto using BIDS to browse cubes. Since BIDS
>> isn't a really good end user tool for the general users - should we be
>> looking at getting them up on Excel pivot tables or Reporting Services
>> and
>> using a Report Model? I see the Report Model from a cube is somewhat
>> harder
>> than designing your data set with BIDS.