---
title: "Business Views"
canonical: "https://docs.vaultspeed.com/space/VPD/3011182668/Business%20Views"
format: markdown
---
On the Business Views screen, you can see all the views VaultSpeed automatically creates for you to expose your raw data vault objects virtually on the business vault schema on your database.

![image](media://8deb5551-a9bf-4ed4-8934-7277cf8a7453)

In the first column, you see the actual object name from the raw data vault on the screen.  The next column is the Signature Object Type, followed by the name of the view that will be created on the business vault layer.  By default, this is the same name as the name on the raw data vault.  

Next, you see the Short Business Name and Abbreviated Business Name columns used for PITs, Bridge Tables and VaultSpeed Studio objects created from these Business Views in later stages. In more detail:

- PIT:
  - Pit table name
    - pit_table_prefix parameter
    - pit_table_name (if pit_prefix parameter = Y)
    - **abbreviated_business_name**
    - pit_table_name (if pit_prefix parameter = N)
    - pit_table_suffix parameter
- Bridge:
  - Bridge Business key attribute
    - attribute_prefix
    - **short_business_name **(Only if there would be a conflict because of duplicate attribute names)
    - attribute business_name
    - attribute_suffix
  - Bridge Foreign key
    - The foreign key prefix parameter
    - attribute_prefix
    - bridge table_name
    - **abbreviated_business_name**
    - attribute_suffix
    - The foreign key suffix parameter
- VSS
  - VaultSpeed studio object name
    - Template prefix
    - **abbreviated_business_name**
    - Template suffix
      

If there are duplicates and used in Pits, bridges or the VaultSpeed studio, then the tool will throw a warning when locking the Business Vault

In the last column, we have name(s) of the source systems that provide data for that object in the raw data vault.  In the case of grouped hub objects, this can be more than one source name.  After that, you have the Generate toggle switch and the Action menus to edit the object or go to the individual attributes of that object.

By default, all of these views will be generated when you generate your ETL code.  You can edit the record and uncheck the slider in the ‘Generate’ column if you don't want to generate one or multiple views.  Don’t forget to click the ‘Save all’ button at the top to save your changes.

You can adjust the slider for multiple objects at once by using the checkbox at the top of the ‘Generate’ column.  This will disable/enable the generation of all objects in your current selection (should you use the search box).

To edit a particular object's attributes, you can use the ‘Attributes’ action button at the end of each row.  Editing here happens in the same way.  Use the Actions menu to go to edit mode, change the slider not to generate this attribute, or change the business name.  And again, don’t forget to click the ‘Save all’ button when you are done editing.

> 📝 For Postgres and Greenplum, VaultSpeed has an automatic DDL-setting added to these views to do a DROP CASCADE before creating these views again.  If you have objects depending on these views, these might be dropped as well through the cascade.  Make sure you add your own DDL again into the deployment if needed.

### Export/Import Business Names

For an easier way of editing multiple objects at once, or if you already have a list of business names available in your organization, you can also use the buttons to first download a list of all business names, edit them on your local machine, and then upload that list again to reflect those changes inside of VaultSpeed.

You can export the Object or Attribute names using their respective buttons.  This will download a CSV file to your local machine: ‘business_vault_object_names_overview.csv’ or ‘business_vault_attribute_names_overview.csv’.

- business_vault_object_names_overview.csv
  - this file contains all objects and their business names for this specific data vault release
  - the first row should always contain the header:
    - datavault_name;table_name;table_business_name,short_business_names,abbreviated_business_names'
  - the data rows should follow the same structure.
- business_vault_attribute_names_overview.csv
  - this file contains all attributes for the objects
  - The first row should always contain the header:
    - ‘data_vault_name;table_name;column_name;column_business_name’
  - the data rows should follow the same structure

After editing these files, you can import them again to VaultSpeed using the ‘Import Object names’ and ‘import Attributes Names’ buttons.  Click on the correct button and select the file and click ‘upload’.

> ℹ️ Only Objects that are in the “business_vault_object_names_overview” files will be generated.  If an existing object is not included in this list, the “Generate” slider will automatically be set to the off position.