I am pulling data from 2 data providers and the common Keys between the two are Policy Number and Effective Date. I need to get the Policy Status from the 2nd provider. but the issue is that in same Policy Number can have different Effective dates and different Policy Statuses. When I create a detail object and link it to the Policy Number (Merged dimension), I get a Multi-value error. If I were to choose the Policy Status based on PolicyNumber+EffectiveDate combination, I would have got just one record.
Need your help in this matter..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.