How to localize the data of the cube and loading in OlapGrid

Our OLAP Grid supports culture switching at run time. You have to pass “Locale Identifier” parameter in your connection string in order to switch to a different culture.

Here we tried, creating a cube in 2 different culture French(French) and German(Germany) and deployed in server.

Figure: Cube deployed in two different cultures

1. Loading Cube with German culture:

Use “1031” as Locale Identifier in the connection string to load the OLAP data in German culture.

Connection String :

"Data source=localhost;Initial Catalog=OlapTranslation;Locale Identifier=1031;";

Here our OLAPGrid loads the data in German culture.

Figure: OLAP Data in German culture

1. Loading Cube with French culture:

Use “1036” as Locale Identifier in the connection string to load the OLAP data in German culture.

Connection String :

"Data source=localhost;Initial Catalog=OlapTranslation;Locale Identifier=1036;";

Figure: OLAP Data in French culture