I am using the following query. The problem is that i want to format
these cell to be same as the Measure or Metric in my Cell calculation.
Note that I am dynamically generating the MDX. Is there any way i can
get the measure Format_String Property of the Measure or Metric used in
my Cell Caluculation ? or is there any way i can apply the same
Format_string specified for Measure or Metric ?

--------------------------------------------------------------------------------------------------------------------------

With Cell Calculation MY_CELL_ON_Store_Cost For '( { [Measures].[Store

Cost]} )' As 'CalculationPassValue(Measures.CurrentMember, -1 ,
Relative )', CONDITION ='
IIF([Time].currentMember.Level.Name="Month", CalculationPassValue(
[Measures].[Store Cost], -1,Relative ) >
( ([Time].CurrentMember.PrevMember,Measures.[Store Cost]) * 1.02) ,
CalculationPassValue( [Measures].[Store Cost], -1,Relative ) = (
([Time].CurrentMember.PrevMember,Measures.[Store Cost]) * 1.02) )' ,
SOLVE_ORDER ='2000', FORE_COLOR ='11008', CALCULATION_PASS_NUMBER ='2',

CALCULATION_PASS_DEPTH ='1'
SELECT {
CrossJoin({[Customers].[Country].[USA].[CA],[Customers].[Country].[USA].[OR*],[Customers].[Country].[USA].[WA]},

{Measures.[Store Cost],Measures.[Store Sales]})} ON COLUMNS ,
{{[Time].[Year].[1997].[Q1].CHILDREN,[Time].[Year].[1997].[Q2].CHILDREN,[Ti*me].[Year].[1997].[Q3].CHILDREN,

[Time].[Year].[1997].[Q4].CHILDREN,[Time].[Year].[1998].[Q1].CHILDREN,[Time*].[Year].[1998].[Q2].CHILDREN,

[Time].[Year].[1998].[Q3].CHILDREN,[Time].[Year].[1998].[Q4].CHILDREN}}

ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],[FORE_COLOR]


---------------------------------------------------------------------------------

Thanks,

Faraz