I have a Infocube which is having huge number of data records in production. The fact table contains around 100 million records.
I have 2 Aggregates built up on this Cube and the 'Activate & Fill' job is scheduled to run weekly on this Cube.
The problem is that this job runs for more then 5-6 days and then it fails. This is happening for many weeks now.
I also tried to compress the data in Fact table hoping that it will help the aggregates filling, but to no luck.
Now both the E and F table of the Info cube are heavily loaded and the Aggregate job is still failing.
Can anyone let me know how to proceed with this / where to check for failure reason?
1. Is it only bcoz of the huge data that the aggregates are failing?
2. Is there any other way of knowing the failure reason?