Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationships

Hi    I'm really stuck on getting the relationships between tables to work. Here are my tables.   The Calendar (months) doesnt seem to be working when i use the "count" measure in DimPlayer table...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Actually, i spoke to soon. It solved some problems, players by table seems to work (Fact and DimTable).

But i'm still getting repeated numbers when pulling from revenue by table, using dimtable and calander month. 

 

Should they all be set to "both" like so? 

 

Thanks!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Okay so i made some changes. i now have: 

 

1) Many to Many, both ways on each dim table, fact and calander. this seems to work fine with any data in the Fact Table. So thanks for that, that was an interesting read in the link above. However,

 

2) I'm still unsure how to connect the Revenue table correctly, as this data doesnt come through (same number each month). I need this to work as if it were the FactTable. 

 

I'm at a loss and not sure what to do next, i feel like ive tried everything to no avail. 

 

Any help would be aweome.

 

Thanks.