Date measures enable members to have date-type values. The ability to process dates in the dimension where measures are represented can be useful for types of analysis that are difficult to represent using the Time dimension. For example, an application analyzing asset depreciation tracks acquisition dates for a series of capital assets. The company is fifty years old, so the acquisition dates span too large a period for feasible Time dimension modeling.
Additionally, date measures enable analysis of date values with small granularity, such as hours and minutes.
Use the following workflow to enable and use date measures.
Enable date measures in the outline properties.
Create a member to be a date measure in the dimension where measures are represented.
In the member properties for the date measure, define it as type “date,” and select the desired date format.
“Working With Typed Measures” in the Oracle Essbase Database Administrator's Guide