I am trying to join a dimtime table by a refernced join to an orderlines table which is the fact.
(the referenced join was defined in the relationship matrix of the cube ).
The referenced table is the ordersheader which had no measures in it but only used a linking table between those two other.
The join from the dimtime to the ordersheader is done by date and from ordersheader to orderlines by orderid
The problem is that in the cube browser measures are shown as they were multiplied across all dates (like the join was done in a wrong way )
I have created an sql query and the logic is working just fine when quering directly from the DB
What am I doing wrong
View Complete Post