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
how do you run the incremental load? manually or using script?