If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

data modelling in data warehouse..surrogate key

Started by Sep2013, 21 Jun 2017 08:37:51 AM

Previous topic - Next topic

Sep2013

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