Decimal Places gets shifted in report

[former_member183121]

In the Info Cube I have data like Qty- 234,345.89. But when the same is seen in report the Qty is displayed as 23,434.589.

Decimal places is shifting by 1 digit.

Kindly help me in resolving this issue..

[ranganath_korata · Accepted solution]

Hi,

Can you please let us know the value maintained against the currency KD in table TCURX in your system.

Thanks,

Ranga.

[former_member183121 · Accepted solution]

Hi ranganath,

here i have value 3 against currency KD(KWD)

[former_member209895 · Accepted solution]

Which is why the value gets divided by 10 (3-2 = 1, so divide by 10) while loading into the infocube and multiplied by 10 when displaying in the report output.

Infocube: 23,434.589 / 10 = 234345.89

Report:  234345.89 * 10 = 23434.589

If you trace the particular value to R/3 then you will find its value to be 23434.589 KD.

Please go through the document attached by me in my previous posts, it will clear all your doubts regarding exceptional currency handling.

Regards,

  Manohar. D

[Former Member · Accepted solution]

Hello Dasari

it is quite common with respect to currencies.. so do the below mentioned

if you are using 7.x

At the Datasource level chose the format as "External Format" for Currency

try and tell me

Sachin

[former_member183121 · Accepted solution]

This message was moderated.

[former_member183121 · Accepted solution]

Thanq manohar that dodument is really helpfull for me.

[ranganath_korata · Accepted solution]

Hi Manohar,

I appreciate your acknowledgement. Yes, we had faced a similar scenario with JPY. Here the anomaly is that JPY has no subunits, and KD has 1000 subunits compared to regular currencies such as USD, INR, etc which have 100 subunits. Your solution is well detailed, thanks again. : )

Thanks,

Ranga.

[former_member183121 · Accepted solution]

Thanq sachin i willworkon it

[former_member183121]

sorry that value is not quantity it is currency in KD,exact value i have in cube is 253,575.72

but in report out put i am getting 25,357.57. ineed value as in cube pls help me

[former_member182470]

HI,

Have you seen my reply to show the decimals like in Cube?

[umashankar_poojar]

Hi,

  Just check as Yasemin says, there could be scaling factor on your Currency Keyfigure. Make it 1 or see whether you are passing scaling factor by variable, if so then give input as 1.

Thanks,

Umashankar

[former_member183121]

no scaling factor

everything is default setting

[former_member182470]

Mr.Jagadeeshwar,

I don't know whether you are reading all replies or not. I have asked you to look at my suggestion. But you are not replying on that. If you don't respond, what all contributors would think? Did it help you or do we need to provide other solutions?

Regards,

Suman

[former_member183121]

that is working for handling digits after decimal places,but not for shifting

[umashankar_poojar]

Hi Jagadeeshwar,

          If everything is correct, then check the table entries for the currency (KD) and exchange rate TCURR(Exchange Rates), based on the ratio mentioned in the this table report display the values for a currency.

          To check on this, input # (Not Assigned) for the Exchange Rate in your report, you will get the value same as cube.

Also check the table TCURX(Decimal Places in Currencies) as Ranga suggested.

Thanks,

Umashankar

[former_member209895]

Hi Jagadeesh,

     The mention of it being a currency clears a lot of doubt. Those who have worked with JAPANESE currencis will realize that such shifting of decimal points occur due to a non-conventional calculation of the value YEN. Similar is the case with your scenario.

Please follow the below thread, hope it gives you the right direction:

http://scn.sap.com/thread/777299

Regards,

  Manohar. D

[former_member209895]

Hi Jagadeesh...

     The below URL has a very clear description by Omprakash Mishra:

http://scn.sap.com/thread/1882507

A detailed document to go through and understand would be:

http://scn.sap.com/docs/DOC-29671

Hope this helps,

Regards,

  Manohar. D

[former_member183121]

THanq i will check with ur sugession

[former_member183121]

Thanq manohar

[former_member209895]

Hi Jagadeeshwar,

        Please also thank Ranganath Korata  as he was the first to check in that direction. Even though I had not seen his reply before suggesting you to check for the currency thing, I later saw that he had already suggested it yesterday.

Regards,

  Manohar. D

[former_member209895]

Hi,

   A workaround, if nothing else works, would be to create a formula to divide the quantity value by 10 in BEx.  Also what is the unit for the quantity being used ?

Regards,

  Manohar. D

[yasemin_kilinc]

Hi,

I think in your query scaling factor is chosen as 10. Select it as 1.

Hope it helps

Yasemin...

[former_member183121]

i have no scaling factor

everything is default setting

[former_member182343]

Hi,

Change the Decimal places of KF to 2 and Try to execute the report through Bex Analyser insted of RSRT.

Check overall Query disply properties.

WR,

Vijay

[former_member183121]

i am executing in analyzer and decimal places 2 only but not working

[former_member182470]

I think the decimal settings for your KF in Query is 3 places. Make it to 2.

The decimal places of Qty- 234,345.89 is also same in ECC side with 2 decimals? If the ECC side is 3 places, then your report is showing correct.

If you just want to show in report as like cube , use default settings check box in the Query for this KF.