So I use Excel 2010 connect to a cube I have built. Then I change some values in the cube via my ETL and re-process the cube. Then I verify that record is NOT there in the fact table - check!
However, when I refresh the worksheet where the pivot table is pulling data from the cube, but that old record wont go away!
Suggestions?
[update]
Well, I feel dumb now. Just realized my cube data source on the dev server, was in fact still configured with my local workstation name. Gee, that might be why. Once I updated that, processed the cube all was well.
- Edited by shiftbit 11 hours 10 minutes ago sdfgsdfg