dbTalk Databases Forums  

VBScript and NextAnalysisStep

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


Discuss VBScript and NextAnalysisStep in the microsoft.public.sqlserver.olap forum.



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

Default VBScript and NextAnalysisStep - 06-12-2004 , 06:37 PM






I have the following segment of code in VB that works just fine (it's a DSO
method call). It won't work in VBScript (DTS ActiveX task). When I debug I
get "Microsoft VBScript runtime error: Type mismatch:
'dsoPartitionAnalyzer.NextAnalysisStep'". I've tried explicitly casting the
parameter variables with conversion functions prior to the method call and I
still get the same error. I also tried "ByRef" and that wouldn't even parse
successfully.

Is this something I can't do in VBScript?

=== Code segment ===
Set dsoPartitionAnalyzer = dsoPartition.Analyzer

' Initialize the analyzer.
dsoPartitionAnalyzer.InitializeDesign
..
..
..
..
Do While dsoPartitionAnalyzer.NextAnalysisStep(PercentageBe nefit,
AccumulatedSize, AggregationsCount)
If PercentageBenefit > 100 Then
Exit Do
End If
Loop
=== End code segment ===


Thanks in advance!!
Erin



Reply With Quote
  #2  
Old   
Ramunas Balukonis
 
Posts: n/a

Default Re: VBScript and NextAnalysisStep - 06-14-2004 , 02:12 AM






Hello,
I had the same problem. I tried to use NextAnalysisStep in VBScript,
JScript. I had the same problem. The solution is to use default partition,
create the aggragates for him, and creating a new partition, just copy the
structure and aggragates from the default partition.

Ramunas Balukonis


"Erin" <erin_welker (AT) hotmail (DOT) com> wrote

Quote:
I have the following segment of code in VB that works just fine (it's a
DSO
method call). It won't work in VBScript (DTS ActiveX task). When I debug
I
get "Microsoft VBScript runtime error: Type mismatch:
'dsoPartitionAnalyzer.NextAnalysisStep'". I've tried explicitly casting
the
parameter variables with conversion functions prior to the method call and
I
still get the same error. I also tried "ByRef" and that wouldn't even
parse
successfully.

Is this something I can't do in VBScript?

=== Code segment ===
Set dsoPartitionAnalyzer = dsoPartition.Analyzer

' Initialize the analyzer.
dsoPartitionAnalyzer.InitializeDesign
.
.
.
.
Do While dsoPartitionAnalyzer.NextAnalysisStep(PercentageBe nefit,
AccumulatedSize, AggregationsCount)
If PercentageBenefit > 100 Then
Exit Do
End If
Loop
=== End code segment ===


Thanks in advance!!
Erin





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.