Handling Gap in Data Stream
Due to a 2-3 weeks of gap in the data stream, I need to ignore the data for those weeks from all computations in an Anaplan model that is nearly 50GB in size. If those weeks remain as null/no data, those cells would still remain part of the computation particularly if the logic indicates Sum/#N Weeks or moving average. The data gets loaded automatically into Anaplan from SQL via Informatica. In excel, the solution would be simply not listing/deleting those weeks from the spreadsheet. I've been looking into a solution to handle the gap in the data stream in Anaplan. Recommendations would be appreciated. Thanks!