Good day everyone,
please help me with following.
I have very confusing situation with my cube.
It contains pretty big amount of data (45 millions of rows), in data model before cube I have standard DSO.
Now my story:
I uploaded from 15 mlns. of rows to Cube rolled it up and compressed.
Next requests by reason I can not understand I was unable to compress but aggregated.

In the data which I had in this two initial requests was unable to retrieve for reporting.
I made selective deletion of this institutions data and performed full load from DSO to cube.
OK, data seemed to be ok. Problem is - this data constantly changes. I have a lot of rows with historical data like:
ID1 ID2 amount
10000123 10000345 300
10000123 10000345 -300
10000123 10000345 500
This rows decrease performance and make detailed reporting incorrect.
As I understand it can be fixed only after compression.
But I still can not perform it.

Most obvious solution would be to delete and reload data again, but I am really scared to do it
because my colleagues will definitely hang me if something will go wrong.
Please suggest solution.