Hi all,

Does anyone know how to programmatically count the fact table rows in a
SQL 2000 cube, using DSO?

I have a requirement for a utility to monitor the last processed date
and the fact table size for production cubes.

I can easily get the "FactTableSize" property, but this is just the fact
table size that was put into the cube when first built, or when last
manually counted from Analysis Manager, so it is always out of date. I
assume that the method to count the rows is exposed, but I can't find it
documented, nor in a day plus of exploring the object model manually.

Also, is there any issue with doing this - eg would it for some strange
reason force a re-process to be required?


Thanks as ever,


Richard R.

Actually, I do not believe DSO does the count at all - Analysis Manager send
a "select count(*)" query to the fact table in question to populate the
FactTableSize property. The reason one populates this value is to allow the
Analysis Services engine to better design aggregations based on the amount
of data that is in there. For your utility, I would just either do your own
"select count(*)" query or insure that your cube has a count measure such
that you can do an ADO/MD call to query that measure.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Richard A Rose" <rrose (AT) nospaminforms (DOT) co.uk> wrote

Hi Denny,

Thanks for that.

I had concluded I would have to do a select count(*) on the underlying
database to get the row count - but that of course doesn't reflect if
the cube hasn't processed.

Using a COUNT measure in the cube is a good idea though, all the cubes
have a count so I can do that.

Many thanks,

Richard


Denny Lee wrote:

Get a download of the BI Accelerator (SSABI)
http://www.microsoft.com/sql/ssabi/default.mspx
Included in it is a utility called the Partition Aggregation Utility. It has
a facility for recounting the fact and dimension tables and setting them via
DSO. It is included in source form (it is a VB6 application).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Richard A Rose" <rrose (AT) nospaminforms (DOT) co.uk> wrote