Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
Try this
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.