Member Selection – XLCubed Blog ../../../ XLCubed Blog Thu, 11 Apr 2019 09:53:04 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Member Selection – XLCubed Blog ../../../ 32 32 Member Searching To Create A Product Details Page ../../../2019/03/member-searching-to-create-a-product-details-page/ ../../../2019/03/member-searching-to-create-a-product-details-page/#respond Wed, 27 Mar 2019 10:13:03 +0000 https://blog.xlcubed.com/?p=5080 XLCubed is a great tool when it comes to member searching: it allows you to quickly and easily find members as well as dynamically update a report based on search parameters. Take a read of our last post to get started with this functionality. The example in this post uses these searching methods to create […]

The post Member Searching To Create A Product Details Page appeared first on XLCubed Blog.

]]> ../../../2019/03/member-searching-to-create-a-product-details-page/feed/ 0 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 Current and Previous month reporting made easy ../../../2013/07/current-and-previous-month-reporting-made-easy/ ../../../2013/07/current-and-previous-month-reporting-made-easy/#respond Thu, 18 Jul 2013 12:07:13 +0000 http://blog.xlcubed.com/?p=3896 We’ve all been there. Our shiny new dashboard or report pack is finished and ready to go meet its users.  We’ve presented the key information clearly, we’ve followed all the data vis guidelines on effective charting and use of colour. We like it a lot, and we’ve thought ahead and built in lots of flexibility […]

The post Current and Previous month reporting made easy appeared first on XLCubed Blog.

]]> ../../../2013/07/current-and-previous-month-reporting-made-easy/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 Excluding members in XLCubed ../../../2012/05/excluding-members-in-xlcubed/ ../../../2012/05/excluding-members-in-xlcubed/#respond Thu, 31 May 2012 08:35:56 +0000 http://blog.xlcubed.com/?p=3378 So today we are going to show you how you can easily exclude members from your XLCubed reports.  Here we have a simple grid which shows lowest level descendants of Promotions on rows and Geography on columns.               We would like to rank this report and also exclude the Promotion […]

The post Excluding members in XLCubed appeared first on XLCubed Blog.

]]> ../../../2012/05/excluding-members-in-xlcubed/feed/ 0 Between and Member Searching ../../../2012/01/between-and-member-searching/ ../../../2012/01/between-and-member-searching/#comments Thu, 26 Jan 2012 13:32:52 +0000 http://blog.xlcubed.com/?p=3231 Our blog today takes a look at two new features available in v6.5 – Between and Member Searching. Between In v6 we give our users  the ability to enter a reporting range for their grid reports by allowing them to enter a  ‘From’ and a ‘To’ range on a hierarchy. The only thing to remember […]

The post Between and Member Searching appeared first on XLCubed Blog.

]]> ../../../2012/01/between-and-member-searching/feed/ 3