Cognos Transformer Number

[dolodolo]

I am having difficulty with how numbers are being passed through to the Power Play Cube from Transformer for one of my measures. The other measure is passing the data through fine. E.g. - the number 0.15 comes across as 1500. I have tried everything to no avail - any ideas?

Thanks.

 

[JDAEMS]

In the properties of the measure in Transformer, you should play around with the following two properties:

- Output Scale
- Precision

If your numbers are coming out wrong, it is probably because of these settings. Play around with them. Make them bigger or smaller, build the cube, and look at the effect it has.

You should be able to find the right settings for you this way.

 

[Draoued]

don't forget the Input Scale in data Source as well.

 

[dolodolo]

Thanks very much - I'll play around with those settings - Dolores