unable to upload data(bw to bpc)

hi friends,

i'm uploading bw cube data(HR actuals) to bpc cube. bw cube takes data from two sources(employee 14lacs & personal actionis 1.5 lacs), combinely bw cube have around 1.5 millon (15lacs) records. If i filter out data, i'm able to send to bpc cube via load data from infoprovider(datamgr package).

If want i send whole data (15 lacs), system is in 'Not responding' mode(i.e task mgr, if check status of bpc excel: it's in not responding) while validating transformation file. I'm unable to load this, how can i achieve?

any suggestions.