Hi to all,
in my scenario, a Domino server periodically runs a procedure to
connect to a SQL Server and bulk inserting data. The connection is made
via oledb. Data are then used in a OLAP cube that I programmatically
query from the Domino server itself, to build web reports. Therefore, I
would like the cubes to be processed AT THE END of the bulk insert, so
that the process is correclty chained, and I don't have to take into
account how long the insert will take to wait for the cube process to
begin.

Is there a way to trigger a cube processing with a mdx query? Or, with
a different approach, can I trigger a DTS package that processes the
cube with a oledb remote connection? Both solutions would allow me to
fully control the sequence from my Domino server.

TIATAA (Thanx In Advance To All Advices....)

An MDX statement can't process a cube, but there are a couple of ways to do
what you need:

I believe the easiest way do what you want is to place an Analysis Services
Processing Task (its icon looks like a yellow cube in the DTS designer) at
the end of your DTS package that currently does the Bulk Insert. Just select
the server and cube you want to process, and which processing option (full,
refresh, incremental) and save the DTS package. Based upon what you've said,
it sounds like you'd want an "on success" workflow between the bulk insert
and subsequent cube process described above.

Another way is with DSO, but would require knowledge of DSO coding. You
could write a DSO exe and call it as well via your DTS package.

Good luck.


"moco" wrote: