This content has been marked as final. Show 3 replies
we have the same issue but not with case statement, the value changes bec of missing decimals, so try to put the data format to show decimals and run in a table view to see the missing decimals so u find the exact and with the associate dimension.
Just have a work around on it.
Hi I dont have obiee installed right now so Im just guessing. What is the datatype of your fields.
1) Make them as double in physical layer.
2) Add those fields in one dummy report and go to data properties and set decimal places = 2 and save it.