Skip to Content

SAP BW infocube statistic update on MSSQL

Hi team,

We have checked statistics of few infocubes and have found them in Red Status. I tried executing create statistics from the performance tab and it finished successfully but the statistics is still red.

We are running MSSQL Server as DB where DB level statistics are automatically created and updated.

I executed TX: RSRV for the infocube and found few of them in status red. Could you please help me solving this issue as BW team is complaining of performance issues in the system.

Have referred to below URL, but not sure of the steps.

How Update Statistics really works in SAP BW - Running SAP Applications on Microsoft Platform - Site Home - MSDN Blogs

Screenshot is attached(TX: RSRV).

Thanks.

Error.jpg (144.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.