Hi All,
We are encountering TempSpace (PSATEMP) error while filling up the aggregate created on top of GL Total cube. As in case of initial fill it is considering all data from the base cube which is around 100 Million.
We increased the TempSpace to an extent that we cannot go any further. Also there is no standard option available where we can select reuests for initial filling.
Error:
SQL Error: 12801
we decrease the block size form blank (default 100,000,000) to 1,000,000 in SPRO settings
SAP Customizing Implementation Guide
SAP NetWeaver
Business Warehouse
Performance Settings
Parameters for Aggregates
.
but still it is consuming the entire TempSpace also there is no change in the backend SQL runnning in Oracle side (we were expecting some inclusion of wher claws there)
As we are out of option to fill this aggregate, we look forward to SAP SDN community to help us out.
Note:- The aggregate is system proposed and the Document No is included in that.