Page tree
Skip to end of metadata
Go to start of metadata

Description:
This property specifies a default date to use for members without a valid date when responding to an MDX query.

Values and behavior:
Any valid date in yyyy-MM-dd format. The given date value will be shown for invalid data of date type in MDX response.

Default Value:
1899-12-30

Scope:
Cube

Comes into effect:
This will come into effect in a new browsing session after setting the property on the cube. This property does not require a cube rebuild.

Dependencies and related properties:
NA

Recommendation:
Set this property when a date field has invalid values that get mapped to Unknown in a built cube.

  • No labels