Unable to fill the aggregates.

[Former Member]

Hi,

Can you please help me to fill the aggregates?

I tried Manage ->rollup.  But the job is getting success without filling the aggregates.

Please help me to resolve this.

with Regards,

Antony Jerald.

[Former Member · Accepted solution]

Hi,

We resolved the error with basis team help by implementing SAP Note and then restarting servers 🙂

Regards,

Antony Jerald.

[former_member182470]

Hi,

The red color traffic light indicates that your aggregates have to be done "intial fillup".

Select the Aggregate and click on "Intial fill" button on top where all options like intial fill, switchoff/On queries, Delete buttons exist.

When you click on intial fill-->A new window will open with the aggregate inside-->Slect the aggregate

-->Execute/Start immediately-->Then the Initial Fillup job will be started. You can find a job log button in the same window.

After the job finishes, traffic light which is red will turn to Green.

Regards,

Suman

[Former Member]

Hi,

I'm getting the following message.  The job is getting success.  But if I check it's log, it's showing the following:

Plz help me on this

Regards,

Antony Jerald.

[former_member182470]

OK, after the job finishes, is traffic light turning to green?

Refer this link for the same error http://scn.sap.com/thread/1585400

You have to inform your BASIS team on the SQL error. After taking confirmation from BASIS, you need to do intial fill as per previous reply.

[RamanKorrapati]

Hi Antony,

Whenever you get error like ORA, its related to Database. its DB Error.

Please take DB Team help along with basis team and sort it out.

Refer this below link, will be useful.

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2011/02/27/bwdb-support-101--get-to-...

Thanks

[RamanKorrapati]

Hi Antony,

Addition ravi suggestion, While doing above step, check at Cube level, cube--> manage--> request tab and if any user hits report on this cube or if any loading performing further also this may create issue.

if possible try to see error what its saying.

Thanks

[ravi_chandra3]

Hi

Once check the joblog.

Please once check whether compression has been done in the basic infocube,