Calculations – XLCubed Blog ../../../ XLCubed Blog Thu, 10 Jan 2019 08:18:35 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Calculations – 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 Mind the gap! ../../../2012/09/mind-the-gap/ ../../../2012/09/mind-the-gap/#comments Tue, 04 Sep 2012 16:12:33 +0000 http://blog.xlcubed.com/?p=3645 Today’s blog is going to show you how to use XLCubed’s custom calculation functionality to create column breaks in a grid.  Imagine that you have a report that shows you Reseller Sales across Product Model Categories over a 12-month time period.       There’s nothing wrong with this report but don’t you think it […]

The post Mind the gap! appeared first on XLCubed Blog.

]]> ../../../2012/09/mind-the-gap/feed/ 3 Solve order shenanigans ../../../2011/09/solve-order-shenanigans/ ../../../2011/09/solve-order-shenanigans/#respond Mon, 05 Sep 2011 15:22:15 +0000 http://blog.xlcubed.com/?p=2632 Today I’m going to blog about a problem we recently solved in a client’s cube, an error in the Mdx script that’s very easy to make if you aren’t careful. We’ll run a simple example in AdventureWorks (what else?) to demonstrate the issue. The client had already added a calculation to their cube to show […]

The post Solve order shenanigans appeared first on XLCubed Blog.

]]> ../../../2011/09/solve-order-shenanigans/feed/ 0