About BDS Layers

What is a BDS Layer?

BDS (.bds) is a file extension that stands for Business Analyst data source. BDS layers are custom ArcGIS feature classes used exclusively throughout Business Analyst. Technically, a BDS layer is an XML wrapper that provides the following benefits:

• Allows attribute table field headers to bypass the 10-digit maximum character code names and use a descriptive alias name. For example, each ESRI demographic layer (such as block groups or ZIP Codes) contains more than 1,500 variable fields. Each of those fields contains a constant field code name that doesn't change for yearly updates. Keeping track of 1,500+ field codes would be nearly impossible, so the BDS layer displays the long name description instead.

  Here are some examples of the code name versus the BDS alias name:

  10-digit code names	Alias names shown through a BDS layer
  TOTPOP_CY	2010 Total Population
  FEMU5_CY	2010 Female Population 0-4
  POPGRWCYFY	2010-2015 Pop: Annual Grwth Rt
  X9001_X	Entertainment/Recreation: Tot

• Allows you to decide how your data is aggregated to your trade areas and reports. For more on aggregation options, see Custom Data Setup.
• Allows you to join your data to an existing BDS layer. This is helpful if you have, for example, sales figures by ZIP Code. You can join your ZIP Code sales figures by ID to the ZIP Codes provided in Business Analyst. You can also include any other demographic fields in the layer and maintain the data aggregation settings and descriptive field headings. This join in turn allows you to exceed normal ArcGIS table limitations on the number of fields you can have in an attribute table.
• Allows you to create custom calculated fields. For example, you can take the 0–4 Ages Population field plus the 5–9 Ages Population field and combine them to form a 0–9 Ages Population field. Since the demographic layers in Business Analyst are in read-only Smart Data Compression (SDC) format, a BDS layer can perform these custom calculations without modifying the read-only layers.
• Allows you to view and use your BDS layers throughout the Business Analyst wizards including customizing reports, appending data, or customer prospecting. Many of the wizards reference the BDS demographic layers provided in the product out of the box. When you create a new BDS layer, it appears in the same list as the others. A .bds file extension appears.
• Can be used on any of the ESRI Business Analyst suite of products. For example, any BDS layers created in Business Analyst Desktop can be uploaded to the UserData folder in the Business Analyst Server dataset. Right-click the BDS layer name in ArcCatalog and choose Upload and the desired location and preferences.