If you plan to deploy cubes that contain a date measure, you should know that Essbase Studio applies the MAX aggregation function to the date measure column when generating data load SQL so that the result set will come out to the last transaction date.
In the following example, the Date column is used as a date measure:
Product State Sales Date ------- ----- ------ ---------- 100-10 CA 200.00 2009-01-31 100-10 CA 500.00 2009-12-31
Using the MAX aggregation function, data is aggregated on the 2009-12-31 date, and Sales totals 700.00.
Oracle suggests that you perform the following tasks when deploying a cube that contains a date measure:
In the General tab of Essbase Model Properties, select a date format.
The default date format is yyyy-mm-dd.
In the Cube deployment options page of the Cube Deployment Wizard, be sure to select Overwrite existing data from the Load data options group.