I have a cube with about 15 partitions and approximately 500m fact rows. It seems that whenever I select a dimensional attribute from any dimension it takes around 10-20 mins for the list to return.
My question is, is this using the fact table or the dimension table to pull these values? All the dimensions are built off very small tables. 500-1000 rows.
I didnt select any measures at this point btw, only the dimension attributeCraig
View Complete Post