This could be a silly issue. I have a location dimension attached to my sales cube. When I browse the data, i see revenue against only 4 locations in my cube. However the dimension has more than 20 locations and the underlying fact and the dimension view has data for all those. However its not coming up in the cube.
This has run well for the past month and had failed only couple of days ago. I have reprocessed the cube but it doesn't seem to work.
Appreciate if anyone can guide me on this.