Effective Management Reports – XLCubed Blog ../../../ XLCubed Blog Mon, 08 Apr 2019 08:06:46 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Effective Management Reports – XLCubed Blog ../../../ 32 32 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 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 Rolling Forecast reporting in Excel ../../../2013/03/rolling-forecast-reporting-in-excel/ ../../../2013/03/rolling-forecast-reporting-in-excel/#comments Wed, 27 Mar 2013 10:10:49 +0000 http://blog.xlcubed.com/?p=3827 In monthly reporting for the current year the most pertinent numbers for closed periods are the actuals, and for open or future months the forecast. In most cubes actual and forecast (or budget) are implemented as either different measures, or as part of a scenario hierarchy. This can lead to challenges in reporting, where putting […]

The post Rolling Forecast reporting in Excel appeared first on XLCubed Blog.

]]> ../../../2013/03/rolling-forecast-reporting-in-excel/feed/ 6 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 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 “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 Effective Management Reports? Interview with Rolf Hichert ../../../2008/06/effective-management-reports-interview-with-rolf-hichert/ ../../../2008/06/effective-management-reports-interview-with-rolf-hichert/#comments Fri, 27 Jun 2008 08:31:35 +0000 http://blog.xlcubed.com/?p=169 Professor Rolf Hichert is the foremost specialist for information design for financial professionals in the German speaking world. His seminars have been attended by thousands of CFO’s, financial controllers in Germany, Austria, Switzerland and the UK. Recently my friend Martin from INTALIGN had the pleasure to interview Professor Dr. Rolf Hichert about his view on […]

The post Effective Management Reports? Interview with Rolf Hichert appeared first on XLCubed Blog.

]]> ../../../2008/06/effective-management-reports-interview-with-rolf-hichert/feed/ 1