Does anyone have any performance guidelines for this combination. I am experiencing slow refresh rates, both when I refresh data and change or add dimensions.
The Fact table - so far - has only 17500 rows, one of the dimension tables has over 200,000 rows (majority of these as yet unnused)
I have looked on the server where AS is installed and there does not seem to be much activity. On the PC where I am doing the refresh Excel gets up to 98% CPU and can use 160K of memory.
Anyone any clues?
Steve
Are you using AS2000 and Excel 2003. If so,you can have a problem with the dimension with 200 thousand rows. A lot of meta data and data for this dimension that is loaded down to the local cache(ie pivot table services). I think you need to do something with this large dimension.
If you have a large source key(meny positions) you can add invented levels like the first position in the key, the first two positions and so on. The important thing is to design your large dimension in a way that you do not load down all the members at once.
Regards
Thomas Ivarsson
sql
No comments:
Post a Comment