performance – XLCubed Blog ../../../ XLCubed Blog Fri, 04 Oct 2019 12:02:14 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png performance – XLCubed Blog ../../../ 32 32 DAX Performance tips– lessons from the field ../../../2016/06/dax-performance-tips-lessons-from-the-field/ ../../../2016/06/dax-performance-tips-lessons-from-the-field/#respond Fri, 10 Jun 2016 15:56:58 +0000 http://blog.xlcubed.com/?p=4239 XLCubed has supported a drag/drop interface for creating reports against Tabular Analysis Services since the first release of the new engine. It lets users easily create reports which run DAX queries on the cube, and we’ve often seen very good performance at customers when MDX against Tabular was a cause of long running reports. So […]

The post DAX Performance tips– lessons from the field appeared first on XLCubed Blog.

]]> ../../../2016/06/dax-performance-tips-lessons-from-the-field/feed/ 0 Streamlining writeback with XL3DoWriteback ../../../2012/01/streamlining-writeback-with-xl3dowriteback/ ../../../2012/01/streamlining-writeback-with-xl3dowriteback/#comments Tue, 31 Jan 2012 09:42:56 +0000 http://blog.xlcubed.com/?p=3212 We were recently asked by one of our customers to help them improve their forecasting process. They had originally been using a solution developed using XLCubed Excel Edition v6.0 and our XL3LookupRW formula. The system had been working, but because of a combination of the intricacy of the data model and the slowness of the […]

The post Streamlining writeback with XL3DoWriteback appeared first on XLCubed Blog.

]]> ../../../2012/01/streamlining-writeback-with-xl3dowriteback/feed/ 2 Warning: Excel can get Volatile ../../../2011/08/warning-excel-can-get-volatile/ ../../../2011/08/warning-excel-can-get-volatile/#respond Mon, 29 Aug 2011 09:00:16 +0000 http://blog.xlcubed.com/?p=3022 There is a revised version of this post here. Excel is a great tool for dashboard/report delivery and design (it’s why we created our addin in the first place), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you’ve ever used any of these formulae, you may have […]

The post Warning: Excel can get Volatile appeared first on XLCubed Blog.

]]> ../../../2011/08/warning-excel-can-get-volatile/feed/ 0 Common Analysis Services Performance Issues ../../../2010/02/common-analysis-services-performance-issues/ ../../../2010/02/common-analysis-services-performance-issues/#respond Mon, 15 Feb 2010 06:14:41 +0000 http://blog.xlcubed.com/?p=712 A quick blog post from the Services team here at XLCubed on some performance problems with SSAS that we’ve seen again recently. With the processing power and memory available it’s pretty easy to build a fast cube – both for query performance and processing time. It is also easy to be lax in cube design, ignore the […]

The post Common Analysis Services Performance Issues appeared first on XLCubed Blog.

]]> ../../../2010/02/common-analysis-services-performance-issues/feed/ 0