Hi, i want to avoid the overload on cube, since datasource that i have does not support delta load, so now if i load full every day it will kill the cube,
1. So to resolve this I want to add the Fiscal Year and period in datasource from table ANLP and the load once a month by period and delete any overlapping request. confirm me if this is the right approach.
2. please tell if i take Fiscal Year and period from ANLP(aSSET Table) and add to datasource for real estate does it matter or the field has to come from Real estate table. i don't think it will harm and will work fine. please confirm.
thanks
soniya
I will assign the points asap as anybody help me.
thanks
Regards
Soniya