Question:
Hi Fans,
Does anybody know where SAP get's no. records displayed in the aggregates maintenance screen.
Because right now I have an aggregate which on the maintenance screen says 9.263.800.
But if I look in se12
The E-table contains 4,3 mio
and the F-table 70.000
2 of the dimention tables are about 300.000,
and the rest contains less than 10.000.
How does it come up with 9,25 mio. ???
_________________
Rasmus ;o)
- One small step for man, one giant leap for mankind
Answer:
It should show the number of rows in the fact table, i.e. the sum of the /BIC/E and BIC/F aggregate tables. I've checked this is the case for one of our aggregates.
You could try running rollup, with compress aggregate option to see if that corrects the figures.
Answer:
All aggregates was rolled up and compressed at the time of the observation.
_________________
Rasmus ;o)
- One small step for man, one giant leap for mankind
Answer:
Hi Rasmus,
Did you find a solution to this problem, I am having the same issue.
I am not facing this problem for all aggregates - the difference between the aggregates which is having this problem is
1 The cube has an IO with time dep navigation attribute and
2 Because of the above reason it has a key-date which is SAP Exit for currrent system date
All the requests are compressed in the cube, the aggregate is also compressed, the record count on the aggregates screen is different then the record count in E-table. This is only happening when I do rollup using process chain - if I do a manual rebuild of aggregate the record counts are matching
regards
Phemrajani
Answer:
I think I found the solution to my problem - OSS Note 712237
Number 712237
Version 1 from 02.03.2004
Status Released for Customer
Set on 02.03.2004
Language EN
Master language EN
Short text Wrong number of records displayed in Aggregate
Maintenance
Responsible SAP AG
Component BW-BEX-OT-AGGR
Aggregates (Definition and Filling)
________________________________________________________________________
Long text
Symptom
On Oracle 9i it is possible that the number of records contained in the
aggregate in the aggregate maintenance screen (RSDDV) can be incorrect.
The number of records in the E & F fact tables in the database is
different than what is displayed in the aggregate maintenance.
Other terms
RSDDV, NUM_ENTRIES, aggregate maintenance, number of records, display
RSDDAGGRDIR
Reason and Prerequisites
The compression under Oracle 9i uses a new 9i feature, the MERGE
statement, which allows the previous "single record UPDATE + array
INSERT" to be done in one single (bigger) statement. Because of this,
the actual number of records inserted into the aggregate cannot be
calculated. It is only a rough estimate.
Solution
To correct the values displayed in aggregate maintenance (RSDDV) you can
run the following function module in transaction SE37:
RSDDK_AGGRCAT_SORT
parameter I_INFOCUBE InfoCube name
I_STATISTICS_READ X
This corrects the values only until the next compression.
Therefore, in order to have the correct values displayed after every
compression run, you should apply the recommendation in note 613701:
To switch back to the previous UPDATE-INSERT compression, you can change
the parameter COMPNOMERGE in the table RSADMIN to a value of X.
You can do this directly or with the help of the report
SAP_RSADMIN_MAINTAIN (if available). This parameter is evaluated
when the compression decides which compression template it should use.
________________________________________________________________________
Page 2
Valid releases
Software Component Release
from to
SAP_BW Business Information Warehouse
310 - 310
30B - 30B
Further components
BW-BEX-OT-DBIF
Interface to Database
BW-SYS-DB-ORA
BW ORACLE
________________________________________________________________________
Reference to related Notes
Number Short text
____________________________________________________________
785732 ORA-12801 and ORA-1652 when using MERGE for compression
613701 Problems with Compression on BW3.X and Oracle 9i
regards
phemrajani