question

jonathanknowles avatar image
jonathanknowles asked

SUM Measure returns same value for everything

![alt text][1] I am trying to create a SUM measure for one of my dimensions, and it always returns the same value no matter how you are browsing it in the cube... I can't find any help about this anywhere. I have a count measure working and the count changes for the dimesiion you are looking at but i cant figure this sum measure out can any one give me an example of how to set up a sum measure and the granularity for it [1]: /storage/temp/365-\untitled.png
ssascubes
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered
It seems you have wrong relationship between the Measure Group and the dimension(s). Check the Dimension Usage tab of the cube designer and verify, that proper relationships on proper granularity are defined between the dimension(s) and measure group.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.