Analysis Services – XLCubed Blog ../../../ XLCubed Blog Tue, 09 Feb 2021 09:57:33 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Analysis Services – XLCubed Blog ../../../ 32 32 Faster Excel Queries For Power BI & Azure Analysis Services ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/ ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/#respond Tue, 09 Feb 2021 09:57:30 +0000 https://blog.xlcubed.com/?p=6286 If you have slow queries when reporting table format data in Excel from PowerBI.com, Azure Analysis Services or Tabular SSAS, this could be just the performance boost you need. Excel Pivot Tables query Power BI and Analysis Services using MDX, and sometimes the MDX they generate is not ideal. XLCubed Grids also query using MDX, […]

The post Faster Excel Queries For Power BI & Azure Analysis Services appeared first on XLCubed Blog.

]]> ../../../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/feed/ 0 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 XLCubed V7 & SQL Server 2012 ../../../2012/03/xlcubed-v7-sql-server-2012/ ../../../2012/03/xlcubed-v7-sql-server-2012/#respond Mon, 19 Mar 2012 12:22:32 +0000 http://blog.xlcubed.com/?p=3270 SQL server 2012 has recently been released to manufacturing, and at XLCubed we’re well placed to take advantage of everything that is new in 2012. SQL 2012 delivers Business Intelligence under the ‘BISM’ umbrella (Business Intelligence Semantic Model). BISM comes in different flavours though: BISM Multi-dimensional (Latest version of Analysis Services as we know it) […]

The post XLCubed V7 & SQL Server 2012 appeared first on XLCubed Blog.

]]> ../../../2012/03/xlcubed-v7-sql-server-2012/feed/ 0 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 PowerPivot, SQL R2, Sharepoint 2010, Office 2010. ../../../2010/03/powerpivot-sql-r2-sharepoint-2010-office-2010/ ../../../2010/03/powerpivot-sql-r2-sharepoint-2010-office-2010/#comments Fri, 26 Mar 2010 04:11:41 +0000 http://blog.xlcubed.com/?p=716 So we’ve been using PowerPivot for a while now, and Office 2010 has been part of our lives for some time. I’ll use this blog to answer some of the questions that keep cropping up in conversation with our customers: 1. Does XLCubed work with Excel (Office 14) 2010? a. Yes, we’ve been using it since […]

The post PowerPivot, SQL R2, Sharepoint 2010, Office 2010. appeared first on XLCubed Blog.

]]> ../../../2010/03/powerpivot-sql-r2-sharepoint-2010-office-2010/feed/ 2 Cube Design – meeting the business needs ../../../2010/02/cube-design-meeting-the-business-needs/ ../../../2010/02/cube-design-meeting-the-business-needs/#comments Mon, 15 Feb 2010 10:42:34 +0000 http://blog.xlcubed.com/?p=713   Following on from our previous blog post on a couple of the common cube performance issues we’ve seen this last month, I thought I’d mention some of the non-technical issues we see quite often. In one case, once we’d made a few teaks and sorted out the cube performance issues we had to ask […]

The post Cube Design – meeting the business needs appeared first on XLCubed Blog.

]]> ../../../2010/02/cube-design-meeting-the-business-needs/feed/ 1 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