dbTalk Databases Forums  

Cube Processes - No Measures!

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


Discuss Cube Processes - No Measures! in the microsoft.public.sqlserver.olap forum.



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

Default Cube Processes - No Measures! - 08-04-2006 , 12:35 PM






Anyone have experience with processing a cube, the dimensions are all
browseable, but the measures are empty?

What are the typical causes?

tia,

paul

Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Cube Processes - No Measures! - 08-05-2006 , 04:58 AM






Check that you calculation script has

CALCULATE;

as the first line. If it is missing you get the behaviour you describe.
If the calculate statement is missing the measures are not aggregated
and you will only see figures if you drill down to a leaf member on all
the dimensions.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <518A5AD1-3F3C-4B90-B1EF-D683C00EB8B7 (AT) microsoft (DOT) com>,
paulbihs (AT) discussions (DOT) microsoft.com says...
Quote:
Anyone have experience with processing a cube, the dimensions are all
browseable, but the measures are empty?

What are the typical causes?

tia,

paul



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.