If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Incremental update the cube for last 3 months of data

Started by saranya1805, 10 Aug 2010 03:52:40 PM

Previous topic - Next topic

saranya1805

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.

twlarsen


saranya1805

#2
How to refresh the cube in 1st week of every month for last three months of the data?

Sarayucog

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.