If I understand your question, I think the problem is that the only intersection between your total Market Sales and your product dimension is at the top of the dimension....

I am not that familiar with MS Cluster, but I would guess the process would be to set up an OLAP users group first. Once you have set up the...

A common problem loading fact tables into an OLAP Services cube is failure to rebuild dimensions prior to the data load. There are occassions where the OLAP dimensions do not...

Have you considered setting up a dimension table like "Customer Tier" that has a row for each bracket you want (e.g. 0 - $10k,$11K-$20K, etc.). You could then join your...