Hi All,
My cube having more than 2 GB.
I am getting below error while creating cube:
I have Set it MFT value to :5000000, (checked with 10000000 to 35000000), getting same error. Could you please need fully help on that. below is log file :
Thu 10 Aug 2017 8:19:55 PM 4 000002D9 Processing cube 'MENAP_SecondarySales_Cube' at location \\itsbebevcorp01.jnj.com\its_cognos_prd\consumer\cognosdata\project_data\menap\menap\transformer_models\menap_secondarysales_cube\mdc\menap_secondarysales_cube.mdc
Thu 10 Aug 2017 8:19:55 PM 4 0000021F Timing, UPDATE CATEGORY AND PROCESS WORK FILE,00:01:38
Thu 10 Aug 2017 8:19:55 PM 4 000002D9 Start metadata update of cube 'MENAP_SecondarySales_Cube'.
Thu 10 Aug 2017 8:19:56 PM 4 0000021F Marking categories needed.
Thu 10 Aug 2017 8:19:56 PM 4 0000021F Updating the PowerCube metadata.
Thu 10 Aug 2017 8:19:57 PM 4 0000021F Updating the PowerCube with currency data.
Thu 10 Aug 2017 8:20:04 PM 4 000002D9 End metadata update of cube 'MENAP_SecondarySales_Cube'. 123182 categories were added to the cube.
Thu 10 Aug 2017 8:20:04 PM 4 0000021F Timing, METADATA,00:00:09
Thu 10 Aug 2017 8:20:04 PM 4 000002D9 Start update of cube 'MENAP_SecondarySales_Cube'.
Thu 10 Aug 2017 8:20:04 PM 4 000002D9 --- Performing Pass 0 with 93224043 rows and 190608 categories remaining.
Thu 10 Aug 2017 8:20:04 PM 4 000002D9 Start Write leaving 190608 categories remaining.
Thu 10 Aug 2017 8:20:04 PM 4 0000021F Updating the PowerCube data.
Thu 10 Aug 2017 8:20:04 PM 4 0000021F Updating the PowerCube data.
Thu 10 Aug 2017 8:20:10 PM 4 0000021F Performing DataBase Commit at record number 500000.
Thu 10 Aug 2017 8:20:12 PM 4 0000021F Performing DataBase Commit at record number 1000000.
----------
----
Thu 10 Aug 2017 8:24:45 PM 4 0000021F Committing PowerCube(s).
Thu 10 Aug 2017 8:24:49 PM 4 0000021F Timing, CUBE COMMIT,00:00:04
Thu 10 Aug 2017 8:24:50 PM 4 0000021F End cube update.
Thu 10 Aug 2017 8:24:50 PM 4 0000021F Timing, TOTAL TIME (CREATE CUBE),03:10:55
Thu 10 Aug 2017 8:24:50 PM 2 0000021F (TR1901) PDS-PPE-0197 The local data cache size exceeded the allowed maximum of 2147418112 bytes.