Populate BASETYPE parameter in the Excel Table for Esri and ACS variables when creating a custom SDCX layer

Summary

When creating custom data in a SDCX layer, you may have a mix of default Esri variables and custom variables. When using the option for Importing parameters, ArcGIS Business Analyst Pro allows assigning values for multiple custom data variables and their properties simultaneously.

The ArcGIS Pro help topic Import Statistical Data Collection parameters goes over the requirements for the parameter table and the need for a column for each of the following parameters in an Excel table.

Procedure

This article specifically focuses on the inputs for the BASETYPE parameter.

The following table lists the different base types or apportionment methods that can be used.

Note:
For custom variables, populate base type as 'None', rather than any of the above base types. The reason for this is that custom variables are more likely to have a script or formula associated with them.