Skip to Content
0
Former Member
Jul 21, 2016 at 08:37 AM

Cube data compression

107 Views

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.

Attachments

33.png (22.3 kB)
collapse.png (55.8 kB)