show measures in millions or thousands

[BenziD]

A customer of mine requested to show measures in millions or thousands (more then 100 measures).
I can calculate the mesures in the reports, but prefer to do it in the model and not in each report....

How can I implement this request in FM?Is it possible to create a prompt for this and have it NOT pop up in query studio?

[Greg]

Is it a requirement that for each of these measures the report consumer must be able to decide, at report execution time, in which units (e.g. Millions or Thousands) the measure is displayed?  If so then your best bet is to update the expression for each measure to divide the actual value by the result of a prompt value.  I would even suggest creating a parameter map to substitute the words (Millions, Thousands) to their numeric equivalent.  You can easily provide a default value (1?) for the prompt.  Unfortunately there is no way to have Query Studio ignore a prompt or to automatically just use the default value.

On the other hand, if you know that you will always show measures in the Millions then you can simply edit the Format property of the measure, set it to Number and set the Scale property accordingly (e.g. to -6 for Millions).  The report server won't append any suffix to the values displayed in the report for you (e.g. 100 (M)) so be sure to update the name of the measure to indicate the appropriate scale.

[BenziD]

 :-*  ;)