Hi,

We need to process a cube in "Incremental updates" mode on daily basis,
hence few questions related to the same.

- Is it possible ot define the filter dynaically ? i.e.
"transaction_table.transaction_date" = getdate() ( or some variable )
- Is is possible to schedule the cube processing i.e. during a partcular
time etc.?
- Is there some API's through which I could provide a GUI or Command line
interface to carry out the Cube processing with required parameters

Please help

Thank you ,

Shirish

Yes it is, there are a couple of approaches to this. You could use the
DSO library to set these in the cube. Or you could point the cube at a
view that used GetDate() or other SQL logic to select the correct
records.

Yes, the easiest way is to set up a DTS package to do the processing
(there is a built-in OLAP processing task) and then right click on the
package and schedule it.

The DSO library is a COM based interface which gives you access to all
the functions that are available through Analysis Manager ie. you can
create, alter, process etc.

AS Operations Guide white paper at:
http://www.microsoft.com/technet/pro...ntain/anservog.
mspx

Has some good DSO samples including one on determining data slices.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Another option to dynamically control the incremental update filter (for
AS 2000)in a DTS package is to add a Dynamic Properties task. This
allows some properties of an existing OLAP Processing task (such as its
filter) to be set programmatically, during runtime:

http://www.sqldts.com/default.aspx?252
using VB.

By Allan Mitchell
Version 2000
Level Advanced

With the introduction of SQL Server 2000 came the Dynamic Properties
task. This allows you to read connection settings, table names and just
about everything else for your DTS package from an INI file, a Global
Variable, an Environment variable, a Query, a Constant or a Data File.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***