Help in Designing Model

[#1]

hi,

I have a data model like below sample .i need  to create a association  between  fact 1 and fact 2

[CALL NAME] should link with EID, [A Name] should link with columns of  fact 2 tables .

And data should not  be duplicated based on Account id

Kindly suggest me the way .Please find the sample attachment

Thanks in advance.

[MK9885]

Hi,

Please find the attached qvw and let me know if this is what you looking for? We can further optimize it but as you wanted to link particular fields.

Thanks.

[#3]

Hi Arvind,

I want to link fact 1 and fact 2 tables.And we are using link table in our model.

suppose if we select call name it shoud link with Eid. we need a count of Eid for particular call name.

and  if we select call name  it  should link to account id only from fact 2 table .we need a account id count for particular call name from fact 2 table

Thanks

[Anonymous]

Try this

[MK9885]

We can make the fields link with each other but the question is what should be the count for EID and Account ID after linking (it will be 1 in most case)?

Please find the attachment.