format - SSAS PowerPivot MDX Problems w/ Measures Format_string -
i investigating problem calculated measures format issue olap cube.
i these numbers :
i using mdx request:
with member [measures].[ristournable format] [measures].[ristournable], format_string = 'currency' select non empty { [measures].[ristournable format] } on columns, non empty { ([affaire].[affaire].[affaire].allmembers ) } on rows [cube]
but doesn't work. think problem comes "."
instand of ","
numbers mdx request using string
. that's why tried force numeric conversion first sentence "with member ..."
. unfortunately doesn't work either.
could please me solve it?
have tried format_string='$##0.00'
or other explicit way of telling mdx want, rather passing 'currency'?
Comments
Post a Comment