Amount ERROR

[Former Member]

Hi ALL,

In DataSource, I added DMBTR & WAERS. (Amount and Currency).In Infosource I added DMBTR, WAERS mapped to 0VALUE_LC and 0LOC_CURRCY.

I populated the Amount - 0VALUE_LC from BSEG-DMBTR, not currency.

So 0LOC_CURRCY is empty in cube.

But when I run the report I got problem. Showing.....

Amt.in local curr.

100.00 ERROR

35.00 ERROR

170.00 ERROR

17.00 ERROR

Can anyone please clarify:

1. Why this ERROR is coming?

2. I want to see only Amount .How to remove it?

3. If I fill Currency object will I get Correct.

4. What is NODIM, how can I use it , Pls tell step wise.

Thanks in advance.

Sri.

[Former Member · Accepted solution]

HI BW Masters,

Thanks for your guidence.

I created new formula NoDIM(Amt.in Loc Currency)

I hided the KF Amt.in Loc Currency.

Run - I got the correct vales

But some problem:

1. 100.00 valus displyed as 100 (.00 r missing)

2. 17.50 value displyed as 18.

I want to see it as it is i.e 100.00 and 17.50

Please advise me.

Thanks & Regards,

Sri

[former_member188325 · Accepted solution]

Hi,

go to formula Properties and set decimal places to 2 or 3 i.e 0.00 or 0.000

regards

Message was edited by: Murali

[former_member619464 · Accepted solution]

Hi,

Give the no.of decimal places as 0.00 in ur currency definition in ur query

Regards,

R.Ravi

[Former Member]

Many thanks to you all.

I assigned points.

Problem solved.

Cheers,

Sri.

[Former Member]

Hi,

First thing to do:

go to R/3 in RSA3 and extractot data for your DS and check whther Currency is empty or ?

1.0VALUE_LC is Amount which have to have a a unit and in this 0LOC_CURRENCY is your unit. And bcoz your currency is empty ..you are getting this problem. you can put a constant as transfer rule of 0LOC_CURRENCY as 'EUR' and run the query..you will not find this error.

2. Currency will be there will Amount as

10 USD

10 EUR are different things.

3. Yes.

4. NODIM is no Dimesion, say if your want to add 10 USD + 10 EUR..then you use NODIM.

NODIM(0amount in USD) + NODIM(Amount in EUR).

Hope this helps..

Regards,

San!

[former_member188325]

Hi,

If you want to see only Currnecy then you can use NODIM:Value without dimension(unit-free) function which is available under data functions of formula builder.

Create new formula for NODIM.

Right click on KF structure->new formula->NODIM(loc.currency).

Hide the base Keyfigure Loc.currency (right click>properties>display-->always hide).

and have a look at these threads

hope this helps

Message was edited by: Murali