Post reply

Invalid data type when trying to create dimension

  • April 25, 2003 at 2:25 am

    #106067

    I am trying to create a new dimension.

    When I select the column that I want in it ('Passenger Names'), I get the follwing error:

    " Unable to count the members of the 'Passenger Names' level.

    Unable to open the recordset.

    Error: the text, ntext, and image data types are invalid in this subquery or aggregate expression. "

    So obviously I cannot use that column because it is not of a valid data type, but how can I change this?

    If i try change it to a nvarchar in the SQL Server 2000 table before I set up the data source, it tells me that this change may cause data loss.

    Any ideas?

    Thanks,

    Ryan.

  • April 27, 2003 at 9:23 pm

    #455484

    Hi Ryan -

    What is the data type of the original field?

    The 'potential loss of data' message very often just indicate that the maximum data size of the new type is less than the maximum data size of the old type. So, if the actual data is not excessively large, you may well be just fine.

    However, if the column in question is in fact an image (or blob, memo, etc) type you may not be able to use it in Analysis Services.

    Scot J Reagin

    sreagin@aspirity.com

    Scot J Reagin
    sreagin@hitachiconsulting.com

  • April 28, 2003 at 1:30 am

    #455488

    Hi Scot,

    The column in question is a memo data type, which contains over 300 characters.

    I don't think it is too much of a serious problem (yet) if this column is not used in AS, I was just curious on the error and possible solutions.

    Thanks for your help.

    Ryan.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply