Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I've been working on this problem for close to a day and reading as much as possible about potential solutions but I've been unable to get to a solution that I like. I'm hoping someone can give me some good outsider perspective into what I might be able to do here. The problem is that I have dates in different tables but want to be able to compare the associated dollar amount in each table based on one date.
So to explain, I have a fact table with two tables branched off of it using different keys. The branch tables each have dates (which I've associated calendar tables based on the dates) and dollar amounts. The problem I come to is that I want to compare the dollar amounts in both tables but since the date tables are different I can't compare on a common date field. If I create a common date field in a singular table then it ends up generating a circular loop. I can give more info if this still doesn't make sense. Thanks in advance for your help!
Following data mode may be helpful for you.We are using link table and combing two tables with dates
hi,
did u find solution to it other than taking filters for both dates separately??
hi Kevin
you Might upload qvw file with an example of this case!!!
Following data mode may be helpful for you.We are using link table and combing two tables with dates