Forum Discussion
Aggregation after simple many to one join, not working ?
The Tables look like pictures attached and the relationship is set up as attached as well. Its very simple not much data, nothing to it but I cant work out why its not working
As another piece of information when I merge the queries, (instead of just creating a relationship) it works perfectly. I would have thought these two things would work the same way.
Lastly when doing the relationship if I put a variable from the facttable on the x axis (and one from dimension table on the y axis) of the bar graph it always gives the wrong answer, but if I put a variable from the dimensiontable on the x axis (and a variable from the fact table on y axis) then it works just fine. I thought that the relationship would work the same in both directions???
jono,
When you only drag the CardStatus ID of dimension_table and CardNumber of facttable to create the graph, the table is based on the unique combination of CardStatus ID+ CardNumber which doesn’t contain duplicated CardStatus ID for each CardNumber, thus you don’t get correct count number in the graph.
In your scenario, please create the graph by using CardStatus ID and CardNumber of facttable.
Regards,
Lydia