Hi ALL,
I have a scenario wherein the keyfigure value in Cube is not matching the Keyfigure value in query.
I have a K.Fig DTCUMBAL which exists in an I.cube and the same key figure is been displayed in the query built on the the cube. The K.F in query is plain vanilla (no formulas, calculations..etc)
Now the KF value in cube is not matching the value in query. Say for eg: If the DTCUMBAL in Cube is 123.78 COP, then the same value in query is displaying as 12,378.00 COP. So, the value is getting multiplied by 100 in query. I am facing this issue only for specific currencies like COP (Colombian Peso) and IDR (Indonesia Rupee). For other currencies the data is displayed normally.
Thanks,
Sri.