he Jet Data Manager has the ability to change the collation of the staging, data warehouse, and OLAP databases. As a best practice, the collation of all three databases should be set to the same collation setting.
Note: As a best practice the collation of all three databases should be set to the default collation that is set for Analysis Services.
How to Specify the Database Collation
1. Right-click the database you would like to specify the collation for and select " Edit "
2. From the Collation drop-down, choose the desired collation:
a. <Application Default> will use Latin1_General_CI_AS as the collation setting
b. <Server Default> will inherit the collation of the specified server
c. Alternatively, choose a collation setting from the drop-down list
3. Click OK