SYMPTOM:
Metric values are exported as numbers when used as dynamic text in Report Services Documents when exported to Microsoft Excel from Strategy Desktop and Web 9.x. When reports are SAP reports then metric values are exported as text as shown below:
CAUSE:
The metric value is shown as text when the value format comes from SAP instead of Strategy. This can be checked if in the report MDX the following line is shown at the end of the MDX query:
cell properties CELL_ORDINAL, FORMATTED_VALUE, VALUE, FORMAT_STRING
The formatting of the value can now be done in Strategy and the value will be exported as numerico to Microsoft Excel as shown below:
37524
