Refreshing Cube

[Francis aka khayman]

I need expert opinions.

We have a cube that takes several hours to refresh. I am trying to cut the refresh time down. Upon examining the facts this is what I found:

1. Full refresh daily because product group can change anytime.

2. Cube has 3 years data, all are loaded everyday for full refresh because of #1 but only current year data can change.

3. Query for #2 takes about 1 hour to get all data

My thoughts:
1. Filter query for #2 to take only current year data
2. do regular full refresh on weekend or after office hours.


Any comments welcome. Thanks in advance.

[Ricardo Julio "Ricky" Villa]

See if there are any long running (read time) queries from the Transformer build log file.

If there is see if their read times can be reduced by pushing back to the database, e.g. create views, materialised views or pre-populate tables.  This may involve aggregating / summarizing the data.