Post reply

DIM tables need to be case sensitive

  • December 16, 2016 at 3:25 am

    #151490

    Hi all

    We've designed an SSAS cube but the DIM tables are currently case-insensitive.

    I've now set the cubes to be case-sensitive (which they should be) but it hasn't cascaded to the DIM tables.

    Is there a quick way to set all the DIM tables (text fields only) to be case-sensitive without going through each DIM table and field individually?

    Any help on this would be greatly appreciated.

  • December 16, 2016 at 5:07 am

    #1918362

    When you say Dim Tables, are you talking about your Dimension Tables (stored in a SQL database), or your Cube Dimensions (which is stored within your cube).

    Tables, on SQL Server, are only case sensitive if your collation is set to be. Have a look on msdn about changing the collation of your database. You're need to ensure you change it to a Case sensitive collation, such as Latin1_General_CS_AI (CS = Case Sensitive, AI = Accent Insensitive).

    If this is your solution, I strongly recommend some testing first, before changing your collation in a live/development environment.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 16, 2016 at 5:58 am

    #1918369

    Hi Thom

    I'm referring to Cube Dimensions.

  • December 16, 2016 at 6:41 am

    #1918376

    Another oddity, on the date dimension it's failing on a date columns that contains (funnily enough) a date.

    It's a computed column in the SQL table but the cube processing error shows "00:00:00".

    Anyone any ideas why this would be?

    I've checked the format in the SQL table (on the computed column) and it says date.

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

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