• 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