Rollup in BW
Hello,
I have just created a SAP note that relates with the steps to create a rollup in BWA. As you all may know
If new data packages (requests) are loaded into the InfoCube, they are not immediately available for Reporting via an aggregate/BWA index. To provide the aggregate/BWA index with the new data from the InfoCube, you must first load the data into the aggregate/BWA index tables/indexes at a time which you can set. This process is known as a Rollup.
Even though it mainly mentions BWA, most of it can also be applied to the creation of rollup to aggregates. Go ahead and check it out it contains documented screenshots with how to guides:
2002291 – How to create rollup in BWA
Please also check out the following links for guindace here too:
Rolling Up Data into an Aggregate (SAP Library – Performance Optimization)
Rolling Up Data to a SAP NW BW Accelerator Index
Also, for rollup issues involving BWA take a look at SAP note 1791621 – BWA Rollup/Change Run Issues
As for aggregates rollup issues, my best suggestion would be to recreate the aggregates, as per below:
Deactivate the aggregate with program SAP_AGGREGATES_DEACTIVATE, activate with the program
SAP_AGGREGATES_ACTIVATE_FILL then reactivate and fill with the RSDDK_AGGREGATE_DIRECT_FILL program.
Best Regards,
Diego Seben.
SAP Active Global Support
Thank you so much for all these pieces of information! 🙂