Processing options in AS2005

I'm trying to get my hand around these new fangled processing options in SSAS2005 and have read TK Anand's excellent paper on the subject: http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp.

Unfortunately I can't see the wood for the trees so here's a question. Is it possible to selectively remove data from a partition? i.e. Without doing a ProcessFull or ProcessClear

Here's the scenario for which i need this:

We have a cube into which we are loading returns (the nature of these returns is unimportant) submitted from external organizations. Each return can go through a series of statuses:

Submitted Received Accepted Approved Superceded

They want to see data for all 'Approved' returns. That's easy. However, a return becomes 'Superceded' we want to remove it from the cube. Is that possible? I don't want to have to do a full process every night because there is a huge amount of data and our processing window is small.

Thanks

Jamie

You have several ways to handle this problem.

One you can partition the data in your cube down futher. Creating several partitions. If you know range of data might change, create a separate parittion (or few partitions) for it .

Processing less data and processing in parralel should go way faster.

Second.

If you dont have many changes happening into your data. You just need to correct value for some transactions. You can enable Writeback for you measure group. Using Writeback you can "poke" 0 into any cell in multidimensional cube space. For instance you can zero out value of sales for User A on Day D.
Internally Analysis Serivces creates ROLAP partition where it writes corrective values.
You client application needs to be able to handle udates correctly. There are quite a few issues with writing into non-leaf cells.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward,

We were definately thinking of going down the partitions route so its good to get some confirmation of that approach.

Writing back from the client app is a no-no though - for reasons I won't go into.

-Jamie