dbTalk Databases Forums  

Unable fact table rows

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


Discuss Unable fact table rows in the microsoft.public.sqlserver.olap forum.



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

Default Unable fact table rows - 06-07-2005 , 03:08 PM






Hi all Gurus

The cube start to count fact table rows and after some time it gives below
error message

Unable to count fact table rows. Please enter an approximate size for fact
table size property

What should i do now?



--
Thanks
Am



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Unable fact table rows - 06-07-2005 , 06:14 PM






Using the cube editor, look at the advanced properties.
You will see a property called "Estimated fact table count". Fill it in with
roughly the number of rows in the fact table.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AM" <anonymous (AT) developersdex (DOT) com> wrote

Quote:
Hi all Gurus

The cube start to count fact table rows and after some time it gives below
error message

Unable to count fact table rows. Please enter an approximate size for fact
table size property

What should i do now?



--
Thanks
Am





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.