HOW TO ACTIVATE THE MONITORING ATTRIBUTE IN BW FOR PARTICUALR AOME TABLE.

[Former Member]

Hi,

I'm facing following warring in UpdateStatastic of my BW server..

BR0988W Bitmap index /BI0/E0CM_C05~040 selected for checking statistics - please activate the monitoring attribute for table SAPABD./BI0/E0CM_005.

This warning is occred for more then 55 different table....

How to resolve this..??

Regards,

Neehir Bhatt

[Former Member]

Hi,

you can activate the monitoring attribute by using the following sql command :

SQL> select table_name from sys.dba_tables where table_name

like '%BI0/E0CM_005%';

SQL> select owner from sys.dba_tables where table_name

like '%BI0/E0CM_005%';

SAPDAT

SQL> alter table SAPDAT."/BI0/E0CM_005" monitoring;

Table altered.

Hopefully this resolves your issue.

Regards,

Eddy Rombaux