Edit Valid Date Range

On the Reporting data mart page, you can specify a valid date range for the OLAP cube. The cube excludes all dates outside this date range from its date dimensions so that only dates within the date range are considered when you use the cube for reporting and analysis.

To specify a date range, click Edit valid date range under Configuration. The Edit valid date range screen appears.

In the Start Date and End Date fields, enter a date range for the cube’s date dimensions. To search for dates, click the calendar icons. Click Save. You return to the Reporting data mart page.

After you set the date range, you must apply it to the cube. First, click Reset ETL under Refresh data to reset the incremental ETL refresh to prompt a full refresh during the next ETL process. Then click Start ETL fefresh to manually start the ETL process. For more information about these tasks, see Reset ETL and Start ETL Refresh.

Data Marts Configuration