nsoerensen
IS-IT--Management
Hi..
I'm having a problem with Excel 2002, when I set up a Pivot-table based on a MS cube.
When I started the update of data from the cube was very quick (I only have 1600 records), but many dimensions. All based only on my fact-table.
At a time when I changed a dimension the update of data got very slowly, while Excel uses nearly 100% CPU usage.
Today it takes a couple of hours to update my data in excel.
Why?????
I think my cube has been damaged in som way, or there is something happened to the drivers between Excel and AS (OLAP Provider).
I have seen this before, where the update suddenly get slow, but I can't seem to find where I have to look for the problem.
I'm having a problem with Excel 2002, when I set up a Pivot-table based on a MS cube.
When I started the update of data from the cube was very quick (I only have 1600 records), but many dimensions. All based only on my fact-table.
At a time when I changed a dimension the update of data got very slowly, while Excel uses nearly 100% CPU usage.
Today it takes a couple of hours to update my data in excel.
Why?????
I think my cube has been damaged in som way, or there is something happened to the drivers between Excel and AS (OLAP Provider).
I have seen this before, where the update suddenly get slow, but I can't seem to find where I have to look for the problem.