Aggregate RPAS Arrays (%2, %3, etc)

 Hi everyone,

I have a question about the aggregate arrays (%2, %3, etc.) within RPAS and how/when they are created and stored.  My previous understanding was that when building a workbook, RPAS will pull all of the required measures into the workbook database (txxxxx.db) at their base interesections.  Then based on the levels of the worksheets that the measures were used, it would create these aggregate arrays that were at the intersection of the worksheet and aggregate the measure data from its base intersection to the aggregate intersection.

For example, assume that regsls is registered @ week/clss/str/brnd and the worksheet is at month/clss/str.  During build, RPAS creates both regsls%1 and regsls%2 in the workbook database t00000.  The measure regsls%2 is the array that contains the data that was aggregated from week/clss/str/brnd to month/clss/str and is the data that is visible in the worksheet.  Both arrays exists in the workbook database at the same time and are populated.