--- title: Business Current View description: A Business Current View shows the current values of the satellites of a Hub or Link, one row per key, as a view in the Business Vault layer. --- [Skip to content](https://knowledge.bigenius-x.com/business-current-view#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en) 3. [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) # Business Current View **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle Architecture: Data Vault A Business Current View shows the current values of the satellites of a Hub or Link, one row per key, as a view in the Business Vault layer. It works like a [Current View](https://knowledge.bigenius-x.com/current-view?hsLang=en) and can also read Business Vault Hubs, Links, satellites and Business PITs. Use it to give marts or Vault Out the latest state of raw and business data in one view. ### Sources and relationships A Business Current View has exactly one dataflow with one dataflow set and no relationships. The dataflow set contains: - Exactly one [Hub](https://knowledge.bigenius-x.com/hub?hsLang=en), [Link](https://knowledge.bigenius-x.com/link?hsLang=en), [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link?hsLang=en), [Business Hub](https://knowledge.bigenius-x.com/business-hub?hsLang=en), [Business Link](https://knowledge.bigenius-x.com/business-link?hsLang=en), [Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en) or [Hierarchical Business Link](https://knowledge.bigenius-x.com/hierarchical-business-link?hsLang=en). - Either one [PIT](https://knowledge.bigenius-x.com/pit?hsLang=en) or [Business PIT](https://knowledge.bigenius-x.com/business-pit?hsLang=en) of that Hub or Link and the satellites of the PIT whose terms you need, or no PIT and exactly one satellite. The satellites can be [Satellites](https://knowledge.bigenius-x.com/satellite?hsLang=en), [Link Satellites](https://knowledge.bigenius-x.com/link-satellite?hsLang=en), [Business Satellites](https://knowledge.bigenius-x.com/business-satellite?hsLang=en), [Business Link Satellites](https://knowledge.bigenius-x.com/business-link-satellite?hsLang=en) and the four Effectivity satellite types. [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en) can read a Business Current View. ### Create the model object There is no wizard. [Create a model object](https://knowledge.bigenius-x.com/create-a-model-object?hsLang=en) of type Business Current View in the Business Vault layer, [create a dataflow set](https://knowledge.bigenius-x.com/create-a-data-flow-set?hsLang=en), [add the source model objects](https://knowledge.bigenius-x.com/add-a-model-object-into-a-data-flow-set?hsLang=en) and [map the terms](https://knowledge.bigenius-x.com/map-a-source-term-with-a-target-term?hsLang=en) you want to show: usually the hash key and business keys of the Hub or Link and the descriptive terms of the satellites. You do not write join expressions; the generator builds the joins. A filter expression of the dataflow set is added to the view. ### How the view finds the current values - With a PIT: the view reads the rows of the PIT result view that are valid until the End of Universe, one per key. It joins the Hub or Link on the PIT key and each satellite table on the satellite key and `BG_ValidFromTimestamp` that the PIT row references. A satellite without a version at that point contributes the values of its unknown-member row. - Without a PIT: the view joins the Hub or Link result view with the satellite result view on the key and keeps the satellite version that is valid until the End of Universe. A key without a satellite version does not appear. ### Properties - [Implementation Type](https://knowledge.bigenius-x.com/implementation-type-model-object?hsLang=en): `Virtual` only. A Business Current View has no Default Terms. ### Generated objects On Microsoft SQL Server, a Business Current View generates one object, the view `BDV_Current_` in the Business Vault schema, where `` stands for the name of the model object. Its target object role is Result. - There is no source view, loader or table, and no unknown-member row. - The view exists also when the project property [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en) is false. - It reads the PIT or Business PIT result view, the Hub or Link result view and, with a PIT, the satellite tables or, without a PIT, the satellite result view. A load does not run the view. It shows the data after these objects are loaded: ``` Hub or Link, satellites -> PIT (optional) -> BDV_Current_ ``` ### Example The Business Current View `based_on_hub_with_pit_bcv` on Microsoft SQL Server reads the PIT `customer_based_on_hub`, the Hub `load_customer_hub` and the two Satellites of the PIT. `load_customer_sat` holds the customer name, and `load_caching_hashing` holds the address. The view maps them to its own terms, which this example names in lowercase, such as `customer_id`, `customer`, `address_line1` and `zip_code`. The loads deliver these customers: - Load 1 on 2026-10-28 08:00: customer 1 Contoso Ltd at Bahnhofstrasse 1, 8001, and customer 2 Fabrikam AG at Unter den Linden 5, 10117. - Load 2 on 2026-10-29 08:00: customer 1 is renamed to Contoso Group, and customer 3 Northwind at Graben 10, 1010, arrives. - Load 3 on 2026-10-30 08:00: customer 1 moves to Hardturmstrasse 100, 8005. - Load 4 on 2026-10-31 08:00: no change. ### Check the result Query the view, here in the Business Vault schema `p2b`: ``` SELECT customer_id, customer, address_line1, zip_code FROM p2b.BDV_Current_based_on_hub_with_pit_bcv ORDER BY customer_id; ``` This is the result after load 4: ``` customer_id customer address_line1 zip_code 1 Contoso Group Hardturmstrasse 100 8005 2 Fabrikam AG Unter den Linden 5 10117 3 Northwind Graben 10 1010 ``` - Customer 1 shows the name from load 2 and the address from load 3, the current version of each Satellite. - The view has one row per customer and uses the term names of the Business Current View. ### Platform differences - Snowflake: names are in capitals. The dataflow property [Warehouse Placeholder Variable Name](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow?hsLang=en) applies. - Databricks and Fabric Lakehouse: the view name is in lowercase. - Databricks dbt and Snowflake dbt: the Business Current View becomes the dbt model `bdv_current_`. - Fabric Warehouse: the same view as on Microsoft SQL Server, deployed by notebooks. - Oracle: names are in capitals. ### Limitations - A Business Current View holds exactly one Hub, Link or Business Vault counterpart, and at most one PIT or Business PIT. Without a PIT it holds exactly one satellite. Validation reports an error otherwise. - When the view maps the `DrivingKeyLink_HK` of a Driving Key Link or Business Driving Key Link, it cannot read a PIT or Business PIT. - A Business Current View does not read Multi-Active, Record Tracking or Non-Historized satellites. ### Related articles - Previous: [PIT](https://knowledge.bigenius-x.com/pit?hsLang=en), [Business PIT](https://knowledge.bigenius-x.com/business-pit?hsLang=en), [Business Satellite](https://knowledge.bigenius-x.com/business-satellite?hsLang=en) - Next: [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en) - Reference: [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en), [End of Universe (Project)](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en) - See also: [Current View](https://knowledge.bigenius-x.com/current-view?hsLang=en), [Business History View](https://knowledge.bigenius-x.com/business-history-view?hsLang=en), [Model a Data Vault Solution](https://knowledge.bigenius-x.com/model-a-data-vault-solution?hsLang=en) - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG