server.essbase.disableDistinct

When set to “true,” allows users to disable the DISTINCT filter in member load queries.

The default value is false.

Syntax

server.essbase.disableDistinct=true|false

Notes

By default, when performing a member load, Essbase Studio Server adds the DISTINCT keyword to filter out duplicate records.
IBM DB2 users: A limitation in IBM DB2's handling of the LONG VARCHAR data type in a select DISTINCT statement causes cube deployment to fail. To avoid this, set server.essbase.disableDistinct to true.

Example

server.essbase.disableDistinct=true