Hi to all,
I've been searching and found a lot of posts about improving performance, while the doc that I've found is much about SPC version 5...and I'm trying to apply whatever I'm finding possibly correlated to our environment.
We're having an issue with our input schedule: it's a bit complex, with 4 sheets, a sheet with 3 evdres while other sheets with only one evdre...
What we find "strange" is this: on the opening of the schedule, the user is presented with a list of "structures" that he can see. When he chooses one of the structures, a simple vbscript
1-Set the value in the right cell for the next evdre
2-Call MNU_eTOOLS_EXPANDANDREFRESH
3-Switch to this other sheet, where the user can see the "payments" for this structure...
What we've found strange is this:
- When we disable all the evdres, still the expandandrefresh is called and takes a lot of seconds...
- It's clear the difference in performance between the Administrator (who can see all the structures) and a simple user (can see only one structure): the input schedule is faster with the simple user. This thing has been noted by everybody, also the users...what can be done in this case to improve performance? Is an MDX problem, or so what?
- During the expandandrefresh, the CPU goes to 100% for few seconds twice
Consider that we have got 4 dimensions, and the entity dimension (payments) has got 7617 members and 2 hierachies...the other dimensions are human readble 😊, with one to 4 members...
Thanks
Daniele
Edited by: Daniele Tiles on May 7, 2010 6:15 PM