there is a cube that refreshes each night. in the morning there is an excel pivot table report that refreshes from the cube.it has worked fine for years, but now when i try to refresh it gives me the error "catastrophic failure". Recently i have had to archive the time dimensions of the cube, as the business only want the cube to contain 6 months of data, not 4 years. so i deleted all time dimension members older than 6 months, and deleted all fact data relating to the deleted time dimensions. this seems to be the cause of the issue, but i cant see why. can anyone shed light on this?
What type of query did the Excel pivot table execute? Did the data in the pivot table span more than 6 months of data? Did it have a member of the time dimension selected that is now missing? In general, if you will be purging data from a time dimension and cube, you'll likely want to implement some type of calculated member or named set that refers to the "current" or "most recent" set of time dimension members and have things like Excel pivot table reports refer to these things instead of referring directly to members of the dimension (since they might disappear)...
HTH,
Dave Fackler
No comments:
Post a Comment