Unable to select certain store codes from Store filter. What could be the reason?
This might be due to the duplicate store codes present in DIM_STORE. For e.g., Store code = 13. It contains two store codes (13) as active (i.e., column->active=1). Among the two, one is an old store(column->latest=0) and the other is the latest store (i.e., column->latest=1). To solve this issue, remove one active store from the dimension table. Make sure that the dimension table has only one active and one latest store but not more than one active store.