Steve Rowe wrote:I've heard through the grapevine that it takes along time to do run a Process Worksheet type function in 9.4 vs 9.1 which is (I think) very similar type fucntionality, don't know any details or if the source cube is sub-optimal.
Cheers
One of our clients upgraded to 9.4 from 8.4 because of their move to Office 2007. They carried out after fairly extensive testing and their results were:
1) Most users complained about general "sogginess" of the user interface in 9.4 compared to 8.4.
2) They had 2 or 3 main cubes accessd by end-users. Under 8.4 the cube views and Excel slices of these cubes opened virtually instantaneously after the first viewing. In 9.4 the same views were taking 15-16 seconds to open after repeated viewing of the same data.
3) As long-time TM1 users they had fairly extensive process workbooks for some very specific end-user functions. These were taking 20 (twenty) times longer to load in 9.4 than 8.4 which made them effectively unusable.
The response from Cognos support was effectively:
- Issues 1\2: 9.4 "is doing much more so you expect it to be slower"
- Issue 3:"they are taking 20 times longer but process workbooks are old technology so dont expect them to work well" The 9.1 release notes did mention slower perfomance of process workbooks but 9.4 is even slower than 9.1 and I do not think the 9.4 release notes mention this problem at all.
In this case the client HAD to move to ensure compliance with Office 2007; they ended up reluctantly accepting slower performance for issues 1\2 and then spending several days of our time writing TI to replace the process workbooks. From their point of view this outcome is not ideal and it reflects poorly on TM1.
In respect of process workbooks I do not think it acceptable to degrade perfomance of existing features whch are still supported. Can I encourage other TM1 user who are experiencing similar problems to ensure they are reported to Cognos support and escalated if necessary?
