We have a cube which is currently taking 14 hrs for 15 months of data.
Our requirement is to show at least 12 months of data means if we are in Jan 2011 we have to 2010 complete year.
These cubes are refreshed in the 1 week of every month. In our fact data will be updated for 3 month (current + 2).
Example: If we refresh cube in Sep 1st week - ETL will update data in the tables for June, July and August.
Please let me know if anyone knows about it. Also, if any workaround.
Whats the problem you are having?
How to refresh the cube in 1st week of every month for last three months of the data?
Which data source you are using IQD or REPORT or PACKAGE etc...
If you are using IQD add a filter to your IQD to restrict the data for the 3 months.
Are you running the cube manually or are you using any schedules to run the cube automatically.
If you run the cube manually add a WHERE conditon manually for every 3 months and run the cube.
If you run the cube by using shcedule add the WHERE condition to take the dates dynamically.