dbTalk Databases Forums  

VBS and DSO method NextAnalysisStep

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


Discuss VBS and DSO method NextAnalysisStep in the microsoft.public.sqlserver.olap forum.



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

Default VBS and DSO method NextAnalysisStep - 01-19-2004 , 04:55 AM






Hello,
when I try to call DSO methos NextAnalysisStep (PercentageBenefit As Double,
AccumulatedSize As Double, AggregationsCount As Long) of object
Partition.Analyzer, I get error Type Mismatch.
I would like to create cube partition each month and design aggregations
programatically. But this method expect exactly the same data types: Double,
Double and Long. As from VBScript there are no types, I get this error.
I tried to do the same from T-sql creatting objects , methods and properties
using sp_OACreate, sp_OAMethod, sp_OASetProperty. But I get the same error.
Because this periodical job I design in DTS package, I have another option -
write a JScript code. But efect was the same.
So I tried VBScript, JScript and T-SQL - efect was the same.
Is it possible to call this method without writing a dll?

Thanks a lot .



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.