dbTalk Databases Forums  

Quantity of Rows processed too low

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


Discuss Quantity of Rows processed too low in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Damian
 
Posts: n/a

Default Quantity of Rows processed too low - 01-08-2005 , 09:23 AM






Hi,
When i process my cube, the process dialog say "Rows Processed: 300". But
the rowcount for my fact table is arroud 60000. Thanks.
Windows 2000 server
Analisys Server 2000 + SP3

Reply With Quote
  #2  
Old   
Martin Mason
 
Posts: n/a

Default Re: Quantity of Rows processed too low - 01-08-2005 , 09:22 PM






Sounds like its related RDBS schema. Check the SQL statement being used to
build the cube and make sure that every entity in your fact table has
matching records in your dimension tables.

"Damian" <Damian (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
When i process my cube, the process dialog say "Rows Processed: 300". But
the rowcount for my fact table is arroud 60000. Thanks.
Windows 2000 server
Analisys Server 2000 + SP3



Reply With Quote
  #3  
Old   
Damian
 
Posts: n/a

Default Re: Quantity of Rows processed too low - 01-09-2005 , 03:05 PM



Thank you Martin! was that. The model was wrong. The problem is a model that
have many "time dimensions" every one corresponding to a different field in
the fact table. In the original model (in the cube editor) the "time
dimensions" was defined on a unique table ("time_by_day") and fields in the
fact table joined to that table. I re-define dimensions and add one table per
dimension different and work fine. Thanks again

"Martin Mason" wrote:

Quote:
Sounds like its related RDBS schema. Check the SQL statement being used to
build the cube and make sure that every entity in your fact table has
matching records in your dimension tables.

"Damian" <Damian (AT) discussions (DOT) microsoft.com> wrote in message
news:5D2CE8F2-074E-43D2-A44C-F909BC9373A0 (AT) microsoft (DOT) com...
Hi,
When i process my cube, the process dialog say "Rows Processed: 300". But
the rowcount for my fact table is arroud 60000. Thanks.
Windows 2000 server
Analisys Server 2000 + SP3




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.