Skip to Content
0

Large /BI0/E0TCT_C02 table is mostly index

Dec 21, 2017 at 04:13 PM

53

avatar image

I recently began supporting a BW 731 system who's largest table is /BI0/E0TCT_C02 which is SAP Front-End and OLAP Statistics (Details) Table.

The table is 44gig of which 39Gig is made up of indexes and growing. It contains 129,949,145 rows.

I have had no luck finding a maintenance job to control this and appreciate any suggests folks might want to offer on how to get this under control and keep it there.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prakash K Dec 27, 2017 at 09:41 AM
0

Hi William,

What would you like to do exactly?

If you want reduce the data in cube please go through below notes.

1431315 - P24: Reduction of very large request lists in cubes and DSOs

2146472 - FAQ for Report - RSSM_REDUCE_REQUESTLIST and RSSM_EXPAND_REQUESTLIST

Reagrds,

Prakash K

Show 1 Share
10 |10000 characters needed characters left characters exceeded

What I would most like to do is reduce the size of the Index or at least explain why it is so large in relation to the data.

Since it is an sap delivered cube used for "Front-End and OLAP Statistics (Details)" I hoped there was a process to maintain it better.

0