OLAP cubes – XLCubed Blog ../../../ XLCubed Blog Thu, 10 Jan 2019 09:17:03 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png OLAP cubes – 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 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 Data sources for Excel dashboards: avoid spreadsheet hell ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/#comments Sun, 25 May 2008 23:00:20 +0000 http://blog.xlcubed.com/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ This is the first of two twin posts where we’ll discuss the alpha and omega of Excel dashboards: data access and dashboard publication. These are two weak areas in Excel, and they should be approached carefully when planning for a new dashboard. Let’s start by reviewing the available data access options. Copy / Pasting data […]

The post Data sources for Excel dashboards: avoid spreadsheet hell appeared first on XLCubed Blog.

]]> ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/feed/ 3