Thanks for the input.

So you went with a regular dimension for the invoice, rather than a degenerate dimension?

Now that I have these other attributes to add, I think that would...

Thanks for the input.

I do have some data that are only at the Order level (Tax Amount, Payments), but they may not be essential to reporting.

Primarily, I thought...

Semi-Additive means that it makes sense to sum it by some dimensions, but not all.

In your case, summing Products over multiple dates makes no sense, but summing by Store for...

If there are invoice level reports being built, would it be acceptable to create a single composite key of InvoiceNumber + StoreNumber?

And if the requests for Invoice level...

Thanks for the quick reply.

There are a few elements at the invoice number level that are repeating in the FactRetailSales table (InvoiceNumber, WorkOrderNumber, InvoiceDate and WorkOrderDate. I'm fine with...

I'm not 100% sure what...