【cognos】增量刷新cube 4

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14310740

 

For incremental update, I am thinking of having two fact table in Framework Manager model : 1) Data Mart fact table 2) Copy of Data Mart fact table with filter to get only new data
This will require me to have two packages:
1) Pakcage 1 - containing Data Mart fact table and dimensions - this will be used for Full cube update

2) Pakcage 2 - Copy of Data Mart fact table with filter and dimensions - this will be used for incremental cube update

Incremental and full update flow will be :
1. Initial - Full update using package 1
2. Day 1(Monday) - Incremental update using package 2
3. Day 2(Tuesday) - Incremental update using package 2
and so on..
7. Day 6(Saturday) - Full update using package 1

 

 

=================================================================================

kay's word:

1. Set Transformer?

2. Change ETL?