sql server - Currency defaults to dollars in MS Excel 2016 cube reports -


connecting cube excel 2016 leads wrong currency sign. have currency conversion implemented in cube- language function in mdx script shown below:

calculate;                                                                            language([currency].[currency].[usd])=1033;                                                                            language([currency].[currency].[gbp])=2057;                                                                            language([currency].[currency].[eur])=1036;                    ... 

instead of option selected in currency filter( can euro, pound, yen, rand etc.) , dollar sign in measures. when use excel 2010 works expected.

i use currency format string measures , language of cube set english(united states).

ps: have created cube scratch , set language english(united kingdom) , set format string base measure ( not calculated) currency.

in excel 2010 report, pound symbol measure value.

in excel 2016 report, dollars( again!) measure value.

could bug excel 2016? has run similar issue please?

pps: seems problem excel setup , not bug excel 2016 . because currency works expected in machine excel 2016. can tell me how fix excel settings, check, etc.?


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -