I am constructing a View in the Prolog of a TI. The view consists of LEAF elements from all of the dimensions but one dimension subset contains only one element which is a Consolidated node.
The View works fine without any errors if the Consolidated element being used contains a smaller number of child elements. But it fails if the Consolidation contains thousand of child elements. Please note in both cases the subset of this dimension will only contain one single consolidated element. I am also Skipping the Zeros in the View. There are no rules on the cube.
Code: Select all
VIEWEXTRACTSKIPCALCSSET( cubTarget , sDataTargetView , 0); #have to keep this as 0 because my source element is consolidated element
VIEWEXTRACTSKIPZEROESSET( cubTarget , sDataTargetView , 1);
Code: Select all
TM1.Server.Memory al_Alloc() outOfMemory Exception <<< MEMORY_TEMP_POOL_EXCEEDED >>> MaximumViewSize memory exceeded - apifunc# "196" - pool# "0" - poolsize "535201358.000000"
Code: Select all
MaximumViewSize=1600
MTQ=8