i am working with claims data
I have two models one for counting no. of claims and other for relevant payments..both have thier own star schemas conformed using claimant dimension
the issue is that claimang dimension is snapshot over period but payments are transactions..thus if i want to see total paid for claimamt it will not be possible as it will lnly look up the payments made for that particular ss of claimamt.
Please guide me how cab i ensure that independent of which slice of ss i select i am able to see all payment transactions.
see attached example