Why cube data is wrong when the same is not present in Fact table? RRS feed

  • Question

  • Hi

    I 've a fact table and in that I've data related to one particular customer resided in one territory upto April 2012 only.

    But when I am browsing the cube with filters as Year 2012, Quarter-3, Months - JUL,AUG,SEP and selecting dimensions as Territory State, Territory Name and customer.

    I should not see the customer who is not having data in fact table after April 2012 but still why am i seeing those customers in my cube?

    Could you please help in understanding this concept? and also what should I do to achieve my requirement?

    Thanks in advance.

    Monday, September 24, 2012 10:11 AM