Decimals not seen in the query...

[Former Member]

Hi Guys,

I have a problem with the query..

I have loaded a KF with 2 decimal places in the cube.

But when I run a query created on the cube, the digits after the decimal place are not seen in the query.

For e.g. the value of the KF in the cube is 9.85...but in the query, it is seen as 9

please let me know where do i need to make the changes.

FYI..the unit of the KF is %. Has this got anything to do with the problem ?

thanks in advance,

Punkuj...

[Former Member]

Hello Punkuj,

In the query designer, right click on the key figure->properties. Select the decimal places which you want here.

Hope it helps..

thanks,

[Former Member]

Hi Aby,

Sorry, i just missed to mention this imp point :

I had done the operation that you have suggested :

I am getting the following output :

In the Cube : 9.85

in the query ( after the decimal selection) : 9.00

I hope that clears my problem..

Thanks..

Punkuj

[kaiwalter]

Hi Punkuj,

I have the same problem. Did you solve this issue?

Regards,

Kai