MAXDATE
Specify this Essbase configuration setting to define the upper limit for date measures you can export and import. This configuration is applicable only to cubes that have typed measures enabled.
Syntax
MAXDATE [appname [dbname]] dateConst
appname—The application for which you want to specify max date.
dbname—The database (cube) for which you want to specify a max date.
dateConst—A constant in format of
YYYY-MM-DD
representing the latest possible date recognized by
Essbase.
Description
There are two cases where the value of a date measure can become
invalid:
- If the exported date value exceeds dateConst, Essbase extracts the value as a "#Txt:OutOfRange" string. This exported data file with "#Txt:OutOfRange" strings can be reimported to Essbase if you want to load value "OutOfRange" of values to the date measures.
- Data load fails if date measure values exceed MAXDATE value. The error
message reads:
Date measure value %s is out of range
Notes
- Windows supports dates up to December 31, 3000. There is no limit for MAXDATE on Linux.
- For Windows installations of Essbase, if you set the value of a date measure in the data load source higher than December 31, 3000, Essbase will return an error: "Date conversion failed for date type measure value #Txt:%s", and the data load will fail.
- The MAXDATE format does not have any relationship or dependency with
the date format of the outline. So, whatever the format date is in the outline,
the format of MAXDATE should always be
YYYY-MM-DD
. - Described behavior is correct for block storage and aggregate storage databases.
Example
MAXDATE 3000-12-31
See Also