I am currently building a 7.3 cube for training hrs. performed to maintain job qualifications. ;D
However, when I create the cube and run it, the output is multiplying either by 100 or by 10. ???
For instance:
if my minimum threshold shows 48.0 in the .imr, it displays 480.0 in Powerplay
if actual is 1.0 in the .imr then it displays as 10.0 in Powerplay
if deficiency shows 47.0 in the .imr, then it displays 4700.0 in Powerplay
I have tried in vain to format both the input in transformer as well as the output in Powerplay with no luck and am stumped. ::)
Thanks for your help!
you need to check the properties in Transformer
data source column Input Scale:
and the Measures Output scale: need to match as well as the formating.
I have occationally also had to add the function "round" to the Impromptu value when the output, not the format, was of differing decimal places.
I got it to work by following your advice. I had to play with the input scale and the output scale until I got my desired results which ended up being making both input & output scale '2' in order to display the same value showing in the .imr. Thanks again!