Virtual Keyfigure BADI issue

[Former Member]

Hi,

I have a virtual Keyfigure in my cube with 0loc_currency as the currency key for the Key figure and this currency key is not fed by the source DSO1. So the Keyfigure and 0LOC_CURRENCY will be blank in the cube, Now I have my BADI in place to fill the data for this keyfigure and in the BADI, I also filled 0LOC_CURRENCY in the BADI by reading from the other DSO2 where the keyfigure is residing along with currency. In the debug mode, I see the keyfigure and 0LOC_CURRENCY being filled with correct data for each record in the BEX output. But when I run my query, I see the Keyfigure data filled in but not the currency. ERROR is displayed as Currency! What do you think the issue could be? Cant  we fill currency key or units in a BADI and pass them onto the query output?

Thanks.

[former_member182470]

ERROR will be displayed when mixture of Currencies and Units occurs. Use NODIM for your KF, but this will not display anything. I mean neither ERROR nor Currency. Just play with it to arrive your solution.

[Former Member]

Hi Suman,

My report output is at very detailed level and it is only one currency for all records. I need to display the currency and I can not use NO UNIT .

[former_member182470]

What are your Scaling Factors setting for your KF? How is your data showing?

Eg: Correct = 100 INR, wrong = 100 ERR

What is your error?

You can also show Currency by extending your KF description.

[Former Member]

Hi

When I debug the BADI, I see both KF and 0LOC_CURRENCY getting filled but in the query output, only KF is shown correctly and the currency being 'ERROR'. So the BADI is not passing the 0LOC_CURRENCY to the query output. I have the 0LOC_CURRENCY as a free char too, but still its not showing any currency value. Tee KF values are displayed like 378.98 ERROR, 43.23 ERROR instead if 378.98 USD and 43.23 USD. When I drilldown on 0LOC_CURRENCY I see # for all records instead of USD. There is no scaling factor for my KFs!

[former_member182470]

If your BADI is ok, just make a copy of the query or create a new query. Generate them in RSRT and test it again.

I don't see any reason if BADI is ok, and it doesn't show correctly in Bex.

[Former Member]

No luck ...yeah I see currency getting filled in the BADI..but not in Query output

[former_member182470]

Can you debug your query in RSRT-->execute+debug ? I mean you need to debug your query which internally debugs BADI too. You can observe SQL plan also in RSRT to know the clue..

[Former Member]

I did debugged BADI using RSRT  and I can see currency getting filled with no issues..

[former_member182470]

Can't you get currency in RSRT also? I am just wondering your BADI is ok, but report is not ok. How come it is possible? Have you created new Query and tried?

[Former Member]

I mean, even in RSRT I don't see currency filled in the query output. But while in BADI debug section, I can see Currency getting values populated for each BEX report output record, but the currency value is not passed on to report output..both directly and using RSRT.

[Former Member]

Had to include KF's with fixed currency in the cube. BADI was not able to do what I want.