Reporting account data between only open and closed dates

In general, data that is loaded into accounts is reported in reports and dashboards even if they fall outside of their Account Open On and Closed On date range. The setting of Open On and Closed On dates only prevents new records from being added to the account. However, it does not control the reporting of existing records within the account. To prevent such data from reporting, one option is to create additional consolidation rules to prevent ineligible data from reporting. However, the limitation of that approach is that sometimes it is not feasible to achieve an accurate reporting arrangement due to monthly-based consolidation rules. For example, an account was closed on June 10th but its consolidation rule can only be set to reporting 0% starting from July 1st, thus resulting in an undesired reporting outcome for the month of June.

Instead, you can enable account data to be reported only between open (Account Open) and closed (Closed On) dates. Once enabled, any data that falls outside of the Account Open and Closed On date range will be excluded from the Monthly Data (Stats) table, which serves as the backbone for the platform reporting. In addition, for data that does get computed into the Monthly Data table, it is also prorated to the Open and Closed On date in its month. For example, an Account was closed on June 10th and the last invoice is 100 kWh from June 1st to June 30th. In this case, only 100 kWh / 30 days * 10 days = 33.33 kWh will be reported for the month of June.

The following diagrams show the default behavior compared to the enabled behavior.

With the default behavior, the stats table contains records from all dates:

In contrast, when the feature is enabled, the stats table contains records from the date range between Open On and Closed On.

Note: Be aware of the following factors when enabling this feature:

• Existing monthly data in accounts are not immediately updated to reflect the new setting. The reporting amounts are only updated when there are data changes to the account, such as a new manual data capture, new data loaded through a file, alternation of values in an existing record, or setting a new date value for either Opened On or Closed On of the Account.

  If you require the changes to immediately apply to existing data immediately, contact IBM Support, as this requires a data crunching job to be run only during after-office hours.

• This feature only applies to account data but not to any interval meter data. Within account data, only accounts that use IBM® Envizi ESG Suite's generic monthly data consolidation process are covered. Air Travel accounts and any other accounts that use custom monthly data consolidation logic are not impacted by this feature.

Use the following procedure to enable the feature: