Dear all,
One method of processing / updating OLAP dimensions and
cubes automatically is adding packages with DTS tasks, and then adding
jobs in SQL Server Agents.
Is there another method for updating OLAP cubes
automatically?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Annie

O2OLAP for Excel provides the ability to process, update and create
dimensions and cubes through Excel. In addition, there are some easy and
streamlined processes and tools to help in the fast development and
maintenance of Analysis Services solutions. Solutions are developed in a
matter of hours.

Howard.Taylor@ domain below
www.o2olap.com


"Annie" <None> wrote

You can use DSO (coding with VB is pretty straight forward and you can use
COM-interop and code DSO via the DotNet Framework).

dlr

"Howard Taylor [O2OLAP]" <Remove.Howard.Taylor (AT) o2olap (DOT) com> wrote

Dear All,

Where can i get DSO sample code? Thx a lot!!

Regard
Annie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

BOL has some very simple, VB6 examples. For a better source use COM-Interop
and see the excellant code example by Barry Hensch at:
dbforums.com/arch/67/2002/12/584920

[this code was originally published in this microsoft forum]

best of luck - jump in - its fun(ny).

dlr

"Annie" <None> wrote

oops - barry's code is VB not Dot Net. - I may post some code of my own
using dot net - which the powers that be would publish some baseline code
using the framework to drive DSO however....


"Dennis Redfield" <dennis.redfield (AT) acadia-ins (DOT) com> wrote

Dear all,
I viewd and trying to compile the sample code from Barry Hensch
at: dbforums.com/arch/67/2002/12/584920.
There is a compile error at

Dim dsoServer As New DSO.Server

It seems there is no DSO object in my PC (I compiled the program in
Win98)

should the program compile in win 2000 that the Analysis Server is
alresdy installed??

Annie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

1) Yes DSO system of COM objects must be available (and registered to your
D.I.).
2) This may be independently re-distributable (?) but you should just go
ahead and install the management components (not the engine) from SS and AS
on to your local machine.
3) In general I advise you not to use a version of windows prior to Win2K
for development of this type of software although MS thinks that it's ok I
quess.

"Annie" <None> wrote

what is the mening of "local machine"?? it means win98?? or it can only
compile the program in win2k that is alredy installed MSSQL server and
analysis Server?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Annie,

If I have misunderstood, I think the local machine Dennis mentioned
indicates the machine which is used to compile the VB code. Also, he
suggested you install the management components (Client tools of SQL Server
and Analysis Services).

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.