Ryan1 (6/17/2014)

---

I am building a cube in 2008r2 analysis services (BIDS) which requires me to link two views. The first view contains only measures (these measures are calculated by SUM) and the second view contains only dimensions. It seems as if I hook up the dimensions properly because I can view the data by dimension in the browser and it matches spot on. However, when I view the measures in browser they seem to give me a total no matter what I do. If I give several columns worth of dimensions on top and a single measure on the side, it will give me the same total all the way across. I want it to give me the SUM of the measure, but also filtered by dimension.

-I set the 'relationship' between the two views under Data Source Views in BIDS to match both keys

-There are hardly any keys set in the actual SQL database. For example the dimension tables aren't hard linked.

-The view with the measures has multiple copies of the key/record (for different parts of the year).

I understand that I am probably not providing enough information, however, if someone could point me in the right direction as to what I should be providing that would be great. Thank you very much