OLAP – XLCubed Blog ../../../ XLCubed Blog Thu, 10 Jan 2019 08:39:04 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png OLAP – XLCubed Blog ../../../ 32 32 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 Ranking, Sorting and Filtering ../../../2011/08/ranking-sorting-and-filtering/ ../../../2011/08/ranking-sorting-and-filtering/#comments Tue, 23 Aug 2011 14:24:09 +0000 http://blog.xlcubed.com/?p=2627 Once we have returned cube members into a grid report we often need to exclude or change the order of the result set to provide more meaningful information. MDX (Multidimensional Expressions) language includes some very useful operators to provide filtering (FILTER), sorting (ORDER) and ranking (TOPCOUNT/BOTTOMCOUNT) of dimension members. These can be quite overwhelming even […]

The post Ranking, Sorting and Filtering appeared first on XLCubed Blog.

]]> ../../../2011/08/ranking-sorting-and-filtering/feed/ 1 Sql Server “Denali” CTP3 – first impressions… ../../../2011/07/sql-server-denali-ctp3-first-impressions/ ../../../2011/07/sql-server-denali-ctp3-first-impressions/#comments Tue, 19 Jul 2011 12:07:06 +0000 http://blog.xlcubed.com/?p=2829 Microsoft recently released their third CTP of Denali the upcoming SQL Server release (SQL Server 2011), so here are some initial thoughts now it’s more widely available.: The first thing to look at is the new Tabular mode for Analysis Services (as opposed to the traditional multi-dimensional mode, which is still available). This is the […]

The post Sql Server “Denali” CTP3 – first impressions… appeared first on XLCubed Blog.

]]> ../../../2011/07/sql-server-denali-ctp3-first-impressions/feed/ 1 Parent-Child Dimensions in Analysis Services – Performance Walkthrough ../../../2011/06/parent-child-dimensions/ ../../../2011/06/parent-child-dimensions/#comments Thu, 30 Jun 2011 09:21:29 +0000 http://blog.xlcubed.com/?p=2480 Parent-child hierarchies are a good fit for many data structures such as accounts or employees, and while they can speed development in some cases, they can also cause performance problems in large cubes. We often see customers with these type of performance issues, and thought it worth sharing a simple technique for altering the dimension […]

The post Parent-Child Dimensions in Analysis Services – Performance Walkthrough appeared first on XLCubed Blog.

]]> ../../../2011/06/parent-child-dimensions/feed/ 13 So, what’s an OLAP Cube, anyway? ../../../2008/11/so-whats-an-olap-cube-anyway/ ../../../2008/11/so-whats-an-olap-cube-anyway/#comments Tue, 11 Nov 2008 01:07:11 +0000 http://blog.xlcubed.com/?p=168 As "An Excel User in a Cubed Kingdom" I’m starting my exploration of this new found land with a simple question: what is an OLAP cube? In plain English, please… I like this simple, non-technical definition: a cube is a set of predefined answers. It’s up to you to select the right questions. OK, let’s […]

The post So, what’s an OLAP Cube, anyway? appeared first on XLCubed Blog.

]]> ../../../2008/11/so-whats-an-olap-cube-anyway/feed/ 7