Limiting the size of personal data sets

To manage the size of personal data sets, you can edit rules that limit the maximum file size per import and the maximum total size of imported files per user.

About this task

When creating personal data sets, users can import the following file types :

Microsoft Excel files, with either .xls or .xlsx extensions
delimited text files, containing either comma-, tab-, semi colon-, or pipe- separated values
Compressed files of any of the supported file types. For example, you may choose to compress your delimited text file as a .zip file to improve upload time.

In IBM® Cognos® Administration, you can configure three parameters that govern the size of personal data sets.

The default maximum values are recommended in most environments. You can increase the values, if necessary, but server performance may decrease. To configure the parameters, follow these steps:

Procedure

Click Launch, IBM Cognos Administration.
On the Configuration tab, click Dispatchers and Services.
In the toolbar on the Configuration page, click the Set properties - Configuration icon .
Click the Settings tab.
In the Advanced settings row, click Edit.
Tip: The three parameters that you will enter are case-sensitive. Also, ensure that there are no extra spaces at either end of the parameter and value.
Enter a parameter in the first row as follows:
1. Under Parameter, type MDSRV.DATASETS_MAX_FILE_SIZE_PER_IMPORT_KB
  Tip: To specify that the rule applies only to a specific tenant, type MDSRV.DATASETS_MAX_FILE_SIZE_PER_IMPORT_KB_tenantID
2. Under Value , enter a number that represents the maximum file size of a non-.xlsx imported file, in KB.
  Tip: The default value is 100,000.
Enter a parameter in the second row as follows:
1. Under Parameter, type MDSRV.DATASETS_MAX_FILE_SIZE_PER_IMPORT_KB_XLSX
  Tip: To specify that the rule applies only to a specific tenant, type MDSRV.DATASETS_MAX_FILE_SIZE_PER_IMPORT_KB_XLSX_tenantID
2. Under Value , enter a number that represents the maximum file size of a .xlsx imported file, in KB.
  Tip: The default value is 3,000.
Enter a parameter in the third row as follows:
1. Under Parameter, type MDSRV.DATASETS_TOTAL_SIZE_PER_USER_KB
  Tip: To specify that the rule applies only to a specific tenant, type MDSRV.DATASETS_TOTAL_SIZE_PER_USER_KB_tenantID
2. Under Value , enter a number that represents the maximum total size of imported files per user, in KB.
  Tip: The default value is 100,000.
Click OK.
It can take up to one minute for these settings to take effect.