Unanswered: Incremental Update
I have the following requirement.
I have a fact table Acct_Rcv ( AR )
I have a Field in this fact table called load_nbr
I have created a view containing distinct load_nbr s from the fact.
I have built a dimension on this view. The dimension is a unilevel
hierarchy of the load_nbr s. Call this dimension LOAD
I need to incrementally update the Cube on a monthly basis.
Is there a way for the LOAD dimension to be incrementally updated
so that it shows only the Load_nbr s of the current month ( the month
used for the incremental update ).