J
jwb96
I'm trying to summarize similar data from two tables in one query but am
having issues when I bring in the second table.
I have an activity table, with storeId, activityDate, activityA and
activityB. I use two reference tables (dateRef, to roll up activityDate into
weeks and months; and storeRef, to display a storeName) to make the query
output summarized and readable. This works fine.
I then also want to bring in data from the transaction table, which has
transactionCount, transactionDate and storeId. I create relationships from
the existing reference tables to the transaction table, and while the
transactions calculate fine, all of the sudden the activity data from the
first table gets multiplied by three.
There are other columns in the activity and transaction tables that make the
rows unique - in other words, I can't simply join the tables together without
the reference tables. Currently, my relationships look like the reference
tables are acting as a bridge between the fact tables.
Any suggestions on what could be causing the troubles?
Thanks,
Jim
having issues when I bring in the second table.
I have an activity table, with storeId, activityDate, activityA and
activityB. I use two reference tables (dateRef, to roll up activityDate into
weeks and months; and storeRef, to display a storeName) to make the query
output summarized and readable. This works fine.
I then also want to bring in data from the transaction table, which has
transactionCount, transactionDate and storeId. I create relationships from
the existing reference tables to the transaction table, and while the
transactions calculate fine, all of the sudden the activity data from the
first table gets multiplied by three.
There are other columns in the activity and transaction tables that make the
rows unique - in other words, I can't simply join the tables together without
the reference tables. Currently, my relationships look like the reference
tables are acting as a bridge between the fact tables.
Any suggestions on what could be causing the troubles?
Thanks,
Jim