Forum Discussion
UseRelationship
Hi Dellis81 ,
Sorry for the incorrect model I have send out, I tough I had saved the file but it did not happen.
Has I refered the changes are based on the accounts and transforming the relationships from many to many to one to many:
Has you can see in the image above I have create a new table Accounts (with distinct values) then I made the relationship between this table and the other to having a one to any (also the inactive relationship). There is also a change on the report headers table making it part of a one to many relationship.
All the opther relationships are the same.
Correct file attach.
Thank you Sir!
The screenshot provided appears to be the expected result. GREAT!! However, I am unclear as to your changes in relationships and accounts. The attached file, I believe was the original file I submitted.
I apologize, I tried to keep things simple in my example. I sensed providing the full magnitude would be overwhelming. The struggle in my bigger model - was subtotals - that forced me to go with bi-directional relationships. Looking forward to understanding your changes in the model structure!!
Thank you again!
Hi Dellis81 ,
Sorry for the incorrect model I have send out, I tough I had saved the file but it did not happen.
Has I refered the changes are based on the accounts and transforming the relationships from many to many to one to many:
Has you can see in the image above I have create a new table Accounts (with distinct values) then I made the relationship between this table and the other to having a one to any (also the inactive relationship). There is also a change on the report headers table making it part of a one to many relationship.
All the opther relationships are the same.
Correct file attach.
THANK YOU!!! Thank you again 🙂 Your revised relationship and new measures work great. AWESOME. I'm still working thru incorporating into my larger model - so far - exactly what I am needing.
I am finding some of my drill thru's and related interactive reports don't quite work - but suspect I need to go back and rethink how I have those measures setup.
But wanted to give you a big thank you before the day slipped away on me!!