dbTalk Databases Forums  

Cube corrupted?

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


Discuss Cube corrupted? in the microsoft.public.sqlserver.olap forum.



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

Default Cube corrupted? - 05-18-2005 , 12:54 AM






I am using a vbscript to clone the partitions in a cube. And I found that the
in the cube, I cannot use "for each m in dsoNewPart.Measures", it just return
an empty one (strange) and quit the loop. The cube has 4 measures.

However, I can use for J= 1 to 4 to access the Measures. Should it started
from 0? Or I have a corrupted measure at subscript 0?

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

Default RE: Cube corrupted? - 05-18-2005 , 01:01 PM






Btw, the dsoNewPart.Measures.Count return 4. And dsoNewPart.Measures(0)
return a void measure. But dsoNewPart.Measures(1) to dsoNewPart.Measures(4)
can get the right 4 measures.

"nick" wrote:

Quote:
I am using a vbscript to clone the partitions in a cube. And I found that the
in the cube, I cannot use "for each m in dsoNewPart.Measures", it just return
an empty one (strange) and quit the loop. The cube has 4 measures.

However, I can use for J= 1 to 4 to access the Measures. Should it started
from 0? Or I have a corrupted measure at subscript 0?

Reply With Quote
  #3  
Old   
SQL McOLAP
 
Posts: n/a

Default RE: Cube corrupted? - 05-19-2005 , 11:42 AM



No, the indexing starts at 1

"For i = 1 to .whatever.count" is correct.

If you tried zero and it bombed, don't worry your cube isn't corrupted,
you'll just get something like a "subscript out of range" type error, but you
haven't phsyically harmed the cube in any way.


"nick" wrote:

Quote:
I am using a vbscript to clone the partitions in a cube. And I found that the
in the cube, I cannot use "for each m in dsoNewPart.Measures", it just return
an empty one (strange) and quit the loop. The cube has 4 measures.

However, I can use for J= 1 to 4 to access the Measures. Should it started
from 0? Or I have a corrupted measure at subscript 0?

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.