cancel
Showing results for 
Search instead for 
Did you mean: 

Amount in certain currency is multiplied by 100 in bex report.

Former Member
0 Kudos

Hi,

Amount in certain currency is multiplied by 100 in bex report. Data in multiprovider is good. Suppose if amount is 123.123 in multiprovider then in Bex report it is showing 12312.3. This is happening where currency is HUF. I understand that I have to handle it at query level in bex. I also understand I may have to create formula variable/ CKF/ RKF. But not able to implement it. Please help me to solve this. I'm new in Bex.

Thanks in advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Arindam ,

As pointed by Suman and AL, this isssue will happen due to TCURX settings. check the value  first in ECC table  in SE16 ( Not in ALV  display, in SE16 DISPLAY). You will now how a value is stored at  DB level first.

If the value  stored it self is incorrect then it has to corrected first in ECC side.We faced the  same issue for VND( Vietnam Dong) and  XAF (Iory Coast)  etc..

If the value is storing in ECC as expected then  replicate the source systems in BW and load to  BW. In the BEX report the values will come properly with out any issues.

If you are sending the data to any third party from infocube then problem  may come .. let me know  the value stored in ECC side for the  same.

Regards,

Rajesh

anshu_lilhori
Active Contributor
0 Kudos

We can handle this at query level,if you are sure that this is happening for that particular currency only.

Make a new selection or RKF say S1--Amount restricted with currency = HUF.

Now make a new formula say F1 and put the above selection inside it and divide by 100.

Now create another selection say S2--Amount restricted with currency--Exclude value=HUF

Final formula will be (F1+S2)

This will give the desired result.

Hope this helps.

Regards,

AL

Former Member
0 Kudos

Thanks Anshu for your replay.

I think like that only. Is there any other workaround?

If you have any other solution on this please share.

Thanks in advance.

anshu_lilhori
Active Contributor
0 Kudos

If this suffice your requirement then why do you need another solution

Former Member
0 Kudos

Actually this issue occurred when ever the currency in TCURX table is 0. For the time being I found only HUF, but this list may increase when new data will load. Thats why I'm asking is there any general solution is there to solve such kind of issue.

Thanks in advance. 

anshu_lilhori
Active Contributor
0 Kudos

Yes i understand that whenever decimal place is not there or any currency is out of validity period then this happens.It  can be handled at modeling level.

At query level we can do what i suggested in my reply.

You may check this document to understand the issue and solution which can be implemented.

Regards,

AL

Former Member
0 Kudos

Hi Arindam & Anshu Lilhori ,

Following on the suggestion given by Anshu that make two RKF S1 & S2 . In S1 we maintain HUF currency. And in S2 we exclude HUF.

Now arindam asked for a general solution if there are other currencies too in TCURX with 0.

My suggestion is that let's make a Customer Exit variable on the currency . And read the table TCURX in the CMOD code and populate all the currencies inside TCURX with 0 in S1.

And all the other currencies without 0 inside S2.

In this way it will become a General Solution. He doesn't need to maintain the currencies manually.

Let me know if you find any discrepancies in this approach.

Regards,

Ashutosh

former_member182470
Active Contributor
0 Kudos

How many decimals have been set in TCURX table? It might be 1. Increase it to 3.

If this doesn't work then try to set decimals in query for your KF.

Former Member
0 Kudos

Thanks for your replay.

The decimals for HUF in TCURX table is 0. And I'm not suppose to change any entry in this table. So I'm thinking to divide the value by 100 in query level where currency is HUF. Because for other currency the value in multiprovider and bex is matching properly. But I'm not able to implement it as I'm new to bex.

Thank in advance.