Filtering on Reporting Period ID

Every report should be filtered by the reporting period ID (either through the use of a prompt or a filter) unless the user wants to report across all reporting periods.

You could, for example, prompt the user explicitly for a specific reporting period and filter by the selection. Or, you could filter by the Reporting Period ID value -1 if the report is only available for the current reporting period.

Tip: When combining filtering on Reporting Period ID with filtering on entity, you must use the GEN_REPORTING_PERIOD_ID as the filtering item for the Reporting Period ID.