Localization

24 May 20191 minute to read

Localization in pivot chart

You can localize the pivot chart controls text with a collection of localized strings by using the “ej.PivotChart.Locale” for different cultures. By default, the pivot chart control is localized in “en-US”.

Following code example illustrates how to localize the pivot chart based on “French” culture:

CSHTML

<ej-pivot-chart id="PivotChart1" locale="fr-FR">
    <e-size width="950px" height="460px"></e-size>
</ej-pivot-chart>
<script type="text/javascript">
    ej.PivotChart.Locale["fr-FR"] = {
        Measure: "Mesure",
        Row: "Rangée",
        Column: "Colonne",
        Value: "Valeur",
        Expand: "Développer",
        Collapse: "Effondrement",
        Exit: "Quitter"
    };
</script>

Following table localizes the in-built keywords to “French” culture for the pivot chart:

KEYWORDS	VALUES
Measure	“Mesure”
Row	"Rangée "
Column	"Colonne”
Value	" Valeur "
Expand	" Développer "
Collapse	" Effondrement "
Exit	“Quitter "

Localization and globalization of cube info (OLAP)

The content displayed within the pivot chart control is obtained from the OLAP cube.

• To get localized data from OLAP cube, set the “Locale Identifier” in the connection string to a specific culture in the “data” property present in the “e-data-source”.
• To bind the globalized content in pivot chart control, set the “locale” property to a specific culture and refer to specific culture file in the sample.

NOTE

Culture files are present under “[installed drive]:\Users\ [user name]\AppData\Local\Syncfusion\EssentialStudio\X.X.X.X\Web\Samples\Web\Scripts\cultures”.

CSHTML

//1036 refers to “fr-FR” culture.
<ej-pivot-chart id="PivotChart1" locale="fr-FR" load="loadTheme">
    <e-data-source catalog="Adventure Works DW 2008 SE" cube="Adventure Works" data="//bi.syncfusion.com/olap/msmdpump.dll;Locale Identifier=1036;"></e-data-source>
    <e-size width="100%" height="460px"></e-size>
</ej-pivot-chart>