SSAS - Cube browsing currencies displayed in USD format

Question

I have built a cube using SSAS and whenever I browse the cube using Visual Studio or Excel the currencies are always displayed in USD format and not in the preferred GBP format.

I have checked the Login settings are in British English format but to no avail can I change the default currency format.

Answer 1

Try specifying the language directly on your cube. In the Cube Designer, select your cube and modify the "Language" property.