The configuration parameter described in this section can be specified in the ais.cfg file that is installed on Windows and UNIX. This parameter cannot be specified in the startup.bat file or at the command line.
To allow addition of duplicate data records when using an aggregate storage database. The default behavior is to set the data load option in aggregate storage to not allow duplicate records.
To allow duplicate data records when using an aggregate storage database, add [ADDDUPLICATESFORASO]=Y to the ais.cfg file.
In Windows and UNIX:
In the ais.cfg file, this parameter is specified in the following format:
[ADDDUPLICATESFORASO]=Y
To obtain correct results when an aggregate storage database contains duplicate records with different values. In the following example, duplicate records at the intersection of SKU, MONTH, and STATE show different results for SALES:
SKU MONTH STATE SALES 100–10 JAN CA 389.99999999999994 100–10 JAN CA 390
When a database contains duplicate records with different values, data loads are terminated with an error; for example:
IS Error(EssLoadBufferTerm): Data load failed: input contains different values for the same cell [(Jan, Sales, 100-20, Florida): 389.99999999999994 / 390] 1270089
When you add the [UNIFORMVALUEFORMAT] parameter to the ais.cfg file, data load results for measures are rounded up or down as appropriate to six decimal places (0.000000), ensuring that the duplicate records will have the same value.
Using the same data from the example above, the results would be:
SKU MONTH STATE SALES 100–10 JAN CA 390.000000 100–10 JAN CA 390.000000
To enable uniform value formatting, add [UNIFORMVALUEFORMAT]=Y to the ais.cfg file
In Windows and UNIX:
In the ais.cfg file, this parameter is specified in the following format:
[UNIFORMVALUEFORMAT]=Y