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

Cube Incremental Load

Started by bwalikar, 22 Jul 2016 09:07:52 AM

Previous topic - Next topic

bwalikar

Hi All,
Could you please help me with the steps involved in incremental cube load.

Current approach followed :
Incremental load source report : has a filter like date id = max date ID --> to fetch only the latest data from db.
incremental mdl : with the following property checked : this cube build incrementally.

full load source report : which we plan to run weekly once : no date id filter
full load mdl

botjh mdl build the same mdc.

first load which is full load works fine, but when incremental mdl is trying to build we get following WARNING - "TR1900: The wrong ID stamp was detected on mdc" followed by ERROR : "TR1901 cannot delete a roll up that contains current data"

Interestingly, incremental update works fine if the property for incremental load is changed in Full load mdl and is pointed to inc source report.

any help here is greatly appreciated. thanks

Francis aka khayman

how do you run the incremental load? manually or using script?