Is it common for some of you to check if your OLAP has processed
correctly by doing some kind of checks? Like if so and so measure is
XXX number then we are ok kind of thing?

I need to do this and wanted to know if I can do this using MDX query
etc. Any comments would be great.

In other words, how can I check a particular measure against a defined
number and pass a "Y" or "N" to the SSIS package that called the
checkprogram.

Hi,

Cubes, Measure Groups, Partitions, Dimensions etc all have a processed date
property associated with their meta-data - is this the kind of thing you're
after?

I checked these out using a small AMO .Net application that loops through
all the AS database objects, but you can also do it using ASSL too.

However, i found writing the XMLA scripts a nightmare!
--
Kyle Henly
DBA
U.K.


"rahulchudiwal (AT) yahoo (DOT) com" wrote: