We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Localization of currency symbol when using OLAP data

Thread ID:

Created:

Updated:

Platform:

Replies:

127719 Dec 5,2016 05:31 AM Dec 8,2016 07:38 AM JavaScript 3
loading
Tags: ejPivotGrid
B Nielander
Asked On December 5, 2016 05:31 AM

Hello,

I am trying to localize the values shown in the ejPivotGrid widget. Especially the currency values should be shown with the proper currency symbol (Euro sign in my case).
However, with currency values the dollar sign is always shown.

I have set the locale of the ejPivotGrid with:
gridElem.ejPivotGrid({
    url: Constants.CubeUrls.gridUrl,
    locale: "nl-NL",
    ...
}

The OLAP data is retrieved by a WebApi REST Service. The culture property of the datamanager is also set to the Dutch culture:
var dataManager = new OlapDataManager(connectionsStr)
            {
                Culture = new System.Globalization.CultureInfo(1043),
                OverrideDefaultFormatStrings = true
            };

And the language of the Analysis service is also set to "Dutch".

What am I missing? How do I make sure that the proper currency symbol is shown?


With kind regards,
Bas

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On December 6, 2016 06:50 AM

Hi Nielander, 
 
For the reported problem, we need to check the cube and values generated from the cube through debugging.  Hence we kindly request you to provide us the sample with garbage/dummy cube, which would be very helpful to assist you at earliest. 
 
Regards, 
Sastha Prathap S. 


B Nielander
Replied On December 7, 2016 02:53 AM

Hello,

There seemed to be a problem with caching. After clearing the Analysis Service cache the expected currency symbols were shown in the pivotgrid.
However, now the pivotchart doesn't show any values anymore when the Measures values are of type currency. The Web Api REST service returns all currency values with a currency symbol (see attachment) but none of the values are shown. When only the measure field is changed to a, for example, integer value. The chart widget is shown without a problem. 
Why are the currency values not shown in the chart widget and how can I fix the problem?


With kind regards,
Bas

Attachment: syncfusion_chart_issue_with_currency_dbdb564e.zip

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On December 8, 2016 07:38 AM

Hi Nielander, 

Thank you for using Syncfusion products. We confirmed that the issue with “PivotChart not get display properly while runs with other localization(nl-NL)” is a defect and we have logged a defect report. The fix for this issue is estimated to be available on Volume 4 SP1 release which has been scheduled to be rolled out at the end of December, 2016. 

Regards, 
Sastha Prathap S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;