Help!! Im losing my mind
In my transformer model, im reading a field that is stored in the SQL database as a decimal(5,2). For example, 9.09
I want this value to appear in my cube as 9.09% (ie, formatted as a percent with 2 decimal places shown). I'm guessing that transformer is expecting my input decimal to be more like 0.0909 to display it correctly.
I've been trying to correct this by changing the input and output scales and the precision, but I can't get it to work properly. I'm getting values like 90900%, 9% but never 9.09%, even though i've specified to format the value to 2 decimal places.
I've tried the following combinations where my input value is 9.09, and the measure is a 64-bit float, formatted as '0%', formatted to show 2 decimal places:
InputScale OutputScale Precision CubeDisplayValue
-----------------------------------------------------
-2 0 0 909%
-2 2 0 9%
-2 2 2 9%
0 0 0 90900%
2 0 0 9090000%
Why are my decimal places not being shown even though I've specified them to be shown, and how can I fix this?
Cheers
J
In my transformer model, im reading a field that is stored in the SQL database as a decimal(5,2). For example, 9.09
I want this value to appear in my cube as 9.09% (ie, formatted as a percent with 2 decimal places shown). I'm guessing that transformer is expecting my input decimal to be more like 0.0909 to display it correctly.
I've been trying to correct this by changing the input and output scales and the precision, but I can't get it to work properly. I'm getting values like 90900%, 9% but never 9.09%, even though i've specified to format the value to 2 decimal places.
I've tried the following combinations where my input value is 9.09, and the measure is a 64-bit float, formatted as '0%', formatted to show 2 decimal places:
InputScale OutputScale Precision CubeDisplayValue
-----------------------------------------------------
-2 0 0 909%
-2 2 0 9%
-2 2 2 9%
0 0 0 90900%
2 0 0 9090000%
Why are my decimal places not being shown even though I've specified them to be shown, and how can I fix this?
Cheers
J