This setting is conceptually the oppositeof Use Styles in the classic add-in.

In Smart View 11.1.2.1.102, there is a new option called Use Excel Formatting which also defaults to false. Based on my VBA experience, I can tell you that doing lots of format operations in an Excel worksheet can be quite slow. If you have used the classic Excel add-in, you may remember seeing the Use Styles option which formats the cells returned by Essbase based on member cell or data cell attributes. I next talked to one of my friends inside Oracle and found the source of the performance issue. I tried it in Dodeca and it returned a bit over 172,000 rows in 5 seconds, so it certainly isn't an issue with the Essbase server and large retrieves. After working on it for a bit, I decided to try the same thing in the classic Excel add-in and, guess what? The same sequence of operations is not even possible there as it easily shoots past the 65,535 rows supported by the classic add-in. When I zoomed in on Market, Smart View never returned but rather just kept trying to zoom in for a while. I used Sample Basic and zoomed in to all levels on Year, Measures, and Product.

Download smartview excel