Drill-across relationships (Invoices -> Payments etc.)

Daniel Wikar at 13h36
30
Nov
2009
Drill-across relationships (Invoices -> Payments etc.)

I have a question regarding the relationship between fact tables to enable drill-across between these. I have a number of fact tables in my design, Invoices and Payments, are two of them.

  • Invoices contain invoice amounts per invoice row. InvoiceNumber and LineNumber is the natural key.
  • Payments contains the actual payment transactions, most often a

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Drill down design
Hello, I am modeling traffic safety. For an accident, we can several vehicles and occupants. A vehicle can have several safety features. A person can have several injuries, toxicology results, safety equipment used, etc. I need to answer
Multiple Many-To-Many relationships
I've read quite a bit on dimensional modeling but this would be my first go in reality. Any help would be greatly appreicated. Here's what I've got... An existing subset of our DW would be: Fact_tx Dim_Customer Dim_Product One of our source
Advice on relationships between Type 2 SCDs ?
Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of
NxtBux - NxtBux.com - Good BUX with instant payments!
NxtBux BUX site with good stats and instant payments. Registered Company 'Linxgrand Ltd' verified by 'GlobalSign'. PS. To get payment first You must verify Your email and payment processors emails. PS2. To increase limit of direct referrals by 10
How do I connect fact tables for drill down
I need some advice on a project I am modeling for a Hospital. We have 2 business process' that I am creating individual fact tables. The big questions is - how do I connect related Fact Tables for drill down ? Details: Reimbursements - the
Forums from same category
See also
more_less
Informations

8 Replies For the topic :
"Drill-across relationships (Invoices -> Payments etc.)"

This topic has been viewed 2284 times.

Last message :
30/11/2009 at 13h36 by "Daniel Wikar"