cancel
Showing results for 
Search instead for 
Did you mean: 

Data for Keyfigure in DSO displaying zeroes inspite of value present in PSA

Former Member
0 Kudos

Hi,

I am not able to see the correct data for a particular Key Figure in the DSO, it is displaying zeroes for all the records.

Data is being loaded from a DataSource where non-zero values for that key figure are present.

Transformation is direct, no routines or formulae.

Your help required.

Accepted Solutions (0)

Answers (4)

Answers (4)

desgallagher
Contributor
0 Kudos

Hello Rahul,

In the past this problem has happened because the corrections from the notes 1041000 and 1081423 were missing from the BI

system. If the notes are applicable to your release level please apply them and then try the loading and the activation of the

request again. If the problem still exists you can use the note 1052335 to trouble shoot the loading and activation of the

data in your system. A good tip is to switch of the automatic activation of the data or remove the DSO from the process

chain if its a process type in the chain that triggers the activation. Then you can check in the activation queue/new data table

of the DSO to see if the data is correct at this point. If yes then we know at least that the issue happens on activation of

the data.

Best regards,

Des.

Former Member
0 Kudos

Hi,

If it is a non cumulative key figure the you will see data only when you run raport, This data will not be visible directly in DSO/Infocube.

If it is standard key figure, try to simulate update rules, then you can check what is goning on.

Regards,

DL

Former Member
0 Kudos

Hi.....

Check the data type of the keyfigure........

Make the update mode overwrite for that DSO..........and then try to load it.....................

Regards,

Debjani.....

Former Member
0 Kudos

HI,

Look into the PSA data that Negative values are present for those Keyfigures.Think both posite and negative values are there for those records which sum up and giving the Zeros in the DSO.Check in the R/3 side table entries for those records.

Tarak

Former Member
0 Kudos

Hi,

No, this is not the case there are only positive key Figures

Also, i have verified that the datatype is correct

Aggregation in Transformations is Overwrite

Former Member
0 Kudos

HI,

Check if there are any old PSA requests and data in those requests.May be having negative records in those requests.

Tarak