COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: aliclowes on 30 Jun 2010 02:39:22 AM

Title: reject file location
Post by: aliclowes on 30 Jun 2010 02:39:22 AM
Hi

Is it possible to set a default directory for the reject files, without having to change each fact build individually ?

Thanks  :)
Title: Re: reject file location
Post by: yepperstn on 30 Jun 2010 03:31:55 PM
Within the Performance Apps IBM Cognos make use of an environment variable called "REJECTFILE_ENV_VAR" to set a path to the reject files (this is done within the environment variables for the user).  Each build then references a parameter called {$REJECTFILE_ENV_VAR} that is replaced with the respective path at runtime.  So, a build that loads sales might have the following on the Input tab > "Write any rejected records to:" field:  {$REJECTFILE_ENV_VAR}\sales.rej

Hope this helps ...
Title: Re: reject file location
Post by: MFGF on 30 Jun 2010 04:39:42 PM
Quote from: aliclowes on 30 Jun 2010 02:39:22 AM
Hi

Is it possible to set a default directory for the reject files, without having to change each fact build individually ?

Thanks  :)

Hi,

If memory serves, the reject files are created by default in the Data folder.  You can modify the location of this using Cognos Configuration, or by setting the DS_DATA_DIR variable.

Regards,

MF.