on 04-23-2014 5:39 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.