Function RSDDCVER_RFC_BW_STATISTICS has returned
the result table with statistics. The "TimeDB"
for one of the cubes "Z_CUBE1" lasts much longer:
INFOCUBE____TIMEDB____DBSEL__DBSEL / TIMEDB
What's a reason for such a performance degrade?
Thanks a lot!
From the above mentioned scenario, i see that infocubes has huge TIMEDB and also
the records selected were very less.
I think the infocubes are storing the line item level data.
The performance of queries on these cubes will be very poor.You should think about creating aggregates.
As a general rule
An aggregate is reasonable and may be created if
. Aggregation ratio > 10 , i.e 10 times more records are read than are displayed and
. Percentage of DB TIME > 30 % , i.e the time spent on database is substantial part of
the whole query runtime.
Above details can be known from Transaction ST03.
Hope this helps