Back to overview

Online Magazine

How to model a Business Link?

Key Visual Hack of the week

In your DWH (Data Warehouse) with a Data Vault modeling, you should need to model some Business Links between Hubs or between a Hub and a Business Hub. Of course, you need to add some filter conditions like in this example for the Business Link between the Hub HUB_CreditCard and the Business Hub BVHUB_CreditCard_SuperiorCard. 

 

By Claire Pierreclos

 

Noob Hack

Your Business Link Data Flow Set should access the Hub HUB_CreditCard and the Satellite SAT_CreditCard to be able to put the needed filter CardType = ‘SuperiorCard’: 

 

 

Pro Hack

It exists a faster way to implement your Business Link Data Flow Set: you can use the Derived DWH Object HubCreditCard_RDV_Hub_Result_VI_SQL: 

 

 

No need of a join between Hub and Satellite. 

Derived DWH Objects permits to create new DWH Objects based on existing Target Objects. They are new model objects without generated code: they point to an existing Target Object. 

In this case we can directly use the Result View containing data from the Hub HUB_CreditCard and the Satellite SAT_CreditCard to access the hash key for the relationships to the Hubs and the CardType information for the filter. 

 

All the the details can be found in our community site.

Hint: If you already are a biGENIUS user and have no access to our community site, please ask the biGENIUS support.  

Read more about biGENIUS

 

Read the next biGENIUS Hack

Your contact

SUCCEEDED? THERE'S MORE TO DISCOVER ...

Q&A - the Game
Key Visual Q&A - The Game
Cloud AI

Q&A - The Game Launch Edition
In conversation with
In conversation with Jolanda Spiess Hegglin
AI Analytics

... Jolanda Spiess-Hegglin
TechTalk
Key Visual Tech Talk
Google Analytics

Dschingis Khan & Knowledge Graphs