settingsLogin | Registersettings
Scalefree
Show Menu

How to DV model Invoices

0 votes
Simple use case.

Company FooBar receives invoices from external vendors A thru H. Think of your home invoices, you get an invoice from Water, Electric, Gas, TV, Internet, Cell, and Rubbish, etc.. Each invoice has a few common attributes like Date and Total Fee, and then an extra set of attributes that are custom to that companies invoices. In the end reports will need to be ran on Total Fees, By Invoice Type, By Month.

The reports will be ran off from the virtual Dimensional model on top of the Data Vault.  Can you recommend how to model this simple use case in Data Vault?

Thank you,
 Craig
asked Oct 22, 2017 by radracer177 (140 points)

1 Answer

+1 vote
Hi Craig,
this is not a simple case...
You have a lot of different souces which ends normally up in a lot of different satellites containing the descriptive attributes.
A Hub for you or your wife or children as recipient/person, a hub for the sender/vendor and a link for every invoice in between. Maybe a Hub for the invoice-number or the invoice-number can be a degenerated azttribute inside the link. But only if you don't really want to use this invoice-number. Normally it should be a hub.
Then a satellite on the link containing the common invoice-attributes and for all not common attributes and for all the other attributes satellites on the link and maybe on the vendor-hub, dependent on if the data belongs to the vendor or the invoice...
Every vendor can be handled as a new source which normally means for every source a own satellite.

You see: That's not really a simle case
answered Dec 6, 2017 by gherzog (380 points)
Scalefree Scalefree

Upcoming Trainings

  • July 01 to 03 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • August 05 to 07 - Berlin (German) Data Vault 2.0 Boot Camp and Certification

  • September 9 to 13 - Hanover WWDVC EU

  • September 16 to 18 - Brussels (English) Data Vault 2.0 Boot Camp and Certification

  • October 21 to 23 - Hanover (German) Data Vault 2.0 Boot Camp and Certification

  • November 18 to 20 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • December 02 to 04 - Dusseldorf (German) Data Vault 2.0 Boot Camp and Certification

  • December 16 to 18 - Zurich (English) Data Vault 2.0 Boot Camp and Certification

  • Contact us for inhouse training engagements.
    Visual Data Vault: Logical Modelling for Data Vault - Free Download!
    Scalefree
    DataVault.guru is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.
    Permissions beyond the scope of this license are available in our license.

    DataVault.guru | DWH Wiki | Recent questions RSS feed | Imprint | Provided by Michael Olschimke
    ...