I have a cube that all the tables has one row per ID and have measure in all of them except for the calendar dimension.
When I view the measures in excel from Table 1 with attributes from table 2, I have no issues, but when I view the measures from Table 2 with attributes from Table 1 it returns the same number for each value of the attributes:
BillingCycle HCD Accounts For Review
7 4067
14 4067
30 4067
How can I overcome this issue? Does this have anything to do with the direction of the relationship between the tables?