BI deployment – Only dimension attributes error

When trying to deploy the standard DAX2012 cubes to your analysis server you might get an error message ‘Only dimension attributes and attribute relationships can have translations in Standard Edition.’.

If you are running the standard edition of SQL server, then this version does not support language translations. To eliminate this error you need to delete your cube project from the AOT (Visual Studio Projects -> Analysis Services Projects). The create a new project, but when the language screen is displayed select NOTHING. This will eliminate the translations and enable you to deploy your cubes.

Advertisements

2 thoughts on “BI deployment – Only dimension attributes error

  1. James says:

    Hi Nigel,

    I tried the same in a recent deploy and this didn’t fix the issue (SQL Standard 2014)

    Microsoft then recommended I open the AOT project in Visual studio and remove the translations on Dimensions (other than the DEFAULT translation).

    This fixed some of the translation errors, however still stuck with errors about translations on MEAUSRES (which I cannot alter in Visual studio as far as I am aware) – Error Message (05:23:08 pm) CalculationProperty [Sales Cube].[MdxScript].[[Average days late (requested ship date)]] : Only dimension attributes and attribute relationships can have translations in this edition of Analysis Services.

    Any thoughts?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s