renaud.durand (3/29/2012)
Yes I confirm, performance are very bad compared to Excel.Cognos Analysis Studio on SSAS works very bad as soon as you have more than 2 dimensions in rows and more than 300 rows...
A query can last hours in Cognos while running in 5 mn in Excel...
300 rows for an analysis? Isn't that a bit much? The human mind can only process around 10-20 lines in a table efficiently.
The advantage of Analysis Studio over Excel is that it is somewhat easier to do calculations. In Excel, you are a bit stuck on the PivotTable layout, unless you convert everything to formulas. But then you can't pivot anymore.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP