MSAS - Problems with measure formatting

[cairnz]

I have a MSAS cube i am unable to change the structure of. The main problem is that most measures, and calculations are defined with FORMAT_STRING = "### ### ###". For some reason Cognos 10.2 and 10.2.1 is unable to render any reports using the native MSAS formatting.

I have read up on this URL : http://www-01.ibm.com/support/docview.wss?uid=swg1PM55065

It states it only happens in Dynamic Query Mode - but i am getting this error no matter if i have a package with dynamic query mode or not.

I have tried to change all kinds of languages on data source, package and what not, but to no avail, i am unable to show any reports using this data source.

I have reproduced this issue into a generic one by adding a calculated measure to the Adventure Works cube.

CREATE MEMBER CURRENTCUBE.[measures].[Invalid Pattern String]
AS [measures].[internet sales amount],
FORMAT_STRING = "### ### ###",
VISIBLE = 1  ;

Does anyone have any tips on what i can try to work around this error?

Thanks in advance!

[tjohnson3050]

Change the format string in SSAS

[cairnz]

Hi, thank you for replying, but you somehow missed my first sentence. I cannot change the MSAS cube nor any format strings in the cube. I am looking for a solution or workaround that resides somewhere in a cognos configuration setting, or other governor or thereabouts, to allow adhoc queries to this cube without having to change the format in every report for every measure you make.