View: Business Unit

This article will help you learn about the fields available in the Business Unit view, the field types, descriptions and how the fields are calculated

Key Topics

List as bullet points the key topics outlined in this article

View Definition

This view is linked to the [drp.order_business_unit] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.


Field Name Field Type Description Source / Calculation
Business Channel Dimension From the Daasity UI (Direct to Consumer or Business to Business) business_channel
Business Unit Dimension Value entered in the Daasity UI business_unit
Sales Channel Dimension Sales Channel based on Shopify App ID sales_channel
Source Name Dimension The name of the integration, as named by Daasity source
Store Country Dimension Country entered in the Daasity UI for the Integration store_country
Store Integration Name Dimension The Name from the Location otherwise the name from the Daasity UI store_integration_name
Store Name Dimension Location Name otherwise the Store Type from the Daasity UI (eCommerce, Wholesale, Retail, Amazon, Marketplace, Manual Orders) store_name
Store Type Dimension Type selected in the Daasity UI for the Integration store_type


This view is part of the following explores:

  • Order & Order Line Revenue

Transformation Code

This view is a Daasity derived table generated by the following code:

  • [2710_OST_BAS_order_business_unit.sql]