Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Description:
This property specifies the default numeric value for a NUMBER type column when the value is blank in the underlying data. When a value is set for this property, an empty value will not invalidate a row.

Values and behavior:

  • Blank: Blank values in the NUMBER type column invalidates rows.
  • Any integer: All the blank values for a NUMBER type column are replaced by the value specified here.

Default value:
Blank

Scope:

  • Connection: If the property is set at the connection, then the property value is applicable for all dataset build and cube build jobs.
  • Semantic model: If the property is set on a semantic model, then the value will override the connection level value for that semantic model's process job.

Comes into effect:
The value of the property can be changed at any time (not recommended) and comes into effect in the next build.

Dependencies and related properties:

Recommendation:
In cases where different numeric subtypes are used (float, double, long), an integer (long) should be used as the default. Decimal numbers if applied, return an error or skipped row.

  • No labels