-D

To specify whether or not to add the DISTINCT clause to the SELECT statement of drill-through SQL.

The default behavior adds the DISTINCT clause. To not add the DISTINCT clause:

In Windows:

In the startup.bat file, to specify that the DISTINCT clause should not be added to drill-through queries, add -DN after "C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe". For example:

"C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe" -DN 

Any value other than -DN or no value specifies that the DISTINCT clause should always be added to drill-through SQL.

In UNIX:

To specify that the DISTINCT clause should not be added to drill-through queries, type:

olapisvr -DN

In Windows or UNIX:

In the ais.cfg file, this parameter is specified in the following format:

[D]=N