I was hoping someone could offer me some assistance with using the
format string property of a MDX calculated member. The cube I am
dealing with has a wide variety of data in it - $, #, % to name a few.
Based on the scope's members, I would like to return the correct format
string.

For example:

scope([Dim KPI].[KPI Type].&[#],
[Dim KPI].[Is Corp Measure].&[0],
[Dim KPI].[KPI Name].[KPI Name].members,
[KPI Actual],*);
this=
iif(cint([Dim KPI].[KPI Name].currentmember.properties("Snap Shot
KPI")) =0,
[KPI Actual], [ActualLastNonEmpty]);
Non_Empty_Behavior(this) = [KPI Actual];
FORMAT_STRING (this) = "#,##0.00";
end scope;

The front-end client still does not see the format string property for
this expression.

....Am I missing something pretty basic here....?

Thanks in advance.

Dave