Good day, everyone.
I have question regarding roll-up.
I have cube with big amount of data and queries work pretty slow.
Need to increase it, in queries I am using almost all dimensions.
Does it mean - I have to include all characteristics into aggregates?
Correct me if I am wrong -
1. it will increase time of roll-up, but dramatically decrease time of queries run?
When I am asking system for automatic proposal - seems it generates different aggregates for different queries.
2. What is better way - to create different aggregates for every query or include all dimensions into one?
3. Is there any way to create cube with functionality of Standard DSO? (no historical data, only fact table)
Thank you.