how to recount number of rows in dimensions and partitions? (SSAS2005)

#1

Hi,

I'm writing an utility to try to recount the number of rows in my dimensions
and partitions.
Then I'll do by code a design aggregation.

I see the "EstimatedRows" property, but how to ask SSAS to count this again?

In fact, my dev server is connected to a subset sample of data, I deploy my
solution on multiple servers, each one has a different number of rows in the
source database.
So to make sure I have the correct aggregation design, I have to insure the
right estimated rows for each object.

So, I'm looking for sample code to count the rows again.

Thanks for your help and guide.

Jerome.

#2

Hi Jerome

I have the same problem. Can anyone help?
Jéjé wrote:

Quote:

Hi,

I'm writing an utility to try to recount the number of rows in my dimensions
and partitions.
Then I'll do by code a design aggregation.

I see the "EstimatedRows" property, but how to ask SSAS to count this again?

In fact, my dev server is connected to a subset sample of data, I deploy my
solution on multiple servers, each one has a different number of rows in the
source database.
So to make sure I have the correct aggregation design, I have to insure the
right estimated rows for each object.

So, I'm looking for sample code to count the rows again.

Thanks for your help and guide.

Jerome.

#3

well...
I have developed my own utility to do this job.

"amitk" <amit.kar (AT) gmail (DOT) com> wrote

Hi Jerome

I have the same problem. Can anyone help?
Jéjé wrote:

Quote:

Hi,

I'm writing an utility to try to recount the number of rows in my
dimensions
and partitions.
Then I'll do by code a design aggregation.

I see the "EstimatedRows" property, but how to ask SSAS to count this
again?

In fact, my dev server is connected to a subset sample of data, I deploy
my
solution on multiple servers, each one has a different number of rows in
the
source database.
So to make sure I have the correct aggregation design, I have to insure
the
right estimated rows for each object.

So, I'm looking for sample code to count the rows again.

Thanks for your help and guide.

Jerome.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to recount number of rows in dimensions and partitions? (SSAS2005)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

how to recount number of rows in dimensions and partitions? (SSAS2005) - 10-25-2006 , 09:18 AM

Re: how to recount number of rows in dimensions and partitions? (SSAS2005) - 12-21-2006 , 05:32 AM

Re: how to recount number of rows in dimensions and partitions? (SSAS2005) - 12-21-2006 , 07:46 AM