I am new for support processes in BW. Can you please clarify one of my doubts regarding cube compression. I have my process chain developed in BW 3.5, data load is scheduled for one of my cube's on the daily basis. At the end of every month my cube data is getting compressed.
One fine day I came to know the data load for 4th september was done two times and data for that date is duplicated. Later Cube was compressed on the last day of September means 30th Sep. Now when today on 13th October I came to know about data duplicacy with my compressed cube then how exactly can I handle the same to remove data that was loaded twice in my compressed cube?
Please also guide me in understanding Cube parrtitioning/Compression/Archieving.
Thanks in advance.