Um.
Probably the best way to think of Analysis Services is that it's the
server-side equivalent of an Excel pivot table (that is, rather than the client
- excel - having to do the pivoting itself from the raw data, the pivoting can
be done on the server and the client only gets the results).
Does the existing data provide a seed or default for a new row (which can be
overwritten), or is it a true accumulation (which cant)? And if the latter, how
much data are we talking about?
You can use lead and lag in SQL (2012) to perform these kind of projections,
but if generally suggest doi
