Forum Discussion

osinquinvdm's avatar
osinquinvdm
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Issue with many-to-many relationship

When the users are looking at event details they would like a simple selector for filtering on today/this week/this month/this year/all.   My idea is to create a column called "temporality" that as...
Need Help
  • SqlJason's avatar
    SqlJason
    9 years ago

    For this to work, you will have to use a measure in your grid. Unless you have a measure, you will keep getting this error message. 

    Try creating a simple measure like 

    Test = countrows(EventTable)

     

    Then add Temporalitie, Event and the Test measure to a grid, and you should get the result. 

  • fiveone's avatar
    fiveone
    9 years ago

    Hey, you are right! That tricks work. It's like if we were forcing one of the table to be the fact table and then tadam it knows how to use the lookup tables to get the aditional details.

     

    Thanks for the trick SqlJason, you rock!

fiveone's avatar
fiveone
Icon for Helper II rankHelper II
9 years ago

when I try to create a grid with both events and temporality it gives the relationships error.

Which is strange, you are right, since it seems able to filter out events based upon temporality, so the relationship seems to be there somehow,

SqlJason's avatar
SqlJason
Icon for Memorable Member rankMemorable Member
9 years ago

For this to work, you will have to use a measure in your grid. Unless you have a measure, you will keep getting this error message. 

Try creating a simple measure like 

Test = countrows(EventTable)

 

Then add Temporalitie, Event and the Test measure to a grid, and you should get the result. 

  • fiveone's avatar
    fiveone
    Icon for Helper II rankHelper II
    9 years ago

    Hey, you are right! That tricks work. It's like if we were forcing one of the table to be the fact table and then tadam it knows how to use the lookup tables to get the aditional details.

     

    Thanks for the trick SqlJason, you rock!