Reporting – XLCubed Blog ../../../ XLCubed Blog Mon, 20 Jan 2020 09:25:40 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Reporting – XLCubed Blog ../../../ 32 32 Grid Favourites ../../../2020/01/grid-favourites/ ../../../2020/01/grid-favourites/#respond Fri, 17 Jan 2020 14:29:43 +0000 https://blog.xlcubed.com/?p=5497 Do you ever find yourself creating the same grid over and over again? Sometimes we want to add the same grid multiple times but with a few variations, or in different workbooks. This can be especially tiresome if the grid has complex member selections or if the underlying data model has a large number of […]

The post Grid Favourites appeared first on XLCubed Blog.

]]> ../../../2020/01/grid-favourites/feed/ 0 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 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 Monitoring Data Comments ../../../2019/04/monitoring-data-comments/ ../../../2019/04/monitoring-data-comments/#respond Wed, 24 Apr 2019 13:03:56 +0000 https://blog.xlcubed.com/?p=5113 Many BI and reporting tools now allow users to collaborate directly with a report. This avoids the cumbersome backwards and forwards of email chains or the need to meet in person. As useful as this is, some organisations have concerns about the ability to monitor comments made. We will discuss this aspect in more depth […]

The post Monitoring Data Comments appeared first on XLCubed Blog.

]]> ../../../2019/04/monitoring-data-comments/feed/ 0 Advanced Grid Reporting – MDX: ../../../2019/04/advanced-grid-reporting-mdx/ ../../../2019/04/advanced-grid-reporting-mdx/#comments Thu, 11 Apr 2019 09:58:01 +0000 https://blog.xlcubed.com/?p=4712 This weeks blog is for the more technically minded among our user base and our partner network – not for everyone, but highlights some potentially very powerful capabilities! We will be looking at using MDX: and MDXSet: along with Query Generators to create sub-cubes, meaning we can develop advanced reports that would otherwise be difficult […]

The post Advanced Grid Reporting – MDX: appeared first on XLCubed Blog.

]]> ../../../2019/04/advanced-grid-reporting-mdx/feed/ 1 Linking it all together ../../../2019/04/linking-it-all-together/ ../../../2019/04/linking-it-all-together/#respond Thu, 04 Apr 2019 12:26:33 +0000 https://blog.xlcubed.com/?p=4739 As we’ve seen in the past, XL3Link is a flexible formula that is really worth knowing about to help easily build interlinked reports. To some extent it’s like a Swiss army knife – multi-purpose!  From highlighting a series on a chart to hosting a tooltip,  XL3Link is a flexible formula that can help make your reporting more interactive at multiple levels. […]

The post Linking it all together appeared first on XLCubed Blog.

]]> ../../../2019/04/linking-it-all-together/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 Data Mashups 101 ../../../2019/01/data-mashups-101/ ../../../2019/01/data-mashups-101/#respond Fri, 04 Jan 2019 09:25:37 +0000 https://blog.xlcubed.com/?p=4724 In an ideal world for report designers, all the data required for a report is available in one data source, and the structure and hierarchies perfectly match the reporting needs. Sadly, the world isn’t always ideal (just ask Theresa May…). We often see scenarios where users are reporting numerical data from Analysis Services but want […]

The post Data Mashups 101 appeared first on XLCubed Blog.

]]> ../../../2019/01/data-mashups-101/feed/ 0 Custom drill paths for Analysis Services reporting ../../../2013/12/report-level-custom-drill-paths-for-analysis-services/ ../../../2013/12/report-level-custom-drill-paths-for-analysis-services/#respond Tue, 03 Dec 2013 10:11:06 +0000 http://blog.xlcubed.com/?p=4077 Any business report will answer a predefined set of questions, but it will often give rise to many additional queries and chains of thought as the user wants to explore any oddities or anomalies in more depth. As a report designer you want to provide flexibility in your reports. You may want to create a […]

The post Custom drill paths for Analysis Services reporting appeared first on XLCubed Blog.

]]> ../../../2013/12/report-level-custom-drill-paths-for-analysis-services/feed/ 0