cancel
Showing results for 
Search instead for 
Did you mean: 

Display Incorrect Value

fififery
Participant
0 Kudos

Dear All

I Try to display quantity that i already input in BPS.

Type of this key figure is Quantity and Fixed Unit is MT.

I See in cube the value for this key figure is 0.343

But displayed in BEX is 0.000

How TO displayed in BEX with the correct key figure?

Thanks

Accepted Solutions (0)

Answers (8)

Answers (8)

fififery
Participant
0 Kudos

Dear Mayank

The data is like this

Based on your example

For Characteristic PA, A1 0.343

PA,A1 -0.343

PA,A1 0.3

PA,A1 0.043

My data in cube is like that.

IS that problem?

Thanks for your help

Former Member
0 Kudos

Hi,

Of course that is not a problem. Data get aggregated in BEx report. The records that you have mentioned aggregate to .343. I don't have any other ideas why you are facing this issue.

If you resolve it, plz update back the thread.

fififery
Participant
0 Kudos

Dear Mayank Gupta

For question 1: Yes i Have scalling factor 1 for that KF

For second question, can u explain in detail what do you mean?

Thanks

fififery
Participant
0 Kudos

Dear Sambhu

I Go to RSA1 and Decimal donation is 1,234,789.00.

Is that wrong?

Thanks

Former Member
0 Kudos

Hi,

I would suggest you to check two things -

1) Is there any scaling factor applied to this KF in query?

2) Is there any other record(s) in the cube with the same characteristic combinations which is aggregating in the query output with the record you found in the cube?

Former Member
0 Kudos

Scaling factor 1 does not affect the output - hope that is clear.

Let me explain pt. 2 with an example - say your record is like P1, C1, 0.343. If there is another record in the BPS cube like P1, C1, -0.343, that could be the reason for the issue you are facing. Just trying to think what the issue might be. Good luck!

Former Member
0 Kudos

Thats really strange...Go to RSA1->Syatem>User Prifile->Own Data--->Check the decimal notation fields in Defaults tab.

Thanks...

Shambhu

fififery
Participant
0 Kudos

Dear Shambu

i already go to RSA1 and display business explorer properties for this key figure.

I set decimal place 0.000 display not defined

and bex description short description.

But Still display zero.

Thanks

Former Member
0 Kudos

Go to this KF and check its Bex property in RSA1.

Thanks...

Shambhu

fififery
Participant
0 Kudos

Dear Shambu

I already do that.

But Still not displayed like what i want.

Thanks

Former Member
0 Kudos

Right click on this key figure and select 0.000 as the display option.

Thanks...

Shambhu