Hi,

I applied formatting like Thosand's seperator to the source & calculated
Measures in the cube.

When i execute MDX, i am loosing format to the calculated members. Please
see the example below. "Total" - lost the Thousand's seperator.

Please let me know how to get the format to the calculated members.

200301 200302 Total
Eligible Amount 283,711,585 240,908,388 524619973

with
Set [Time set] as
'{[Time].[Hierarchy].[Yr_Mo].&[200301],
[Time].[Hierarchy].[Yr_Mo].&[200302]}'

member [Time].[Hierarchy].[Total] as 'AGGREGATE([Time set])'

select
{[Time set],[Time].[Hierarchy].[Total]}on columns,
[Measures].[Eligible Amount] on rows
from [Dental General Model]

Thanks,
Prasad.

You would use FORMAT_STRING after expression, for example:
member [Time].[Hierarchy].[Total] as 'AGGREGATE([Time set])' ,
FORMAT_STRING='#0.00'


"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote