Still "uncompressed" package after Lite Optimize.
I'm having problems with duplicate keys, when I export data from SAP BPC to a flatfile.
I run a "lite optimize", and it runs without problems, but when I look at the planning cube in SAP BW, I can see that the last 3-4 packages are still uncompressed.
When I try running a "full optimize" the system informs me that it is not nessecary, but I still have 3-4 uncompressed packages, which leaves me with duplcate records in my flatfile export.
I'm I missing a parameter setting somewhere - or should I manually compress the planning cube in SAP BW ? I rather not use "standard bw" functionality in a BPC setup, since it is my understanding that it is not adviced to use standard BW functionality on BPC cubes ?
VaraPrasadraju Potturi replied
Goto RSPC and search for process chain /CPMB/LIGHT_OPTIMIZE.
Double click on Collapse then system would open another window with details of process.
Make sure Number of requests that you do not want to collapse = 0.
And try again.
Hope it works...