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 reporting becomes significant, an aggregated fact table on InvoiceNumber?
Thanks again,
Gabriel