Forum Discussion
Relationships slow down very much the performance
Hello, I thought that the performance is so weak due to the measures applied. But I found out that the attributes from the dimensions table slow down the performance very much. Here is my model...
You don't have to load the same dimension table three times. You can load it once, add the relationships ( all but the first will be inactive) and then use the USERELATIONSHIP function to activate it per measure. You should indeed also have the FactTable related to the customer table via customer.
--Nate