XLCubed – 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 XLCubed – 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 Using Grid Styles in XLCubed ../../../2019/08/using-grid-styles-in-xlcubed/ ../../../2019/08/using-grid-styles-in-xlcubed/#comments Wed, 14 Aug 2019 12:30:15 +0000 https://blog.xlcubed.com/?p=4986 This week’s blog is a quick tip on Grid formatting options. Did you know that XLCubed comes with ten pre-formatted grid styles which you can easily switch between? These are available from the Workbook Format button on the XLCubed ribbon (the option remains greyed out until an XLCubed grid is added). Grid styles allow for […]

The post Using Grid Styles in XLCubed appeared first on XLCubed Blog.

]]> ../../../2019/08/using-grid-styles-in-xlcubed/feed/ 4 Member Searching ../../../2019/03/member-searching/ ../../../2019/03/member-searching/#respond Thu, 21 Mar 2019 09:37:36 +0000 https://blog.xlcubed.com/?p=4934 Did you know how easy it is to search for members within XLCubed? Here’s a simple grid – let’s search for members within the Geography hierarchy. First of all, let’s open the Geography member selector by just double-clicking the Geography header. XLCubed offers a number of options when searching. Firstly, you can simply enter a […]

The post Member Searching appeared first on XLCubed Blog.

]]> ../../../2019/03/member-searching/feed/ 0 Grid Formatting 101 ../../../2019/02/grid-formatting-101/ ../../../2019/02/grid-formatting-101/#respond Wed, 13 Feb 2019 11:04:18 +0000 https://blog.xlcubed.com/?p=5001 Most formatting in XLCubed can be handled though the formatting options available on the right-click menu, and today’s blog will cover some of the common use cases. You will be presented with different options depending on whether you click a member on columns or rows: or a cell within the grid: Selecting any of these […]

The post Grid Formatting 101 appeared first on XLCubed Blog.

]]> ../../../2019/02/grid-formatting-101/feed/ 0 Propagate across Sheets ../../../2019/01/propagate-across-sheets/ ../../../2019/01/propagate-across-sheets/#respond Wed, 16 Jan 2019 13:32:12 +0000 https://blog.xlcubed.com/?p=4896 Propagate across Sheets Today’s blog will run through Propagate across Sheets – it’s an XLCubed feature that’s been around for some time but is definitely one of our hidden gems! Propagate across Sheets is some great functionality that allows users to quickly replicate a report onto additional sheets within the same workbook or a new […]

The post Propagate across Sheets appeared first on XLCubed Blog.

]]> ../../../2019/01/propagate-across-sheets/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 Drive Excel Chart Min/Max from Range ../../../2011/10/drive-excel-chart-minmax-from-range/ ../../../2011/10/drive-excel-chart-minmax-from-range/#respond Tue, 18 Oct 2011 09:39:10 +0000 http://blog.xlcubed.com/?p=3132 How do I drive the min and max values of an axis from an Excel Range? This is one of the most commonly asked questions about Excel and with each new release it always amazes me that this feature hasn’t been added to the base product. It’s a very common scenario to come across, you are building […]

The post Drive Excel Chart Min/Max from Range appeared first on XLCubed Blog.

]]> ../../../2011/10/drive-excel-chart-minmax-from-range/feed/ 0 2011 Dashboard Competition ../../../2011/09/2011-dashboard-competition/ ../../../2011/09/2011-dashboard-competition/#respond Tue, 27 Sep 2011 10:06:15 +0000 http://blog.xlcubed.com/?p=3125 A slight departure from the normal blogging to let everyone know about the latest developments in XLCubed and to talk about a new dashboard competition with the chance to win an iPad 2! Dashboard Design Competition XLCubed are sponsoring Dashboard Insight’s first dashboard design contest. The competition is based on a provided data set, and […]

The post 2011 Dashboard Competition appeared first on XLCubed Blog.

]]> ../../../2011/09/2011-dashboard-competition/feed/ 0 Scheduling Reports with XLCubed ../../../2011/09/scheduling-reports-with-xlcubed/ ../../../2011/09/scheduling-reports-with-xlcubed/#respond Mon, 12 Sep 2011 10:09:11 +0000 http://blog.xlcubed.com/?p=3109 With version 6.2, XLCubed introduces a new feature that we’ve had enquiries about for a while now: the ability to send scheduled reports to email recipients. In this post we’ll go over the basics of how it works and why you might want it. The Scenario As report designers and publishers, it’s our job to […]

The post Scheduling Reports with XLCubed appeared first on XLCubed Blog.

]]> ../../../2011/09/scheduling-reports-with-xlcubed/feed/ 0 Heatmap Tables with Excel – Revisited ../../../2011/07/heatmap-tables-with-excel-revisited/ ../../../2011/07/heatmap-tables-with-excel-revisited/#comments Mon, 11 Jul 2011 10:42:55 +0000 http://blog.xlcubed.com/?p=2622 We’ve revisited one of our more popular guides Heatmap Tables with Excel as they can be a very effective way of presenting data on a dashboard, and have now updated it for Excel 2010… This Heatmap Table is designed to show you the revenues and the discounts of a company over the course of one year […]

The post Heatmap Tables with Excel – Revisited appeared first on XLCubed Blog.

]]> ../../../2011/07/heatmap-tables-with-excel-revisited/feed/ 13