Controlling Spreadsheet Periods
Within a Full Array spreadsheet, the number of periods to be displayed can be controlled for all streams specified in the spreadsheet setting. The starting date is always based on the DSX System Date in the Global Options. The Starting Period can be negative to include past periods. The period is based on the time period associated with the spreadsheet, not the overall storage type.
Key Items to Consider:
1) This option is particular helpful to clients working in a weekly database that have a long calendar defined for workspaces. This can be set up on any spreadsheet setting and will minimize the need to use filters to limit the range of periods.
2) Past Due can be placed on the spreadsheet for use with requirements planning.
Example: Below is a Full Array spreadsheet with all periods displayed. There is 8 year calendar applied which begins in August 2011, and the DSX System Date is 12/29/2014. By default, a spreadsheet with these settings will always start with the first period in the calendar, which is August 22, 2011. Filters would have to be applied in order to find the current date.
Modify the spreadsheet to include three periods in past and twelve periods in the future.
The resulting spreadsheet only displays the selected 15 periods without having to apply filters to limit the amount of data being displayed on the spreadsheet.
Not using Demand Solutions DSX?