dbTalk Databases Forums  

Hey, my cube is empty! What happened

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


Discuss Hey, my cube is empty! What happened in the microsoft.public.sqlserver.olap forum.

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

Default Hey, my cube is empty! What happened - 01-31-2007 , 10:42 AM






Hello all:

I am new to SSAS 2005 and not sure what happened here:

I have a simple cube with 1 Fact table and 4 dimensions. I can see that all
five tables have data. Even after processing the cube, it appears to be
empty. When I browse it (in BIDS, Excel, or SSMS) the dim attributes show up,
but it does not show any summary information from the measures.

Any ideas?

TIA ...
--
Todd Chittenden




Reply With Quote
  #2  
Old   
Todd C
 
Posts: n/a

Default RE: Hey, my cube is empty! What happened - 01-31-2007 , 12:22 PM






Oops.

Memo to self: don't ever delete the CALCULATE statement in the Calculations
Tab!

Hey, it wouldn't be considered a useful day unless I learned something new!

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

Default RE: Hey, my cube is empty! What happened - 03-24-2009 , 09:01 AM



Thanks, that was mine problem too.
The cube must have a script command which is exactly: CALCULATE

From http://www.developmentnow.com/g/112_...t-happened.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

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 - 2014, Jelsoft Enterprises Ltd.