I have created a Multifile cube by setting the multifilethreshold value at 500,000. but the cube build failed with the this error message in the logfile.
(TR1901) PDS-PPE-0197 The local data cache size exceeded the allowed maximum of 2147418112 bytes.
I have changed the multifilethreshold value to 10,000,000 and still fails. I have noticed that mdp file it creates is 1.99GB, so I think it has reached the limit.
The Maximum number of transactions per commit is set to 500,000 and the last Performing Database Commit at record number is 66,000,000
Any suggestions please?
Thanks in advance.