<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>blog.xlcubed.com</title>
	<link>http://blog.xlcubed.com</link>
	<description>The Blog of XLCubed</description>
	<lastBuildDate>Tue, 31 Jan 2012 09:42:56 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>Streamlining writeback with XL3DoWriteback</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.xlcubed.com/2012/01/streamlining-writeback-with-xl3dowriteback/</link>
			</item>
	<item>
		<title>Between and Member Searching</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.xlcubed.com/2012/01/between-and-member-searching/</link>
			</item>
	<item>
		<title>Breakout and Propagate &#8211; Oldies but Goodies</title>
		<description><![CDATA[We&#8217;ve been on-site with various customers in the last few months, it&#8217;s always good to see how the product is being used, and we value customer feedback, which often feeds into our development cycle. With two long-term customers we found that they weren&#8217;t aware of two very useful pieces of functionality which have been in [...]]]></description>
		<link>http://blog.xlcubed.com/2012/01/breakout-and-propagate-oldies-but-goodies/</link>
			</item>
	<item>
		<title>Drive Excel Chart Min/Max from Range</title>
		<description><![CDATA[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&#8217;t been added to the base product. It&#8217;s a very common scenario to come across, you are building [...]]]></description>
		<link>http://blog.xlcubed.com/2011/10/drive-excel-chart-minmax-from-range/</link>
			</item>
	<item>
		<title>2011 Dashboard Competition</title>
		<description><![CDATA[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&#8217;s first dashboard design contest. The competition is based on a provided data set, and [...]]]></description>
		<link>http://blog.xlcubed.com/2011/09/2011-dashboard-competition/</link>
			</item>
	<item>
		<title>Scheduling Reports with XLCubed</title>
		<description><![CDATA[With version 6.2, XLCubed introduces a new feature that we&#8217;ve had enquiries about for a while now: the ability to send scheduled reports to email recipients. In this post we&#8217;ll go over the basics of how it works and why you might want it. The Scenario As report designers and publishers, it&#8217;s our job to [...]]]></description>
		<link>http://blog.xlcubed.com/2011/09/scheduling-reports-with-xlcubed/</link>
			</item>
	<item>
		<title>Solve order shenanigans</title>
		<description><![CDATA[Today I&#8217;m going to blog about a problem we recently solved in a client&#8217;s cube, an error in the Mdx script that&#8217;s very easy to make if you aren&#8217;t careful. We&#8217;ll run a simple example in AdventureWorks (what else?) to demonstrate the issue. The client had already added a calculation to their cube to show [...]]]></description>
		<link>http://blog.xlcubed.com/2011/09/solve-order-shenanigans/</link>
			</item>
	<item>
		<title>Warning: Excel can get Volatile</title>
		<description><![CDATA[Excel is a great tool for dashboard/report delivery and design (it&#8217;s why we created our addin in the first place), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you&#8217;ve ever used any of these formulae, you may have noticed that whenever you change a cell, or collapse/expand [...]]]></description>
		<link>http://blog.xlcubed.com/2011/08/warning-excel-can-get-volatile/</link>
			</item>
	<item>
		<title>Ranking, Sorting and Filtering</title>
		<description><![CDATA[Once we have returned cube members into a grid report we often need to exclude or change the order of the result set to provide more meaningful information. MDX (Multidimensional Expressions) language includes some very useful operators to provide filtering (FILTER), sorting (ORDER) and ranking (TOPCOUNT/BOTTOMCOUNT) of dimension members. These can be quite overwhelming even [...]]]></description>
		<link>http://blog.xlcubed.com/2011/08/ranking-sorting-and-filtering/</link>
			</item>
	<item>
		<title>Small Multiples on River Quality</title>
		<description><![CDATA[The phrase small multiple was popularised by Edward Tufte, and has become a generic term for a visual display using the same chart or graphic to display different slices of a data set. Their close positioning and shared scale make comparisons very easy and shared trends or outliers can be quickly spotted. Various other terms are [...]]]></description>
		<link>http://blog.xlcubed.com/2011/08/small-multiples-on-river-quality/</link>
			</item>
</channel>
</rss>

