dbTalk Databases Forums  

FAct Table Size is 0

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


Discuss FAct Table Size is 0 in the microsoft.public.sqlserver.olap forum.



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

Default FAct Table Size is 0 - 06-20-2005 , 09:57 AM






Hi

when I try to process the cube, it throws an error 'Fact table size cannot
be 0'
when I browse data on the fact table I find that there is data in it.
Also checked all dimensions to ensure there is data in it. What could the
problem be?

Reply With Quote
  #2  
Old   
olap@gmsbv.nl
 
Posts: n/a

Default Re: FAct Table Size is 0 - 06-20-2005 , 10:04 AM






Hi,

Just change the setting from 0 to 1 and your cube will be processed!

Regards, Marco
www.gmsbv.nl

VDS schreef:
Quote:
Hi

when I try to process the cube, it throws an error 'Fact table size cannot
be 0'
when I browse data on the fact table I find that there is data in it.
Also checked all dimensions to ensure there is data in it. What could the
problem be?


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

Default Re: FAct Table Size is 0 - 06-20-2005 , 10:12 AM



thank U.. it works :-)

"olap (AT) gmsbv (DOT) nl" wrote:

Quote:
Hi,

Just change the setting from 0 to 1 and your cube will be processed!

Regards, Marco
www.gmsbv.nl

VDS schreef:
Hi

when I try to process the cube, it throws an error 'Fact table size cannot
be 0'
when I browse data on the fact table I find that there is data in it.
Also checked all dimensions to ensure there is data in it. What could the
problem be?



Reply With Quote
  #4  
Old   
Joseph Ollero
 
Posts: n/a

Default Re: FAct Table Size is 0 - 07-10-2005 , 10:20 PM



I have the same problem as VDS does. The only difference it that mine keeps
on recurring and I am left to changinf the fact table count again and again.

I cant figure out what causing this. My only theory is that most of my
dimension tables are view based and we often do some minor changes in the
views. Any thoughts on this?


<olap (AT) gmsbv (DOT) nl> wrote

Quote:
Hi,

Just change the setting from 0 to 1 and your cube will be processed!

Regards, Marco
www.gmsbv.nl

VDS schreef:
Hi

when I try to process the cube, it throws an error 'Fact table size
cannot
be 0'
when I browse data on the fact table I find that there is data in it.
Also checked all dimensions to ensure there is data in it. What could
the
problem be?




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.