SantiagoC. wrote:With 4 sparse dimensions in row orientation, the Essbase engine has to do a bunch of work to get the data.. I would look at the application log to see how long the Essbase retrieve operation actually is, then compare that to the time to render in the spreadsheet. This will give you a baseline of how much time is Smart View vs how much time is Essbase.
i have 11 dimension in the model, in the sheet i have in row 4 sparse dimension with 1 dinamic calc of one of these dimensions, in columns i have 1 dynamic calc that sumarize some childs of the dimension, and the rest of the dimensions (7) like period, year, version, etc.
the retrieve is taking 2 minutes, it is posible to make it run faster? or this time is short for that action?