Analysis server and Active Directory

When you have deployed the standard DAX2012 cubes to your analysis server, you may encounter issues in viewing the information through the standard reports or role centres.

The integration between the different systems utilities Kerberos authentication. It is important to ensure the Active Directory on your domain is using a function level of Windows 2003 or greater, as Kerberos is not supported by Windows 2000 Active Directory functional level.

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.

BI cube deployment language issue

Encountered an unexpected issue when deploying the standard cubes. During the deployment the only language selected was ‘en-gb’, everything deployed without any problems. However when you run some of the procurement reports (example Reports->Statistics->Supplier->Purchase in the past periods), they error saying ‘Accounts payable cube’ is not present or processed.

The problem is caused because of user default language in DAX was set to ‘en-gb’ causing the cube names to load with the British English wording rather than the US English. For the VendCube this would mean US language would be ‘Accounts payable cube’ while in British English would be ‘Purchase ledger cube’. The example report is hard coded to look for ‘Accounts payable cube’.

So when releasing the standard cubes, and to use them within the standard reports, you must ensure the deployer’s DAX language is set to -en-us’┬áto ensure the cubes will work with existing reports!