dbTalk Databases Forums  

Cube with no data after procesing

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


Discuss Cube with no data after procesing in the microsoft.public.sqlserver.olap forum.



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

Default Cube with no data after procesing - 01-07-2006 , 05:04 PM






1 have a cube that was working ok.

I amended the mdx for one calculated member, reprocess and now all the
measures are showing empty. I have deleted the calculated member but all
measures are still empty.

I recreated a simple cube using come of the measures and dimension from the
existing cubes, but the new cube returns data.

Please help

Reply With Quote
  #2  
Old   
Renato
 
Posts: n/a

Default Re: Cube with no data after procesing - 01-09-2006 , 04:32 AM






A similar thing has happened to me and the cause was that I
inadvertently changed one of the hierarchies default member to be
something other than [All].
Another thing that caused a similar problem was setting aggregate to
false meaning that all was not created and the default member became
the 1st element in the dimension.
Hence when I queried the cube without specifying any member of the Date
hierarchy I got that element (which happened to be an accounting period
with no data)


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.