Slicers – XLCubed Blog ../../../ XLCubed Blog Mon, 18 Nov 2019 10:37:04 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Slicers – XLCubed Blog ../../../ 32 32 Customer Segmentation By Revenue Contribution ../../../2019/10/customer-segmentation-by-revenue-contribution/ ../../../2019/10/customer-segmentation-by-revenue-contribution/#respond Thu, 03 Oct 2019 09:45:34 +0000 https://blog.xlcubed.com/?p=5780 We recently had a customer asking us for some assistance with a business challenge. He had been asked to provide a report analysing their customer base by % contribution to company revenue. But that wasn’t all! He also had to produce an additional report that tracked the customers ‘lost’ by the company Year on Year […]

The post Customer Segmentation By Revenue Contribution appeared first on XLCubed Blog.

]]> ../../../2019/10/customer-segmentation-by-revenue-contribution/feed/ 0 Workbook Aspects – Same Report, Different View ../../../2019/01/workbook-aspects-same-report-different-view/ ../../../2019/01/workbook-aspects-same-report-different-view/#respond Tue, 08 Jan 2019 09:24:20 +0000 https://blog.xlcubed.com/?p=4653 A common scenario in business reporting is for different users to want reports to open with ‘their’ view on the data. So for a particular Store or business unit. Many back-ends already support setting Default Members for different users and groups, for example Analysis Services allows this, but as XLCubed can connect to an increasing […]

The post Workbook Aspects – Same Report, Different View appeared first on XLCubed Blog.

]]> ../../../2019/01/workbook-aspects-same-report-different-view/feed/ 0 How’d you like that….displayed! ../../../2018/10/howd-you-like-that-displayed/ ../../../2018/10/howd-you-like-that-displayed/#comments Wed, 17 Oct 2018 14:50:59 +0000 https://blog.xlcubed.com/?p=4506 Today’s blog will show you a really quick and easy way to format your grid to show different display units. This approach is ideal for dynamic Grids where the size of the values can vary considerably based on the selected filters, or where the user has drilled down to lower levels in the data. For […]

The post How’d you like that….displayed! appeared first on XLCubed Blog.

]]> ../../../2018/10/howd-you-like-that-displayed/feed/ 2 User control of dashboard layouts ../../../2017/08/user-control-of-dashboard-layouts/ ../../../2017/08/user-control-of-dashboard-layouts/#respond Fri, 18 Aug 2017 13:00:43 +0000 https://blog.xlcubed.com/?p=4393 Dashboard sheets were introduced with V9, primarily as a way to deliver mobile-friendly reporting with a responsive UI to auto-fit any screen size. Specific Targets which define the layout can be defined to optimise the layout for different devices and are automatically applied depending on the device type. Another use-case which is less obvious but […]

The post User control of dashboard layouts appeared first on XLCubed Blog.

]]> ../../../2017/08/user-control-of-dashboard-layouts/feed/ 0 Click & Submit! ../../../2015/04/click-submit/ ../../../2015/04/click-submit/#comments Wed, 29 Apr 2015 09:50:28 +0000 http://blog.xlcubed.com/?p=4191 We’ve had a few queries recently where customers want to provide web reports with a number of slicer choices, and to have the report refresh just once when all selections are made, rather than the default refresh after each selection. It can be achieved in a couple of ways in XLCubed, read on for more… […]

The post Click & Submit! appeared first on XLCubed Blog.

]]> ../../../2015/04/click-submit/feed/ 4 Workbook slicers – all for one and one for all! ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/ ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/#comments Tue, 28 Oct 2014 16:47:48 +0000 http://blog.xlcubed.com/?p=4144 So this is our second blog on the new features of XLCubed v8 – today we’re going to run through workbook slicers. Workbook slicers allow the user to create the slicers at the workbook level so that they can be displayed for any/all sheets. There’s a slicer pane which can be arranged horizontally or vertically […]

The post Workbook slicers – all for one and one for all! appeared first on XLCubed Blog.

]]> ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/feed/ 4 Asymmetric grid reporting ../../../2012/08/asymmetric-grid-reporting/ ../../../2012/08/asymmetric-grid-reporting/#respond Mon, 06 Aug 2012 15:50:14 +0000 http://blog.xlcubed.com/?p=3549 A common scenario for Analysis Services reporting  is to want to present different measures for different members,  particularly in budgeting and planning. So I want a grid that shows actuals for previous month, budget for this month and forecasts for future months. This could be achieved in the cube, by using a “Phasing” measure to switch to the different values but quite […]

The post Asymmetric grid reporting appeared first on XLCubed Blog.

]]> ../../../2012/08/asymmetric-grid-reporting/feed/ 0 One slicer, two reports! ../../../2012/07/one-slicer-two-reports/ ../../../2012/07/one-slicer-two-reports/#respond Wed, 18 Jul 2012 09:06:52 +0000 http://blog.xlcubed.com/?p=3527 So today’s blog is going to show you how easy it is in XLCubed to have a slicer driving a grid and a SQL table at the same time.  There may be occasions when some of the information you require for your report is held not in an analysis services cube but a SQL table.  […]

The post One slicer, two reports! appeared first on XLCubed Blog.

]]> ../../../2012/07/one-slicer-two-reports/feed/ 0 Creating tree-view slicers in v7 ../../../2012/05/creating-tree-view-slicers-in-v7/ ../../../2012/05/creating-tree-view-slicers-in-v7/#respond Tue, 15 May 2012 14:28:07 +0000 http://blog.xlcubed.com/?p=3324 XLCubed has always provided a tree view selector to let users chose items from different levels in a hierarchy.   Previously, however, it was only possible to do this directly from a cube-based hierarchy. With the extension of our SQL reporting capability in V7 we found a few scenarios where we wanted to create tree […]

The post Creating tree-view slicers in v7 appeared first on XLCubed Blog.

]]> ../../../2012/05/creating-tree-view-slicers-in-v7/feed/ 0 “Prev” and “Next” in XLCubed Slicers ../../../2011/07/prev-and-next-in-xlcubed-slicers/ ../../../2011/07/prev-and-next-in-xlcubed-slicers/#respond Mon, 25 Jul 2011 12:07:44 +0000 http://blog.xlcubed.com/?p=2516 We’ve been asked a few times in the last couple of months if we can build a ‘Previous / Next’ selector for date hierarchies, which allows the user to quickly navigate sequentially through months or days. The answer is of course ‘yes’,  otherwise it would be a very short blog.. One of the key strengths […]

The post “Prev” and “Next” in XLCubed Slicers appeared first on XLCubed Blog.

]]> ../../../2011/07/prev-and-next-in-xlcubed-slicers/feed/ 0