December 15, 2006 at 5:12 am
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?
December 18, 2006 at 8:00 am
This was removed by the editor as SPAM
December 18, 2006 at 8:37 am
It would only take a couple of minutes to try connecting the cube through a new pivot table on a new speadsheet. Have you tried this yet?
I have seen the dimensions get in a mess in a pivot table and not reflect what is in the cube. They seem to have a memory which can only be cleared by deleteing the dimension from the report and re-adding to the report.
Regards
Daniel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply