Invalid aggregation:( The number received in BW does not tally

[kosmic_power]

Hi Guru's,

We are currently facing issue in uploading data in to data traget cube which is showing green symbol in the request status,

While in monitor it is showing yellow status on the status tab.

I have checked in the request:

So I have deleted the request and then reloaded it again.

I have checked the load which is completed as the number of records are daily.

But still this status is in yellow so currently I need help to wether, to make the status green manually.

If so what are the implications.

Kindly help me in this regards.

Here is the Error detais:

Technical:The number received in BW does not tally with the updated number.

Processing Step: Update rules

In step by step:

Error which is in red: Inadmissable Aggregation?

Invalid aggregation in the update The number received in BW does not tally with the updated number.

In details tab:

Diagnosis

No errors found. The current process has probably not finished yet.

System Response

The ALE inbox of BI is identical to the ALE outbox of the source system

or

the maximum wait time for this request has not yet been exceeded

or

the background job has not yet finished in the source system.

Thanks for helping me in this regards in advance.

[Roney_Mathew]

Hi,

I am not sure if the solution is still relevant but we faced a similar problem and we found the solution, so wanted to share with you .

This error of 'Invalid aggregation' occurs if there are records in error and if the checkbox "No aggregation allowed" is selected in 'Error Handling' under 'Update' tab of Infopackage maintenance.

Please carry out the followig steps:

1) Go to the respective infopackage

2) select tab Processing, make sure radio button "Only PSA" and the checkbox "update subsequently to data targets" is selected.

3) On the Update tab, click on the button "Error Handling" at the bottom

4) Now of the available three radio buttons choose as per your requirement.(select 'valid records update, reporting possible(green)' for master data)

5) Now, uncheck the box 'No aggregation allowed'

What the last step does is that, the data is aggregated for the correct records and not for the incorrect records.

So, in case of an error we will get a separate request for incorrect records, which we can correct and upload later to the respective target.

This should help resolve the error.

Regards,

Roney.

[kosmic_power]

Hi Manish,

Thanks for replying, I have as per the steps given but here the status is already set to the cube.

So do you have any alternative solution?

wating for answers.

Thanks & regards

Kosmic

[Former Member]

Hi,

It starts working from the next load. You will have to move the status manually for the existing requests.

Thanks

Mani Suresh

[kosmic_power]

Hi Mani,

Here I am getting the following errors,

Invalid aggregation during the loading process

Technical:The number received in BW does not tally with the updated number

Processing Step Update rules

Diagnosis

The number of records that have arrived in BI does not correlate to the total number of updated records. This aggregation has been flagged as invalid in the error-handling section of the scheduler.

System Response

The request is flagged as incorrect.

Procedure

In the monitor, double-click in the <LS>Header tab page on the <LS>Number of Records field. This takes you to the screens where you can check the records. Look at the records counter and see if you can determine why this agregation has occurred. Use the update-simulation function to help you.

Here in the status tab: It is now in Red light and In the request ID it is green.

How to fix this?

Please help in this regards.

thanks

Kosmic

[Former Member]

Hi,

Such an error occurs if the transformation or update rules have been modified and not activated before running the load. Kindly check if all the BW objects related to that cube are activated and try again.

Hope this helps.

Thanks

Mani Suresh

[Former Member]

Hi,

Here is how you fix it.

Go to transaction RSA1.

Click in administration on the left frame.

Expand Current settings and choose Infoprovider.

In the subsequent screen, choose the cube or DSO that you want to fix.

Go to Rollup tab and select the following check box -> 'Set Quality status to 'OK' automatically'

Hope this helps,

Thanks

Mani suresh