Server User Guides > Interviewer - Server > Export Data > DPM settings for exporting data
 
DPM settings for exporting data
Performance issues might occur when exporting data to SAV or Quantum data sources when the metadata approaches 90000 variable instances. Most of the following DPM properties were introduced in UNICOM Intelligence 7 Fix Pack 1 to address performance issues by providing options for limiting the number of variables that can be exported (for both VDATA and HDATA), and defining which DSCs are available for export.
DPM property
Default value
Description
Site > Servers > [ServerName] > Applications > InterviewExporter > AvailableDSCs
Empty
A comma-separated list of DSCs that are available for data export. When this property is not set, all configured DSCs on the server are available for export.
Site > Servers > [ServerName] > Applications > InterviewExporter > CanChangeSavAliases
false
The Export Data activity uses the property to control whether the Use SAV short names option is available. When a data source is present in the MDD file, and the property is set to false, the Use SAV short names option is not available. When the property is set to true, the Use SAV short names option is available, regardless of whether a data source is present in the MDD file.
Site > Servers > [ServerName] > Applications > InterviewExporter > MaxVariables
Empty
Defines the maximum number of variables that can be exported. For VDATA exports this is the maximum number of variable instances; for HDATA exports this is the maximum number of top level fields. If the project contains more variables than the defined maximum, an error is returned when attempting to export. When MaxVariables is not configured, the number of variables is unlimited.
Site > Servers > [ServerName] > Applications > InterviewExporter > NoLimitDSCs
Empty
A comma-separated list of DSCs that are not limited by the MaxVariablesproperty. When this property is not set, all available DSCs are limited by theMaxVariables property.
Site > Servers > [ServerName] > Applications > InterviewExporter > ApplicationSettings > DefaultContext
Empty
Defines the default MDD context when exporting data. The default value is empty, which correlates to the Analysis context.
Site > Servers > [ServerName] > Applications > InterviewExporter > ApplicationSettings > DefaultVersion
Empty
Defines the default MDD version when exporting data. The default value is empty, which correlates to ALL (all version can be exported). When set to LATEST, only the latest version is exported.
When the Export Data activity is launched, if MaxVariables is configured, theVariableInstances.Count is verified, and a warning dialog displays if theVariableInstances.Count value is larger than the value defined forMaxVariables. The warning message conditions are:
▪VDATA project, NoLimitDSCs=""
Warning: The number of variables for this project (2340) exceeds the maximum variables for export (2000). You can limit the number of variables using the “System variables” and “Variable types” options.
▪VDATA project, NoLimitDSCS<>""
Warning: The number of variables for this project (2340) exceeds the maximum variables for export (2000). You can limit the number of variables using the “System variables” and “Variable types” options or use an unlimited export format (NoLimitDSCs string).
▪HDATA project, NoLimitDSCs=""
Warning: The number of variables for this project (2340) exceeds the maximum variables for export (2000). You can limit the number of variables using the “System variables” and “Variable types” options. You might also be able to export using an export format that supports hierarchical data.
▪HDATA project, NoLimitDSCS<>""
Warning: The number of variables for this project (2340) exceeds the maximum variables for export (2000). You can limit the number of variables using the “System variables” and “Variable types” options or use an unlimited export format (NoLimitDSCs string). You might also be able to export using an export format that supports hierarchical data.
After clicking the Download Now button
▪The Export to list displays the AvailableDSCsvalue. If the AvailableDSCs value is empty, or the DPM property is not defined, the list displays all server-configured data sources.
▪If the selected data source (the selected Export to value) is one of the NoLimitDSCs values, the fields will not be counted and verified againstMaxVariables. The data export proceeds as normal.
▪If the user chooses one or more variable types from the Variable type list, the system only counts the user-selected types.
▪An error message displays whenever the user selects the Download Now button, and the field count is larger than the MaxVariables value. For example:
Unable to export.
The number of variables for this project (2340) exceeds the maximum variables that are permitted for export (1000).
Performance
Counting the VDATA variable instances and HDATA fields does not negatively affect performance.
See also
Export Data