Skip to Content
0
Former Member
Jul 02, 2009 at 11:47 AM

BEx Key Figure Issue

29 Views

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.