Data is not reflecting in SSAS Cube

Question

Hi All,

I have SSAS cube which deployed to 2 different instances with exactly same structure.
For testing purpose, data is same in one of the Fact table of both instance. but that data is reflecting correctly (by summing it up) in one instance cube for measure against dimensions. For another instance, it is not reflecting correctly as it is not summing it up and only showing one value(without summation).

As the cube structure is identical, and source table have same data, I can not think anything else on it. also check properly plotting dimensions against measure.
Can anyone hint where could be problem ?

Many Thanks!!

Answer 1

To get the same results the data would have to be the same in the fact table and all the related dimensions. So at a guess maybe one or more of the related dimensions have different data.

Answer 2

Also check carefully for the relationships. The cubes could not be identical and have different results at the same time, there has to be some differences that we haven't uncover.

Answer 3

Many thanks for your response .. I am still figuring out
will recheck..

Answer 4

Hi All,
I figured out the reason- it was actually data issue.
As I had mentioned this was testing data, user had wrongly entered the data in problematic instance. Attribute in one of dimension had wrongly assigned to different key.
Thanks for All help.
Regards,